private void toolStripSplitButton1_ButtonClick(object sender, EventArgs e)
 {
     webBrowser2.Visible   = false;
     dataGridView1.Visible = true;
     dbconnection1         = new DBCON();
     Query = "select * from " + comboTablename.SelectedItem.ToString() + "";
     table = dbconnection1.ExecuteQuery(Query);
     dataGridView1.DataSource = table.DefaultView;
 }
        private void Form1_Load(object sender, EventArgs e)
        {
            SourceNa = Dns.GetHostName();

            webBrowser1.ShowPageSetupDialog();
            webBrowser1.ShowSaveAsDialog();
            Dbconnection = new DBCON();

            //RETRIEVE TABLES THROUGH QUERY
            Query   = "select table_name from INFORMATION_SCHEMA.Tables order by Table_type"; //TO READ DATABASES AND SUB-DATABASES
            dataset = new DataSet();
            table   = Dbconnection.ExecuteQuery(Query);
            actc    = new ActionController();
            // textBox1.Text = "machine16";
            foreach (DataRow drow in table.Rows)
            {
                comboTablename.Items.Add(drow.ItemArray.GetValue(0).ToString());
            }
        }
        //TO GET ALL DATAS FROM DATABASE

        public void assignpartition(string tablename)
        {
            dbconnection1 = new DBCON();
            Query         = "select * from " + tablename + "";
            table         = dbconnection1.ExecuteQuery(Query);
            TableN        = tablename;
            arryColumnName.Clear();
            rowscount       = table.Rows.Count;
            rowscountStatic = rowscount;

            using (StreamWriter sw = new StreamWriter(dirname + "\\Txt.txt"))
            {
                foreach (DataRow drow1 in table.Rows)
                {
                    int j2 = drow1.Table.Columns.Count;
                    strbldr = new StringBuilder();
                    for (int m = 0; m < j2; m++)
                    {
                        strbldr.Append(drow1.ItemArray.GetValue(m).ToString() + " ");
                    }
                    sw.WriteLine(strbldr);
                }
            }

            foreach (DataColumn colo in table.Columns)
            {
                arryColumnName.Add(colo + "-" + colo.DataType.Name);
            }
            //TO CREATE THE NUMBER OF PARTITION

            partitionvalue = rowscount / 3;
            int i = 0;

            Hashpartition = new Hashtable[partitionvalue];

            for (i = 0; i < partitionvalue; i++)
            {
                Hashpartition[i] = new Hashtable();
            }
            foreach (DataRow drow in table.Rows)
            {
                rowscount1 = rowscount1 + 1;
                // pkey = int.Parse(drow.ItemArray.GetValue(0).ToString());

                //TO GET PARTITION NUMBER(PRIMARYKEY,SECRETKEY & NUMBER OF PARTITION)

                partitionnum = this.getpartitionnum(rowscount1, MainForm.secretkey, partitionvalue);
                if (!PartionArry.Contains(partitionnum))
                {
                    PartionArry.Add(partitionnum);
                }
                // Name = drow.ItemArray.GetValue(1).ToString();
                //Age = drow.ItemArray.GetValue(2).ToString();
                Hashpartition[partitionnum].Add(Hashpartition[partitionnum].Count, rowscount1 + "~" + KeyAdd(drow) + "~" + count);
                count++;
            }
            partCount = PartionArry.Count;
            ReadWrite(Hashpartition);

            MessageBox.Show("Data Collected", "Server", MessageBoxButtons.OK);
            singlebit.Encode(Hashpartition, PartionArry, arryColumnName);
        }