loop through dataset and change each value 1

[NSNewey]

Hi

I have a windows form showing a customer enquiry.
There is a DGV showing each entry for this enquiry.
When the user deletes an entry, I need to loop through each record in the entry table and renumber the "itemNumber" field so they remain consecutive.

The item number field is not displayed in the DGV.

I have successfully done this using a data reader to iterate each record and update each item number value using an oleDbCommand Update.

I know there is a better way to do this as the form has the enquiry entry table adapter in it.

What’s the best way to edit a field in each line in the table…

Something like…

For each row in the table
	Edit the item number field
Next

Thanks

Neil

 

[RiverGuy]

Is your DataGridView bound to a DataSet/DataTable?

Try the following:

Dim RunningTotal As Integer = 0
For Each dr As DataRow In YourDataTable.Rows
  dr.Item("YourColumnName") = RunningTotal
  RunningTotal += 1 
Next

 

[NSNewey]

Hi RiverGuy

Yes the dgv is bound to a tableAdapter

I have tried your code which runs fine but does not update the table.

As a test, I tried this to see if it would set every entry record's itemNo field in the dgv to 5...

For Each dr As DataRow In Me.TradeBaseDataSet.tJobEntry.Rows
      dr.Item("itemNo") = 5
Next

There is no error but when I select a line in the dgv and open that record, the itemNo field has not changed.

Am i missing an update or acceptChanges somewhere.

I know this is a newby question but I am fairly new to vb.net.

 

[NSNewey]

Update...

I added this...

Me.TJobEntryTableAdapter.Update(Me.TradeBaseDataSet.tJobEntry)

and now it works.

Thanks for pointing me in the right direction.