Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void button1_Click(object sender, EventArgs e)
- { // this.tableTableAdapter.Update(test_0DataSet3);
- try
- {
- this.Validate();
- this.tableBindingSource.EndEdit();//разрешил изменения
- this.tableTableAdapter.Update(this.test_0DataSet3.Table);
- MessageBox.Show("Данные oбновлены!");
- }
- catch(System.Exception ex)
- {
- MessageBox.Show("Ошибка обновления!");
- }
- using (SqlConnection con = new SqlConnection())
- {con.ConnectionString = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=|DataDirectory|Test_0.mdf;Integrated Security=True;Connect Timeout=30";
- con.Open();
- SqlCommand cmd = new SqlCommand();
- cmd.Parameters.Clear();
- cmd.Connection = con;
- int recordsAffected = cmd.ExecuteNonQuery();
- if (recordsAffected == 0)
- { cmd.CommandText = "INSERT INTO [Table] ([Id], [Test1]) VALUES (@Id, @name)";
- // Добавить параметры
- cmd.Parameters.AddWithValue("@Id", 654);
- cmd.Parameters.AddWithValue("@name", textBox1.Text);//Выполнить
- cmd.ExecuteNonQuery();
- }
- con.Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement