Devart Forums

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.

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

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.

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

Hello.

I am using PostgreSQLDirect.NET version 2.50 Professional

Thanx for the help. Thank you very much.

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.

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

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.

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.

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.

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

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.

I will be looking forward to receiving your videos.

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

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