Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. connection.Open();
  2. adapter.SelectCommand = commandSecond;
  3. adapter.UpdateCommand = new OleDbCommand("UPDATE PlayerSkill SET [Поле1] = 3,[Поле2] = 3,[Поле3] = 3,[Поле4] = 3 WHERE [Код] = 1;", connection);
  4. adapter.Update(dataSetSecond);
  5. adapter.UpdateCommand = new OleDbCommand("UPDATE PlayerSkill SET [Поле1] = 3,[Поле2] = 3,[Поле3] = 3,[Поле4] = 3 WHERE [Код] = 2;", connection);
  6. adapter.Update(dataSetSecond);
  7. connection.Close();
  8.  
  9. string tableNameSecond;
  10. string tableNameFirst;
  11. string dataBasePath;
  12. string dataBaseName;
  13. OleDbConnection connection;
  14. OleDbDataAdapter adapter;
  15. OleDbCommand commandSecond;
  16. OleDbCommand commandFirst;
  17. DataSet dataSetFirst;
  18. DataSet dataSetSecond;
  19.  
  20. // Доп таблица
  21. connection.Open();
  22. adapter.SelectCommand = commandSecond;
  23. dataSetSecond = new DataSet();
  24. adapter.Fill(dataSetSecond);
  25. dataGridView2.DataSource = dataSetSecond.Tables[0];
  26. adapter.Update(dataSetSecond);
  27.  
  28. // Основная таблица
  29. tableNameFirst = comboBox1.Text + " - " + comboBox2.Text;
  30. commandFirst = new OleDbCommand("SELECT * FROM [" + tableNameFirst + "];", connection);
  31. adapter.SelectCommand = commandFirst;
  32. dataSetFirst = new DataSet();
  33. adapter.Fill(dataSetFirst);
  34. dataGridView1.DataSource = dataSetFirst.Tables[0];
  35. adapter.Update(dataSetFirst);
  36. connection.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement