Deleting rows in dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i delete a row in dataset based on the column value, i have four
columns in a row and i want to delete the row based on the column1 value.
 
Hi,

Select the rows you wish to delete (perhaps using DataTable.Select method or
dataview) and do an inverse for loop (from latest row to first row) - inside
the loop call DataRow.Delete method.
And, of course, call DataAdapter.Update to persist the changes in database
if you wish.
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
Dataset and dataadapter 2
Persist Changes made in class property to dataset 4
SQLDataAdapter Fill with startRecord parameter 0
Comparing DataSets 6
Excel 2013 Merge Data 2
Accessing deleted rows problem 2

Back
Top