C#

<br />
public class MergeTableClass<br />
    {<br />
        private OleDbDataAdapter da1, da2;<br />
        private DataSet ds1;<br />
<br />
        public void MergeTables(string connS1, string connS2)<br />
        {<br />
            string connString1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + connS1;<br />
            string connString2 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + connS2;<br />
            OleDbConnection oleConn1 = new OleDbConnection(connString1);<br />
            OleDbConnection oleConn2 = new OleDbConnection(connString2);<br />
            string cmd1 = "SELECT *FROM db1_table1";<br />
            string cmd2 = "SELECT *FROM db2_table1";<br />
            da1 = new OleDbDataAdapter(cmd1, oleConn1);<br />
            da2 = new OleDbDataAdapter(cmd2, oleConn2);<br />
            ds1 = new DataSet();<br />
            <br />
            da1.Fill(ds1,"db1_table1");<br />
            da2.Fill(ds1,"db2_table1");<br />
                                    <br />
            ds1.Tables["db1_table1"].Merge(ds1.Tables["db2_table1"]);<br />
            da1.Update(ds1,"db2_table1");<br />
            ds1.AcceptChanges();<br />
            <br />
          }<br />
    }<br />

<br />
private void _popItemCombo() //To load itemcode combobox <br />
        {<br />
            clsGrpObj = new clsGroupManip();<br />
            clsDataAccObj = new clsGloDataAcces();<br />
//code to populate datatable Item table<br />
            dtItem = new DataTable(); //stores item * datas<br />
            dtItem = clsGrpObj._selItem_Assembly();<br />
            for (int i = 0; i < dtItem.Rows.Count - 1; i++)<br />
            {<br />
                string item = dtItem.Rows[i]["ItemCode"].ToString();<br />
                cmbItemCode.Items.Add(item); // code to pop combobox with datas.<br />
            }<br />
           <br />
        }<br />

int count = Application.OpenForms.Count;<br />
                    for (int i = 1; i < count; i++)<br />
                    {<br />
                        PrintDialog myPrintDialog = new PrintDialog();<br />
                        memoryImage = new System.Drawing.Bitmap(panel1.Width, panel1.Height);<br />
                        panel1.DrawToBitmap(memoryImage, panel1.ClientRectangle);<br />
                        if (myPrintDialog.ShowDialog() == DialogResult.OK)<br />
                        {                           <br />
                            myPrintDialog.Document = printDocument1;                            <br />
                            printDocument1.PrintController = new StandardPrintController();<br />
                            printDocument1.Print();<br />
                        }<br />
                        printDocument1.Dispose();<br />
                    }