private void toolStripMenuItem2_Click(object sender, EventArgs e) { List <string> namesList = new List <string>(); for (int i = 0; i < dataGridViewAll.ColumnCount; i++) { namesList.Add(dataGridViewAll.Columns[i].HeaderText); } DinamycAddModForm f = new DinamycAddModForm(namesList.ToArray(), false, connectionString, tablesName[comboBoxTables.SelectedIndex]); f.ShowDialog(); try { SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(connectionString); string sqlExpr = @"select * from " + tablesName[comboBoxTables.SelectedIndex]; SqlConnection userConn = new SqlConnection(sqlBuilder.ToString()); SqlCommand comm = new SqlCommand(sqlExpr, userConn); SqlDataAdapter adapter = new SqlDataAdapter(comm); DataTable dt = new DataTable(); adapter.Fill(dt); tablesDict[comboBoxTables.SelectedText.ToString()] = dt; dataGridViewAll.DataSource = dt; } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void toolStripMenuItem3_Click(object sender, EventArgs e) { var row = dataGridViewAll.SelectedRows; List <string> valuesList = new List <string>(); for (int i = 0; i < dataGridViewAll.ColumnCount; i++) { var zap = row[0].Cells[i].Value.ToString(); if (zap.Contains("0:00:00")) { zap = zap.Replace("0:00:00", ""); } valuesList.Add(zap.Replace(" ", "")); } List <string> namesList = new List <string>(); for (int i = 0; i < dataGridViewAll.ColumnCount; i++) { namesList.Add(dataGridViewAll.Columns[i].HeaderText); } DinamycAddModForm f = new DinamycAddModForm(namesList.ToArray(), true, connectionString, tablesName[comboBoxTables.SelectedIndex], valuesList); f.ShowDialog(); try { SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(connectionString); string sqlExpr = @"select * from " + tablesName[comboBoxTables.SelectedIndex]; SqlConnection userConn = new SqlConnection(sqlBuilder.ToString()); SqlCommand comm = new SqlCommand(sqlExpr, userConn); SqlDataAdapter adapter = new SqlDataAdapter(comm); DataTable dt = new DataTable(); adapter.Fill(dt); tablesDict[comboBoxTables.SelectedText.ToString()] = dt; dataGridViewAll.DataSource = dt; } catch (Exception exception) { MessageBox.Show(exception.Message); } }