Samples

Using PGNP with Microsoft .NET

Samples

Postby Moderator » Sat Apr 11, 2009 6:01 pm

When installed, PGNP contains following samples under \samples\<language> folders.

C#:
01_GetRecords.cs demonstrates how programmatically connect to PostgreSQL database and get records from pgnp_samples.contact table.
02_SingleValue.cs demonstrates getting single value from database. It reads number of contacts with last name starting with 'S'.
03_InsertUpdateDelete.cs demonstrates creation of a temporary table, records insert, update and delete.
04_CommandParameters.cs demonstrates passing positional and named parameters to a command.
05_StoredProcedures.cs demonstrates how to call stored procedures returning a single result and multiple results.

10_Arrays.cs demonstrates how to query multidimentional arrays in .NET.
11_NestedTransactions.cs demonstrates how to work with nested transactions in .NET.
12_DistribTrans.cs demonstrates how to work with distributed transactions in .NET (TransactionsScope object).
Important: Make sure that "Distributed Transaction Coordinator" system service is running before launching this test.
13_SavePoints.cs demonstrates how to control transactions via PostgreSQL SAVE POINTs.

CPP:
ADOEvents demonstrates howto subscribe for ADO connection and recordset events.
OLEDBTemplates demonstrates:
* howto pass input parameters and get output parameters from stored procedure using OLEDB templates (StoredProcParams.cpp).
* howto select records from a table and insert data using OLEDB templates (SelectInsert.cpp).

Delphi:
TestGrid demonstrates howto populate grid with records from database.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Samples

Postby eugeneng » Mon Apr 28, 2014 12:24 am

HI, recently I downloaded and installed the trial version of Cassandra Oledb Provider. when I try to run the C# sample, it crashes at Sample02_SimpleQuery() function inside the file : 02_SimpleQuery.cs, line 24, with System Access Violation exception: {"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."}

and I received similar error when I tried to use SSIS to import 10 rows of record into Cassandra database.

is this the limitation of the trial version?

I would like purchase the software provided it is error free.
eugeneng
 
Posts: 4
Joined: Mon Apr 28, 2014 12:14 am

Re: Samples

Postby Moderator » Mon Apr 28, 2014 9:44 am

Hi,
what version of Cassandra are you using? I will double check how the samples work, and will update this thread.

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Samples

Postby eugeneng » Mon May 05, 2014 2:10 am

[cqlsh 4.1.0 | Cassandra 2.0.4 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
eugeneng
 
Posts: 4
Joined: Mon Apr 28, 2014 12:14 am

Re: Samples

Postby Moderator » Fri May 09, 2014 1:27 am

We have published build 3248 with fixes for the Cassandra provider. Please obtain the latest module from link http://www.pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Swiss Replica Hublot Big Bang watches, prices, uk, usa

Postby epromwebsites » Tue Sep 16, 2014 11:50 am

<strong><a href="http://www.watchestrading.com/">swiss replica watches</a></strong>
<br>
<strong><a href="http://www.watchestrading.com/">replica watches</a></strong>
<br>
<a href="http://www.watchestrading.com/">swiss Mechanical movement replica watches</a>
swiss Mechanical movement replica watches
swiss Mechanical movement replica watches
swiss Mechanical movement replica watches
high quality replica watches for men
high quality replica watches for men

Swiss Hublot Big Bang
Swiss movement replica Hublot Big Bang within our store are carefully selected. We have been focused on the greatest level of service. Trust our experience. If you would like help, please contact our sales department.http://www.watchestrading.com
http://www.watchestrading.com
If you are searching for the specific type of watch that is not inside our store, please call us today. Certainly, we certainly have it so we can prepare the perfect price to suit your needs.http://www.watchestrading.com
http://www.watchestrading.com
We recommend you to view more beautiful watches on Swiss Hublot Classic Fusion , Swiss Hublot King Power AND Swiss Breitling Chronomat Evolution , I am sure that you will find your fancy watch in our store.http://www.watchestrading.com
Items 1 to 15 of 76 total http://www.watchestrading.com
Show
15
30
45
per page
Page:
1
2
3
4
5
View as:
Grid
List
Sort By
Position
Name
Price
Hublot 301.CX.130.RX Big Bang Mens Automatic PVD Black Swiss 7750
Regular Price:
$627.02
Special Price:
$576.86
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 703.ZM.1123.NR.FMO10 Big Bang King Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.PX.1180.RX Big Bang Evolution Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 341.PB.131.RX Big Bang Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.PX.1180.RX. 1704 Big Bang Mens Automatic Stainless Steel Black Swiss 7750
$757.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot Big Bang Flying Tourbillon Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.AM.130.RX.YCM07 Big Bang Monaco Yacht Club Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.PE.2180.RW. 1104 Big Bang Porto Cervo Evolution Mens Automatic Stainless Steel White Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.PX.130.RX.114 Big Bang Evolution Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 305.tm.131.rx Big Bang Flying Tourbillion Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot Big Bang Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.CI.1770.RX Big Bang Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 301.SX.130.SX Big Bang Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot 705.OM.0007.RX Flying Tourbillion Mens Automatic Stainless Steel Black Swiss 7750
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Hublot Big Bang TOURBILLON Mens Automatic Stainless Steel Black Swiss Tourbillion
$627.02
Add to Cart
Details
Add to Wishlist
| Add to Compare
Items 1 to 15 of 76 total
Show
15
30
45
per page
Page:
1
2
3
4
5
View as:
Grid
List
Sort By
Position
Name
Price
swiss replica watches
replica watches


<a href="http://luxurywatchesonline57.webs.com"> watches blog </a>

<a href="http://outletmoncler82.webs.com"> watches </a>

About watchestrading.com blog
epromwebsites
 
Posts: 85
Joined: Tue Sep 16, 2014 11:30 am


Return to .NET

Who is online

Users browsing this forum: No registered users and 1 guest

cron