inserting data into table

asharavin

I need to insert data from textboxes into data table.As per my code, the data is inserting one time.But that is temperory.If I run the program again, the inserted record is not available.It is not getting inserted in the actual data table.Please help me sort this problem out.

chip050555

: I need to insert data from textboxes into data table.As per my code, the data is inserting one time.But that is temperory.If I run the program again, the inserted record is not available.It is not getting inserted in the actual data table.Please help me sort this problem out.
:
:
You need to do the following:

[code]
dim CMD as New Data.OleDb.OleDbCommandBuilder(yourDataAdapter)
CMD.DataAdaptor.Update(yourDataTable)
yourDataTable.Rows.(currentrecordnumber).AcceptChanges()
[/code]

This should open your data adaptor and update your database.