Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. private void button1_Click(object sender, EventArgs e)
  2. { // this.tableTableAdapter.Update(test_0DataSet3);
  3. try
  4. {
  5. this.Validate();
  6. this.tableBindingSource.EndEdit();//разрешил изменения
  7. this.tableTableAdapter.Update(this.test_0DataSet3.Table);
  8. MessageBox.Show("Данные oбновлены!");
  9. }
  10. catch(System.Exception ex)
  11. {
  12. MessageBox.Show("Ошибка обновления!");
  13. }
  14.  
  15. using (SqlConnection con = new SqlConnection())
  16. {con.ConnectionString = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=|DataDirectory|Test_0.mdf;Integrated Security=True;Connect Timeout=30";
  17. con.Open();
  18.  
  19. SqlCommand cmd = new SqlCommand();
  20. cmd.Parameters.Clear();
  21. cmd.Connection = con;
  22. int recordsAffected = cmd.ExecuteNonQuery();
  23.  
  24. if (recordsAffected == 0)
  25. { cmd.CommandText = "INSERT INTO [Table] ([Id], [Test1]) VALUES (@Id, @name)";
  26. // Добавить параметры
  27. cmd.Parameters.AddWithValue("@Id", 654);
  28. cmd.Parameters.AddWithValue("@name", textBox1.Text);//Выполнить
  29. cmd.ExecuteNonQuery();
  30. }
  31. con.Close();
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement