I'm sure this is blindingly simple and I'm just being a nonce.
I have a Dataset containing a single table. During my code's execution (this is a console application) I create a DataView to select rows meeting certain criteria as so
Depending on the success of the next piece of code I want to set the value of the IMPORTED field to "E" for the relevant row and then write those changes back to the database.Code:Dim dv As DataView = DS.Tables(0).DefaultView dv.AllowEdit = True dv.RowFilter = String.Format("IMPORTED_DATE <= '" + DeletionDate.ToString("yyyy/MM/dd") & "'" + _ " AND IMPORTED ='Y' AND FILE_NAME LIKE '" + mb & "%'")
This is what I'm trying but nothing happens
Is this possible and, if so, how?Code:drv.BeginEdit() drv.Item("IMPORTED") = "E" drv.EndEdit() DS.AcceptChanges()




Reply With Quote