Update Datagrid's table

[Agnes]

In my datagrid, there is Boolcolumn, i allow the user to click it .
Now, i need to update the table which the boolcolumn is True. if the column
is false,
I should not save those row.
How can I do that ?
Thanks a lot

 

[Agnes]

I solve myproblem by "add the filter condition in select command"
Now, How can I refresh the datagrid ??

 

[Cor Ligthert]

Agnes,

When you really "need" a refresh, than I never solved that problem and do I
just set the
datagrid.datasource = nothing
and than again the
datagrid.datasource = datasource.

When you get no other solution maybe you can do that.

Cor

 

[Agnes]

I found that I didn't solve my problem indeed.
the datagrid got 10 rows , only 2 row 's boolcolumn is true.
I use SQL analzyer to check the table, 10 rows is saved.
Any method that I only save 2 rows which is true ?
Do I need to proceed another command to delete the False rows ?

 

[Cor Ligthert]

Agnes,

I gave an answer on your last question not your first, for your first, may I
assume your boolean column is not a part of the received datatable?

Or as I see your last message you do not receive any datarow in advance?

Cor