Page 1 of 1

generate sql command in mysqldatasource

Posted: Fri 25 May 2007 11:33
by RJordan
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.

Posted: Tue 29 May 2007 06:31
by Alexey
When configuring MySqlDataSource add WHERE clause to your select command pressing "WHERE..." button. Then press "Advanced..." button and tick appropriate checkbox.

Posted: Wed 13 Jun 2007 18:59
by RJordan
Sorry, but the appropriate checkboxes are disabled und cannot be selected.

Posted: Thu 14 Jun 2007 12:34
by Alexey
Please provide me with screenshots and your table definition.
Are you using the latest version of MySQLDirect .NET?