Update command when using SqlDataSource control in combination with ASP.NET GridView control
Posted: Tue 28 Mar 2006 08:15
Does anyone know how to format an Update command in an ASP.NET SqlDataSource control when using it with a GridView control?
I have done it before with SqlServer, but i cannot get it to work with MySql.
This is what i have done:
"
EnableCaching="True" ProviderName=""
SelectCommand="SELECT bstid, bstnam, bstgsl, bstadr, bsthnr, bstpcd, bstplt, bsttel FROM bestel"
UpdateCommand="UPDATE bestel SET bstnam = @bstnam, bstgsl = @bstgsl, bstadr = @bstadr, bsthnr = @bsthnr, bstpcd = @bstpcd, bstplt = @bstplt, bsttel = @bsttel WHERE bstid = @bstid;">
In SqlServer this should work fine. Does anyone know how i can get it to work with the MySQLDirect.NET provider ?
I have done it before with SqlServer, but i cannot get it to work with MySql.
This is what i have done:
"
EnableCaching="True" ProviderName=""
SelectCommand="SELECT bstid, bstnam, bstgsl, bstadr, bsthnr, bstpcd, bstplt, bsttel FROM bestel"
UpdateCommand="UPDATE bestel SET bstnam = @bstnam, bstgsl = @bstgsl, bstadr = @bstadr, bsthnr = @bsthnr, bstpcd = @bstpcd, bstplt = @bstplt, bsttel = @bsttel WHERE bstid = @bstid;">
In SqlServer this should work fine. Does anyone know how i can get it to work with the MySQLDirect.NET provider ?