Hello, code gurus. I would be soooo grateful if anyone could help me with question.
I have a dataset created from a SQL query on an Oracle db. How do I write back the data, in Table = "Results0", to Oracle?
Code:Private Sub pbResetRowID_Click(...) '` Get data from Oracle Dim strSQL As String = "SELECT * FROM TABLE_AB" Dim objcommand As New OleDb.OleDbCommand(strSQL, objConnection) Dim objdataadapter As New OleDb.OleDbDataAdapter(objcommand) '` Save results locally Dim objdatatable As New Data.DataTable("Results0") objdataadapter.Fill(objdatatable) Dim objDataRow As DataRow ' Seed the index Dim nIdx As Int32 = 100 '` Walk down the rows For Each objDataRow In objdatatable.Rows '` Assign index objDataRow.Item("IDX") = nIdx '` Bump up index value nIdx += 10 Next '------------------------------------------ ' Ok, now save the datatable in Oracle! '------------------------------------------




Reply With Quote