Hi,

My app is “sitting�on top of SQL Express 2005 database. I use dataset generated by VS 2005. When I try to update records in one table, not all updates of this table in dataset posted in the database. For example: I updated 3 records in the table, but only 2 records updated in database.Code:

Dim updtr() As DataRow = frmCBMain.CBDataSet.Trades.Select("SessionID = '" & SessionID & "'")

'In my case updtr.Length=3

For i As Integer = 0 To updtr.Length - 1

updtr(i).Item("Status") = "Updated"

Next

Dim recordsUpdated As Integer = frmCBMain.TradesTableAdapter.Update(updtr)

'recordsUpdated=2

Thank you