my code as follow
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
Try
conn.Open()
Catch e As OleDb.OleDbException
m_addStatus(m_exception(e), "error", -1)
End Try
Dim da As System.Data.OleDb.OleDbDataAdapter
Dim ds As DataSet
ds = Nothing
grd.DataSource = Nothing
ds = New DataSet("ds")
Try
da = New OleDb.OleDbDataAdapter(aStmt, conn)
da.Fill(ds, "result")
If ds.Tables(0).Columns.Count > 0 Then
grd.SetDataBinding(ds, "result")
Else
grd.DataSource = Nothing
End If
conn.Close()
Catch ex As OleDb.OleDbException
m_addStatus(m_exception(ex), "error", -1)
End Try
how to enable commit/rollback for my code.
thanks.