/****************************************Functions**************************************************/ private void C_Click(object sender, EventArgs e) { // our code ............. FileStream fs = new FileStream("table_name.txt", FileMode.OpenOrCreate); StreamReader sr = new StreamReader(fs); string table_name = sr.ReadLine(); sr.Close(); fs.Close(); List <tables> table_list = new List <tables>(); table_list = get_List_of_Tables(); tables tab = new tables(); tab.table_name = table_name; List <Columns> col_list = new List <Columns>(); for (int i = 0; i < dataGridView1.RowCount - 1; i++) { Columns temp_col = new Columns(); temp_col.name = dataGridView1.Rows[i].Cells[0].Value.ToString(); temp_col.type = dataGridView1.Rows[i].Cells[1].Value.ToString(); if (dataGridView1.Rows[i].Cells[2].Value != null) { tab.Primary_keys.Add(temp_col.name); } col_list.Add(temp_col); } tab.Table_colums = col_list; table_list.Add(tab); Save(table_list); DataTable t = new DataTable(); dataGridView1.DataSource = t; if (Constrain_T.instance.Visible == false) { Constrain_T.instance.Visible = true; } if (!panel.Controls.Contains(Constrain_T.instance)) { panel.Controls.Add(Constrain_T.instance); Constrain_T.instance.Dock = DockStyle.Fill; Constrain_T.instance.BringToFront(); } else { Constrain_T.instance.BringToFront(); } }
private void combo_T_Names_SelectedIndexChanged(object sender, EventArgs e) { List <tables> table_list = new List <tables>(); table_list = get_List_of_Tables(); tables table = new tables(); string table_name = combo_T_Names.SelectedItem.ToString(); for (int i = 0; i < table_list.Count; i++) { if (table_list.ElementAt(i).table_name == table_name) { table = table_list.ElementAt(i); break; } } DataTable temp = new DataTable(); for (int i = 0; i < table.Table_colums.Count; i++) { temp.Rows.Add(); } dataGridView1.DataSource = temp; for (int i = 0; i < table.Table_colums.Count; i++) { if (table.Primary_keys.Contains(table.Table_colums[i].name.ToString())) { dataGridView1.Rows[i].Cells[2].Value = true; } } for (int i = 0; i < table.Table_colums.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = table.Table_colums[i].name.ToString(); dataGridView1.Rows[i].Cells[1].Value = table.Table_colums[i].type.ToString(); } }
/****************************************Functions**************************************************/ private void button3_Click(object sender, EventArgs e) { if (combo_T_Names.Text == "") { MessageBox.Show("Please Select Table", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { List <tables> table_list = new List <tables>(); table_list = get_List_of_Tables(); tables tab = new tables(); tab.table_name = combo_T_Names.SelectedItem.ToString(); List <Columns> col_list = new List <Columns>(); for (int i = 0; i < dataGridView1.RowCount - 1; i++) { Columns temp_col = new Columns(); temp_col.name = dataGridView1.Rows[i].Cells[0].Value.ToString(); temp_col.type = dataGridView1.Rows[i].Cells[1].Value.ToString(); if (dataGridView1.Rows[i].Cells[2].Value != null) { tab.Primary_keys.Add(temp_col.name); } col_list.Add(temp_col); } tab.Table_colums = col_list; int index = 0; for (int i = 0; i < table_list.Count; i++) { if (table_list.ElementAt(i).table_name == combo_T_Names.SelectedItem.ToString()) { index = i; break; } } // copy constrains and data to temp for (int i = 0; i < table_list[index].Table_colums.Count; i++) { tab.Table_colums[i].constrains = table_list[index].Table_colums[i].constrains; } for (int i = 0; i < table_list[index].Table_colums.Count; i++) { tab.Table_colums[i].data = table_list[index].Table_colums[i].data; } table_list[index] = tab; Save(table_list); string T_name = combo_T_Names.Text; FileStream f = new FileStream("table_name.txt", FileMode.OpenOrCreate); StreamWriter wr = new StreamWriter(f); wr.WriteLine(T_name); wr.Close(); f.Close(); combo_T_Names.Text = ""; combo_T_Names.Items.Clear(); DataTable dd = new DataTable(); dataGridView1.DataSource = dd; if (Upda_Constrain.instance.Visible == false) { Upda_Constrain.instance.Visible = true; } if (!panel1.Controls.Contains(Upda_Constrain.instance)) { panel1.Controls.Add(Upda_Constrain.instance); Upda_Constrain.instance.Dock = DockStyle.Fill; Upda_Constrain.instance.BringToFront(); } else { Upda_Constrain.instance.BringToFront(); } } }