Paged Datagrid and input (Dreamweaver)

[bencooke]

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