TableAdapter Commands on PostgreSQL Direct.

quietfulness · Post by **quietfulness** » Sat 12 Aug 2006 07:49

Good Day.

I created a form in Visual Studio 2005, Added a datagridview to databind it to a datasource
upon form load.

I created a dataset that contains different tables from different databases (SQL Server 2000, MS Access, Posgres 8.1) by dragging from the tables in the Server Explorer to the dataset.

Reviewing the Tables and the generated TableAdapter. I noticed that TableAdapters from SQL Server and MSAccess have generated the InsertCommand, UpdateCommand, DeleteCommand and SelectCommand, while the TableAdapter of Postgres has only SelectCommand and InsertCommand generated. And with that, I cannot call the TableAdapters' Update Method, it will generate and exception since the UpdateCommand and the Delete Command is not generated.

Data Binding on controls in VS2005 designer relies on BindingSource and TableAdapters, which i think makes it easy to add and update data compared to Data Adapters.

The Tables have simple structure, it has a primary key, other fields and contains data.

How can I solve this problem, I hope that PostGreSQL Direct can work fully with VS2005 TableAdapters.

Any advise and help would be greatly appreciated.

Thank you very Much.

Alexey · Post by **Alexey** » Wed 16 Aug 2006 06:30

What version of PostgreSQLDirect do you use? Try the latest one.

quietfulness · Post by **quietfulness** » Wed 16 Aug 2006 07:55

Good Day. Thanks for your reply.

I am using PostgreSQLDirect Data Provider for .NET 2 Professional.

Hoping for your soonest advise.

Thank you very much.

Alexey · Post by **Alexey** » Wed 16 Aug 2006 08:57

I mean what is the full version? I can't reproduce the error with the latest one.

Guest · Post by **Guest** » Wed 16 Aug 2006 16:30

Hello.

I am using PostgreSQLDirect.NET version 2.50 Professional

Thanx for the help. Thank you very much.

quietfulness · Post by **quietfulness** » Wed 16 Aug 2006 16:52

Hello.

Im using PostgreSQL Direct.NET version 2.50, when I looked at my licenses.licx file it states version=2.50.17.0

Thank you very much.

Alexey · Post by **Alexey** » Thu 17 Aug 2006 06:57

We are investigating this problem. You will be notified on results as soon as possible.

quietfulness · Post by **quietfulness** » Sat 19 Aug 2006 17:50

Hi

Thank you for your reply. Hope to hear from you soon. I will be working on with the pgsql commands for the moment.

Tnx.

Alexey · Post by **Alexey** » Tue 29 Aug 2006 12:14

We have scrutinized this behaviour thoroughly. If the table doesn't have a primary key, then Update and Delete commands are not to be generated. This restriction is imposed by Microsoft and we cannot change anything.

quietfulness · Post by **quietfulness** » Thu 31 Aug 2006 06:14

Hi.

Thank you very much for your reply.

I am using postgres 8.1.3, i tried several tables. All of them have
primary keys. as i drag a table from the server explorer in to
the dataset, still the update and delete commands are not created.

So, i used the pgsqlDataAdapter to create tableadapter commands using
it's dataset wizard. but the problem is that if you have several datatables
in your dataset, the dataset wizard will include them all, so you'll be
setting commands for all the tables. It would have been better if you can
select table(s) in which you can generate the commands.

Another thing is that when i add another query in the tableadapter generated
by the pgsqlAdapter dataset wizard, such as a select query with parameters,
(e.g. select * from tbl where :col = :search), it will generate
an error.

Thank you very much for your help and support.

Alexey · Post by **Alexey** » Thu 31 Aug 2006 07:55

It's next to impossible.
Please provide us with a script for tables creation and detailed scenario on how to get the exceptions raised.

quietfulness · Post by **quietfulness** » Wed 11 Oct 2006 02:00

Good Day.

I have already sent through support at crlab.com the videos regarding the issues of tableadapters, which doesnt generate the update and delete commands, and the parameters on tableadapter queries, which generates an error, similar to Thomas Holschen's post.

Hope that this bug will fixed, Thank you very much.

Alexey · Post by **Alexey** » Wed 11 Oct 2006 07:54

I will be looking forward to receiving your videos.

quietfulness · Post by **quietfulness** » Thu 19 Oct 2006 03:23

good day.

may i know if the issues and bugs of postgres sql direct.net has been fixed, particularly

* tableadapters - it wont generate update and delete commands even
if tables had primary keys
* tableadapter query parameters - creating parameters on tableadapter
queries will result an error, thus limiting the use of multiple
tableadapter queries

thank you very much

Alexey · Post by **Alexey** » Thu 19 Oct 2006 06:47

We still haven't received any mail from you. Could you please check this and re-send?