Paged Datagrid and input (Dreamweaver)
Hi ,
I have used Dreamweaver and have created an editable Datagrid for some f my data which works great.
My next step is having an input form to enter values to the database. I can get this to work too but theres a hiccup:
I display a paged datagrid above the entry form so you can see other data as you are inputting. However if you want to look at another 'page' of the grid i get an error and the new page is not always displayed.
here is the error:
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '?'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()
I think it is trying to input when the page is changed. this could be dangerous for me. How can I stop it?
thank you
beNcooKe