Search results for query: *

Sorry here is the code that I am using Private Function SaveNewSteps() As Boolean Dim myCN As New OleDbConnection(myConnectionString) Dim cmd As New OleDbCommand Dim SQL As String Dim rID As Long Dim RecordsAffected As Integer Dim i As Integer Dim sc As Byte Dim retval As...

Hi, I am adding a record to the database using an ExecuteNonQuery, which adds without problem. Now after the record is added I run a method passing in some info as well as the curretnly opened connection (byRef cn as OleDbConnection). Am using an Access 2000 database. Now in this new method...

Hi, I have a DataGrid on a form that is bound to a disconnected dataset. What I want to be able to do, when the user makes their changes and click on the save button (dataSet.update) would like to get all the rows that will be changed when the update is done, and their original value so...

You can use the OnColumnChanging or OnRowChanging events. First you need to add the following to the Sub New() procedure. AddHandler Me.MydataSet.Tables(0).RowChanging, New DataRowChangeEventHandler(AddressOf OnRowChanging) AddHandler Me.MyDataSet.Tables(0).ColumnChanging, New...