C# Transfer data from database to database via datagridviews

Question

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….

Hiten Pandya · Answer

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