DataSet.Table.LoadDataRow Help

I was using an OleDbCommand to update the records of a database and it kept giving me a syntax error. A user suggested I use LoadDataRow since I already linked the database as a data source. This method makes the changes visible in the application but does not update the database. How do I go about this? This is the way I am currently doing it. ‘ Create an array for the values. Dim newRow As Object() = New Object(2) {}

 ' Set the values of the array. newRow(0) = "Hello" newRow(1) = "World" newRow(2) = "two" Dim row As DataRow ' Add the new row to the rows collection. row = dt.LoadDataRow(newRow, True) 

submitted by /u/EpicShaggy
[link] [comments]

Leave a Reply