Редактирование информации в БД и dataGridView
13.06.2014, 17:11. Показов 1120. Ответов 3
Подскажите пожалуйста где ошибка, серьезно не понимаю
| C# | 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
| private void button2_Click(object sender, EventArgs e)
{
int id_letter = Convert.ToInt32(textBox4.Text);
DateTime date1 = Convert.ToDateTime(dateTimePicker1.Value.Date);
//string type = (comboBox1.SelectedIndex + 1).ToString();
string name = textBox2.Text;
string surname = textBox1.Text;
string patr = textBox3.Text;
string index1 = textBox8.Text;
string country = textBox7.Text;
string area = textBox6.Text;
string region = textBox11.Text;
string city = textBox10.Text;
string street = textBox9.Text;
string house = textBox12.Text;
string office = textBox13.Text;
string fromTo = textBox24.Text;
string content = richTextBox1.Text;
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["LettersVKR.Properties.Settings.LettersConnectionString"].ToString();
OleDbConnection Connection = new OleDbConnection(ConnectionString);
Connection.Open();
/*OleDbCommand Command = new OleDbCommand(ConnectionString, Connection);//[Date1]='" + Convert.ToDateTime(dateTimePicker1.Value.Date) + "',
Command.Connection = Connection;
Command.CommandText = "UPDATE [letter] Set [Surname]='" + textBox1.Text + "',[Name]='" + textBox2.Text + "',[Patronymic]='" + textBox3.Text + "',[Index1]='" + textBox8.Text + "',[Country]='" + textBox7.Text + "',[Area]='" + textBox6.Text + "',[Region]='" + textBox11.Text + "',[City]='" + textBox10.Text + "',[Street]='" + textBox9.Text + "',[House]='" + textBox12.Text + "',[Office]='" + textBox13.Text + "',[FromTo]='" + textBox24.Text + "',[Content]='" + richTextBox1.Text + "' WHERE [ID_letter]='" + 2+ "'";
Command.ExecuteNonQuery();
myCon.Close();*/
OleDbCommand update = new OleDbCommand("UPDATE letter SET Date1='" + dateTimePicker1.Value.Date + "',Surname='" + textBox1.Text + "',Name='" + textBox2.Text + "',Patronymic='" + textBox3.Text + "',Index1='" + textBox8.Text + "',Country='" + textBox7.Text + "',Area='" + textBox6.Text + "',Region='" + textBox11.Text + "',City='" + textBox10.Text + "',Street='" + textBox9.Text + "',House='" + textBox12.Text + "',Office='" + textBox13.Text + "',FromTo='" + textBox24.Text + "',Content='" + richTextBox1.Text + "', WHERE ID_letter = " + id_letter + " ", Connection);
//Connection.Open();
update.ExecuteNonQuery();
Connection.Close();
MessageBox.Show("Письмо успешно отредактировано!", "Редактирование письма");
this.Hide();
Form1 form = new Form1();
form.Show();
// Close();
} |
|
при использовании кода: | C# | 1
2
3
4
5
| OleDbCommand update = new OleDbCommand("UPDATE letter SET Date1='" + dateTimePicker1.Value.Date + "',Surname='" + textBox1.Text + "',Name='" + textBox2.Text + "',Patronymic='" + textBox3.Text + "',Index1='" + textBox8.Text + "',Country='" + textBox7.Text + "',Area='" + textBox6.Text + "',Region='" + textBox11.Text + "',City='" + textBox10.Text + "',Street='" + textBox9.Text + "',House='" + textBox12.Text + "',Office='" + textBox13.Text + "',FromTo='" + textBox24.Text + "',Content='" + richTextBox1.Text + "', WHERE ID_letter = " + id_letter + " ", Connection);
//Connection.Open();
update.ExecuteNonQuery();
Connection.Close(); |
|
"Ошибка синтаксиса в инструкции UPDATE."
А при : | C# | 1
2
3
4
5
| OleDbCommand Command = new OleDbCommand(ConnectionString, Connection);//[Date1]='" + Convert.ToDateTime(dateTimePicker1.Value.Date) + "',
Command.Connection = Connection;
Command.CommandText = "UPDATE [letter] Set [Surname]='" + textBox1.Text + "',[Name]='" + textBox2.Text + "',[Patronymic]='" + textBox3.Text + "',[Index1]='" + textBox8.Text + "',[Country]='" + textBox7.Text + "',[Area]='" + textBox6.Text + "',[Region]='" + textBox11.Text + "',[City]='" + textBox10.Text + "',[Street]='" + textBox9.Text + "',[House]='" + textBox12.Text + "',[Office]='" + textBox13.Text + "',[FromTo]='" + textBox24.Text + "',[Content]='" + richTextBox1.Text + "' WHERE [ID_letter]='" + 2+ "'";
Command.ExecuteNonQuery();
myCon.Close(); |
|
"Несоответствие типов данных в выражении условия отбора"
0
|
(
