DataGrid-driven SQL updates

S

Stephan Bour

Hi,
I have a page that displays a number of SQL records tagged ³New² in the
³Status² column of the database. I¹d like to add a check box next to each
³New² item returned. The user could select any of the check boxes present in
each returned record and click a Submit button that will update all the
selected records to ³InProgress² in the ³Status² column of the database.
Here are my questions:
- Do I use "cmdCategoriesUpdate.ExecuteNonQuery();" for this?
- Can I update all selected records in one pass? How?

Thanks,
Stephan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,020
Latest member
GenesisGai

Latest Threads

Top