HI. from the flow of the code I assume you want to fill a datatable and then create a new row from it. you can directly fill a datatable without using a dataset. Here I replaced some of the code. With this method, you have a direct access to the dattable. Dim strConn As String = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\VilliageDatabase\Ainslie.mdb" Dim conn As New OleDbConnection(strConn) Dim Sql As String = "select * from tblTransaction" Dim TblTrans as new datatable Dim adapter As OleDbDataAdapter adapter = New OleDbDataAdapter(Sql, conn) conn.open() intc = adapter.Fill(TBLtrans) Dim newrow As DataRow = TBLtrans.NewRow furthermore, you can filter the datatable using its defaultview without using an extra dataview. TblTrans.DefaultView.RowStateFilter=DataViewRowState.Added Datagrid1.datasource = TBLtrans.defaultview
GUERVEN Truth or Consequence