Filter the table and clear it

[Agnes]

I got a Parent-Child two relationship tables,
Now ,Before ds.accetpchanges , my child table may got 4-5K records,
The user may only tick 3-4 records,
I only want to store that ticked record, How can I do that ?
My stupid way is loop each record and check whether there is tick or not.
if not, datarow.remove() .

It seems take a very long time to do .
Please help

 

[Michael C#]

How do they "tick the records"? What's the primary key? Do you have a
column indicating that the records are marked? I'm doing something similar
with a couple of ListViews and DataTables right now. If you could post some
more info, I might be able to post something to help you...

 

[Agnes]

in my Datagrid, I had set one DataGridBoolColumn, and bind to the datatable.
if myDatatable.row("tick") = true then...

 

[Cor Ligthert]

Agnes,

In my opinion is for this the datatable.select
http://msdn.microsoft.com/library/d.../frlrfsystemdatadatatableclassselecttopic.asp

This gives back datarows.

You can use the dataadapter to update datarow by datarow.

http://msdn.microsoft.com/library/d...mdatacommondbdataadapterclassupdatetopic1.asp

I hope this helps,

Cor

 

[Agnes]

Thanks Cor,
Dim myDataRowArray() As DataRow = custDS.Tables(0).Select(Nothing, Nothing,
DataViewRowState.Added)
myDataAdapter.Update(myDataRowArray)
^^^^^^^^^ It seems work for me. I am trying now.