I have a database datatable that I will be changing alot and don't wont to worry about declaring new BoundFields and Update statements in the Gridview.
So how do you suggest I dynamically build update statements? Should I loop through the Fields of the DataTable schema to create the parameters and SQL statement? The SQLDatasource has automatic UPDATE statement generator but you have to create it each time, right?
I'm new so if this is a stupid question please explain why.
So how do you suggest I dynamically build update statements? Should I loop through the Fields of the DataTable schema to create the parameters and SQL statement? The SQLDatasource has automatic UPDATE statement generator but you have to create it each time, right?
I'm new so if this is a stupid question please explain why.