THEFUN CHAKTHI

THEFUN CHAKTHI

  • NA
  • 26
  • 6.2k

C# Transfer data from database to database via datagridviews

Feb 27 2018 12:18 PM
I have to allot work for my volunteers. Here I have two Databases as follows
 
Database1-(Having 3 Columns as)
 
Name Designation Living
 
Database 2 (Having 4 Columns as)
 
Name Designation Living ToWork
 
My Winform has two ComboBoxes, two datagridviews and two buttons between two datagridviews
  1. ComboBox1 – (RawSource from Database1, Living Column Values)
  2. DatagridView1 displays the result of (ComboBox1 changed) data from Database1 based on selected Living Column rows
    1. ComboBox2 – (RawSource from Database2 , ToWork Column Values)
    2. DatagridView2 displays the result of (ComboBo2 changed) data from Database2 based on selected ToWork Column rows
Here I have are two Button.One button transfer selected data from one datagridview to another datagridview. Here I need code which transfer selected row data from one datagridview to another datagridview at the same time database to database.
 
(Eg. If selected rows of datagridview1 transferred to datagridview2 at the same time the data also transferred to database1 to database2 vice versa…)
 
How can I get this… Any help or guide would be appreciate and thankful….

Answers (1)