I have a problem regarding in comparing 2 datagrid.
What my plan is match the 2 datagrid and update the EmployeeID.
I have 2 database.
here is my existing code.
selectquery as string = "SELECT EmployeeInitial, Firstname, Lastname from EmployeeRegistration"
da = New OleDbDataAdapter(selecquery,con)
ds = New DataSet
da.Fill(ds, "Employee Registration")
dgv1.DataSource = ds
dgv1.DataMember = "Employee Registration"
selectquery1 as string = "SELECT EmployeeID, Firstname, Lastname from EmployeeRegistration"
da1 = New OleDbDataAdapter(selecquery,concon)
ds1 = New DataSet
da1.Fill(ds1, "Employees")
dgv2.DataSource = ds1
dgv2.DataMember = "Employees"
For each row as DatagridViewRow in dgv1.rows
For each row2 as DatagridViewRow in dgv2.rows
'if firstname Of dgv1 = firstname of dgv2 and lastname of dgv1 = lastname of dgv2 then
'???????????
'i dont now how to compare the 2 datagrid by cell of Firstname of dgv1 and firstname of dgv2
'and lastname of dgv1 and dgv2
update database1
'end if
Next
Next
Please help me. Thanks in advance.