asp.net FormView (automatic Parameters) bind to MySqlDataSource

asp.net FormView (automatic Parameters) bind to MySqlDataSource

Postby Kim » Mon 08 Oct 2007 16:16

Hey,

I've got an asp.net WebForm with a FormView in insert mode bind to a MySqlDataSource. The InsertCommand is set to a stored procedure with several input parameters. There several Textboxes bind to MySql data columns. For every bound Textbox i get an automatic created parameter in the textboxes appearance order.

My parameters order in the stored procedure is different and so i get wrong values in the data columns on the MySql server.

Do the parameters order from the MySqlDataSource have be in the same order as they are declared in the stored procedure ?

Is it possible to use MySqlDataSource like MS SqlDataSource in conjunction with MS Sql Server ?
Kim
 
Posts: 1
Joined: Mon 08 Oct 2007 15:57

Postby Alexey » Tue 09 Oct 2007 07:43

Please send me a small test project to reproduce the problem.
Include the definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL