generate sql command in mysqldatasource

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
RJordan
Posts: 14
Joined: Tue 07 Nov 2006 11:45
Location: Germany

generate sql command in mysqldatasource

Post by RJordan » Fri 25 May 2007 11:33

MySqlDataTable privides a feature to automatic generate update, insert an delete commands with paramters. Is this feature available in MySqlDataSource? If yes, please advise how to do so.

Is there an example available to see, how a myqsldatasource works with a datagrid using sql commands with parameters?

Thanks for your help.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 29 May 2007 06:31

When configuring MySqlDataSource add WHERE clause to your select command pressing "WHERE..." button. Then press "Advanced..." button and tick appropriate checkbox.

RJordan
Posts: 14
Joined: Tue 07 Nov 2006 11:45
Location: Germany

Post by RJordan » Wed 13 Jun 2007 18:59

Sorry, but the appropriate checkboxes are disabled und cannot be selected.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 14 Jun 2007 12:34

Please provide me with screenshots and your table definition.
Are you using the latest version of MySQLDirect .NET?

Post Reply