form1.cs

This program is compare the data in sql server. And you can syncronize the table and views this is v

                dg.Rows.Add(dr);
                dg.Rows[i].Cells[0].Value = true;
            }
            int dem = 0;
            foreach (DataRow dr1 in dt1.Rows)
            {
                int durum = 0;
                int j = 0;
                int f = fark;
                foreach (DataRow dr2 in dt2.Rows)
                {
                    if (dr1[in1].ToString() == dr2[in1].ToString())
                    {
                        int sayac = 0;
                        durum = 1;
                        for (int i = 0; i < dt1.Columns.Count; i++)
                        {
                            if (dr1[i].ToString() != dr2[i].ToString())
                            {
                                sayac = 1;
                                break;
                            }
                        }
                        if (sayac == 1)
                        {
                            fark++;
                        }
                        else
                        {
                            ay++;
                            dg.Rows[dem].Cells[0].ReadOnly = true;
                        }
                        break;
                    }
                    j++;
                }
                for (int i = 0; i < dt1.Columns.Count; i++)
                {
                    dg.Rows[dem].Cells[2 + 2 * i].Value = dr1[i].ToString();
                    dg.Rows[dem].Cells[2 + 2 * i].ReadOnly = true;
                }
                if (durum == 0)
                {
                    dg.Rows[dem].Cells[1].Value = "2";
                    fark1++;
                    for (int i = 0; i < dt1.Columns.Count; i++)
                    {
                        dg.Rows[dem].Cells[3 + 2 * i].Style.BackColor = Color.Red;
                        dg.Rows[dem].Cells[3 + 2 * i].ReadOnly = true;
                    }
                }
                else
                {
                    for (int i = 0; i < dt1.Columns.Count; i++)
                    {
                        DataRow d = dt2.Rows[j];
                        dg.Rows[dem].Cells[3 + 2 * i].Value = d[i].ToString();
                        dg.Rows[dem].Cells[3 + 2 * i].ReadOnly = true;
                        if (f != fark)
                        {
                            if (dg.Rows[dem].Cells[2 + 2 * i].Value.ToString() != dg.Rows[dem].Cells[3 + 2 * i].Value.ToString())
                            {
                                dg.Rows[dem].Cells[2 + 2 * i].Style.BackColor = Color.Pink;
                            }
                            dg.Rows[dem].Cells[1].Value = "1";
                        }
                        else
                        {
                            dg.Rows[dem].Cells[1].Value = "0";
                        }
                    }
                }
                dem++;
            }
            foreach (DataRow dr8 in dt2.Rows)
            {
                int saa = 0;
                for (int i = 0; i < dg.Rows.Count; i++)
                {
                    if (dg.Rows[i].Cells[in1 + 2].Value != null)
                    {
                        if (dr8[pk].ToString() == dg.Rows[i].Cells[in1 + 2].Value.ToString())
                        {
                            saa = 1;
                        }
                    }
                }
                if (saa == 0)
                {
                    DataGridViewRow dr = new DataGridViewRow();
                    dg.Rows.Insert(dg.Rows.Count, dr);
                    fark2++;
                    for (int i = 0; i < dt1.Columns.Count; i++)
                    {
                        dg.Rows[dem].Cells[3 + 2 * i].Value = dr8[i].ToString();
                        dg.Rows[dem].Cells[3 + 2 * i].ReadOnly = true;
                        dg.Rows[dem].Cells[2 + 2 * i].ReadOnly = true;
                    }
                    for (int i = 0; i < dt1.Columns.Count; i++)
                    {
                        dg.Rows[dem].Cells[2 + 2 * i].Style.BackColor = Color.Red;
                    }
                    dg.Rows[dem].Cells[0].Value = true;
                    dg.Rows[dem].Cells[1].Value = "3";
                    dem++;
                }
            }
            if ((fark == 0) && (fark1 == 0) && (fark2 == 0))
            {
                tabControl3.TabPages.Add(tp);
            }
            else
            {
                tabControl4.TabPages.Add(tp);
            }
            tp.Controls.Add(dg);
            tp.BackColor = Color.LawnGreen;
            DataGridView dg1 = new DataGridView();
            DataGridViewCheckBoxColumn cbc1 = new DataGridViewCheckBoxColumn();
            dg1.Name = table1 + "bilgi";
            dg1.Columns.Add(cbc1);
            dg1.Columns[0].Name = "insert1";
            dg1.Columns[0].HeaderText = "INSERT";
            dg1.Columns.Add("data", "Database");
            dg1.Columns.Add("count", "Count");
            DataGridViewRow dr10 = new DataGridViewRow();
            dg1.Rows.Add(dr10);
            dg1.Rows[0].Cells[0].Value = true;
            dg1.Rows[0].Cells[0].ReadOnly = true;
            dg1.Rows[0].Cells[1].Value = "Same";
            dg1.Rows[0].Cells[2].Value = ay;
            DataGridViewRow dr5 = new DataGridViewRow();
            dg1.Rows.Add(dr5);
            dg1.Rows[1].Cells[0].Value = true;
            dg1.Rows[1].Cells[1].Value = "Both But Some Different";
            dg1.Rows[1].Cells[2].Value = fark;
            DataGridViewRow dr6 = new DataGridViewRow();
            dg1.Rows.Add(dr6);
            dg1.Rows[2].Cells[0].Value = true;
            dg1.Rows[2].Cells[1].Value = database1;
            dg1.Rows[2].Cells[2].Value = fark1;
            DataGridViewRow dr7 = new DataGridViewRow();
            dg1.Rows.Add(dr7);
            dg1.Rows[3].Cells[0].Value = true;
            dg1.Rows[3].Cells[1].Value = database2;
            dg1.Rows[3].Cells[2].Value = fark2;
            tp.Controls.Add(dg1);
            tp.Text = table1;
            tp.Name = table1;
            dg1.Columns[1].Width = 200;
            dg1.AllowUserToAddRows = false;
            dg1.AllowUserToDeleteRows = false;
            dg1.SetBounds(10, 10, 450, 120);
            dg.SetBounds(10, 140, 650, 200);
            dg.BackgroundColor = Color.LawnGreen;
            dg1.BackgroundColor = Color.LawnGreen;
            dg1.CellMouseClick += new DataGridViewCellMouseEventHandler(dinamikcellmouseclick);
            for (int i = 0; i < dg1.Columns.Count; i++)
            {
                dg1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
            }
            for (int i = 0; i < dg.Columns.Count; i++)
            {
                dg.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
            }
        }

        public void compare()
        {
            kar = new int[20];

            for (int i = 0; i < 20; i++)
            {
                kar[i] = -1;
            }

            int say = dataGridView2.Rows.Count;

            for (int i = 0; i < say; i++)
            {
                string str = dataGridView2.Rows[i].Cells[2].Value.ToString();
                if (str == "True")
                {
                    kar[i] = 1;
                }
                else
                {
                    kar[i] = 0;
                }
            }
            DataTable[,] dta = new DataTable[say, 2];
            for (int i = 0; i < say; i++)
            {
                string[] kars = new string[20];
                if (kar[i] == 1)
                {
                    string table1 = adi1[i];
                    int indis = adtut[i, 1];
                    string table2 = adi2[indis];
                    string sorgum = "";
                    int[] ind = new int[20];
                    int sayac = 0;
                    for (int j = 0; j < 20; j++)
                    {
                        if (check[0, i, j] == true)
                        {
                            int kol1 = ayni[i, j, 0];
                            kars[sayac] = kolon1[i, j];
                            ind[sayac] = j;
                            sayac++;
                        }
                    }
                    sorgum = "SELECT ";
                    for (int k = 0; k < 20; k++)
                    {
                        if (kars[k] == null) break;
                        sorgum += kars[k] + ",";
                    }
                    sorgum = sorgum.Remove(sorgum.Length - 1, 1);
                    string sorgum1 = sorgum + " FROM " + table1;
                    string sorgum2 = sorgum + " FROM " + table2;
                    if (where[i] != null)
                    {
                        if (where[i].Length > 1)
                        {
                            sorgum1 += " WHERE " + dataGridView2.Rows[i].Cells[0].Value.ToString() + " " + where[i];
                            sorgum2 += " WHERE " + dataGridView2.Rows[i].Cells[0].Value.ToString() + " " + where[i];
                        }
                    }
                    dta[i, 0] = sqlcon.sqlsorgu(sorgum1, connect(server1, database1));
                    dta[i, 1] = sqlcon.sqlsorgu(sorgum2, connect(server2, database2));
                    dtbasekar(dta[i, 0], dta[i, 1], table1);
                }
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if ((dataGridView2.Rows.Count != 0) && (panel1.Visible == false))
            {
                compare();
            }
            else if (panel1.Visible == true)
            {
                MessageBox.Show("You don't compare!.The Object Property is open");
            }
            else
            {
                MessageBox.Show("No Tables for compare");
            }
            button1.Enabled = false;
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            if (radioButton2.Checked == true)
            {
                textBox1.Enabled = true;
                textBox2.Enabled = true;
                label5.Enabled = true;
                label6.Enabled = true;
                checkBox1.Enabled = true;
                global1 = 1;
            }
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            if (radioButton1.Checked == true)
            {
                textBox1.Enabled = false;
                textBox2.Enabled = false;
                label5.Enabled = false;
                label6.Enabled = false;
                checkBox1.Enabled = false;
                global1 = 1;
            }
        }

        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            if (radioButton3.Checked == true)
            {
                textBox3.Enabled = false;
                textBox4.Enabled = false;
                label7.Enabled = false;
                label8.Enabled = false;
                checkBox2.Enabled = false;
            }
        }

        private void radioButton4_CheckedChanged(object sender, EventArgs e)
        {
            if (radioButton4.Checked == true)
            {
                textBox3.Enabled = true;
                textBox4.Enabled = true;
                label7.Enabled = true;
                label8.Enabled = true;
                checkBox2.Enabled = true;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        public void griddoldur(DataGridView data, DataTable dt, string kolon, int cell)
        {
            int i = 0;
            foreach (DataRow dr in dt.Rows)
            {
                data.Rows[i].Cells[cell].Value = dr[kolon].ToString();
                i++;
            }
        }