Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

loop through dataset and change each value 1

Status
Not open for further replies.
NSNewey

NSNewey

Programmer
Jun 29, 2005
125
GB
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…

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

Thanks

Neil
 
Sort by date Sort by votes
Is your DataGridView bound to a DataSet/DataTable?

Try the following:

Code: 
Dim RunningTotal As Integer = 0
For Each dr As DataRow In YourDataTable.Rows
  dr.Item("YourColumnName") = RunningTotal
  RunningTotal += 1 
Next
 
Upvote 0 Downvote
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...

Code: 
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.
 
Upvote 0 Downvote
Update...

I added this...

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

and now it works.

Thanks for pointing me in the right direction.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
262
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
238
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
434
strongm
strongm
Ken01
  • Question
Areas under graphs and overlap areas between circles. 2
Replies
3
Views
430
Ken01
Ken01
sal21
  • Locked
  • Question
FIND VALUE IN COLUMN 0 OF MSFKLEXGRID
Replies
0
Views
131
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top