copy selected row form table1 in form1 to table2 in form2

[satyamparmar]

I have data in table1 in form1. I want to copy data from selected row form table1 of Form1 to table2 of form2.
After being selected from data from selected row of table1 should be deleted.
I want to do by using with Tableadapterman ager (Databindingsou rce) .
I am using vb.net and MSAccess.

for deleting the row , I am using following code.

[Me.Validate()
Me.HPReportBind ingSource.Allow Remove.ToString ()
Me.TableAdapter Manager.UpdateA ll(Me.Histopath ology_NewDataSe t1)
MsgBox("Saved")]

[Ajay Bhalala]

You can use DataReader object to copy and you can use delete query for deleting the row.

Hope this helpful for you.

[satyamparmar]

How can I use datareader? I am very new to vb.net.

[Ajay Bhalala]

You can visit the following links to know about the datareader...

http://www.codeproject.com/Articles/869/The-ADO-NET-OleDbDataReader-class

http://www.tutorialspoint.com/vb.net/pdf/vb.net_database_access.pdf

The following link is best link for the vb.net

http://www.tutorialspoint.com/vb.net/vb.net_database_access.htm

Hope this helpful for you.