Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- connection.Open();
- adapter.SelectCommand = commandSecond;
- adapter.UpdateCommand = new OleDbCommand("UPDATE PlayerSkill SET [Поле1] = 3,[Поле2] = 3,[Поле3] = 3,[Поле4] = 3 WHERE [Код] = 1;", connection);
- adapter.Update(dataSetSecond);
- adapter.UpdateCommand = new OleDbCommand("UPDATE PlayerSkill SET [Поле1] = 3,[Поле2] = 3,[Поле3] = 3,[Поле4] = 3 WHERE [Код] = 2;", connection);
- adapter.Update(dataSetSecond);
- connection.Close();
- string tableNameSecond;
- string tableNameFirst;
- string dataBasePath;
- string dataBaseName;
- OleDbConnection connection;
- OleDbDataAdapter adapter;
- OleDbCommand commandSecond;
- OleDbCommand commandFirst;
- DataSet dataSetFirst;
- DataSet dataSetSecond;
- // Доп таблица
- connection.Open();
- adapter.SelectCommand = commandSecond;
- dataSetSecond = new DataSet();
- adapter.Fill(dataSetSecond);
- dataGridView2.DataSource = dataSetSecond.Tables[0];
- adapter.Update(dataSetSecond);
- // Основная таблица
- tableNameFirst = comboBox1.Text + " - " + comboBox2.Text;
- commandFirst = new OleDbCommand("SELECT * FROM [" + tableNameFirst + "];", connection);
- adapter.SelectCommand = commandFirst;
- dataSetFirst = new DataSet();
- adapter.Fill(dataSetFirst);
- dataGridView1.DataSource = dataSetFirst.Tables[0];
- adapter.Update(dataSetFirst);
- connection.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement