C# Transfer data from database to database via datagridviews

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

ComboBox1 – (RawSource from Database1, Living Column Values)
DatagridView1 displays the result of (ComboBox1 changed) data from Database1 based on selected Living Column rows

ComboBox2 – (RawSource from Database2 , ToWork Column Values)
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….

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Hiten Pandya8y ago
Hi,

You can use triggers in database to accomplish your operation. Because the main goal of trigger is to perform insert, update or delete operation after or before some insert,update or delete happens. Below there is some more information about triggers.

https://www.aspsnippets.com/Articles/Simple-Insert-Update-and-Delete-Triggers-in-SQL-Server-with-example.aspx

and also there is a forum post for this.

http://www.c-sharpcorner.com/UploadFile/63f5c2/triggers-in-sql-server/

Hope it helps you.

Thanks