How to update the checkbox value in the datagrid?

  • Thread starter Thread starter irene
  • Start date Start date
I

irene

Hi, I am trying to update the checkbox value in a datagrid. I am using
TemplateColumn to add the checkbox to the datagrid and it is showing
correct data from the database now. Ideally, the end user will check
the checkbox(if it is approved) and then there is a confirmation
button on the page. After them make the changes, they will hit the
confirmation button so that the database will be updated accordingly.
I am not using dataset at this point, I am just using regular
sqldatareader to get the result from the database and then bind to the
datagrid. But I do not know how to update the datagrid after that.

Can anyone give me an example how to do this?

Thanks.

Irene
 
You can't update the database with a DataReader. Pull in a copy of the data
into a DataSet and update the DataSet with the new column value. Then
update the db with a DataReader.
 

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

Similar Threads

CheckBoxes in DataGrids-- the "checked" attribute not correct after posting page? 4
Checkbox in a Datagrid, how to handle PostBack 1
how to check/uncheck the checkbox in datagrid 2
checkbox autopostback in datagrid 1
Problem sorting a Datagrid with Checkbox columns (checkboxes not following sort) 2
Firing events for child controls in a DataGrid 2
Adding a CheckBox to a DataGrid at Runtime 3
datagrid\checkbox 1

Back
Top