By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,017 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

datagrid update methodology

P: n/a
I want to show a datagrid to a user which contains about 100-200 records (6
columns). I would like to allow the user to alter certain columns while
they're using the program. Then when they exit, they will be prompted to
save changes. What I don't want to do is load my dataset, have the user
make changes, then update the dataset which will update the server. Rather,
I'd like to write a stored procedure (for SQL server) that handles the
update of each column (2 columns are updateable, hence 2 stored procedures.)
I then want to execute the stored procedure for each record where a column
was changed. What is the proper methodology for doing this? Can anyone
provide me some code samples?

Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.