Dynamic gridView with editable columns

[Kurt Jakobsen]

Hi,
I would like to have a dynamic gridview (number of columns will change depending on project) and I would like to be able to change the value in a gridview cell and that the database tables will be updated when the grid view cell is updated. An edit button is too cumbersom for the operator.
Anybody know if this is possible, and if so, do you have a piece of sample for me? Preferrably C# aspx with MySql but anything that can get me further is appreciated.

[nateraaaa]

When are you planning on updating your DB with the new information entered in the cell? What action will trigger the DB update?

Nathan

[Kurt Jakobsen]

Well, I don't know exactly how this can be done, but I was thinking of updating the tables for each time a cell is changed. But in cases where the tables run large that can become a bit sluggish, so a good/better alternative can be to first do all changes needed, across columns and rows and then push an update database button.
The thing is that there are going to be quite a few rows that need update each time and it is too cumbersome to push the edit button for each update.
The operator should be able to tab it's way through the table, update the numbers where needed and then push the update button when all cell changes are completed.

I don't even know if this is possible, but it would be at least twice as fast as having a whole column of edit buttons. If I cannot get this to work, the alternative is probably to parce xl files, which is not a good solution in my mind.

[nateraaaa]

Are you planning on updating the entire DB table with any changes made in the gridview? If you are going to update the database with all of the information in your dataset this task may be easier than you think. See the following link for more information.

Nathan