بانک اطلاعات در C#

سوال

سلام وقتی دکمه ثبت اطلاعات رو در برنامه ی زیر می زنم

oleDbCommand1.Parameters.Clear();

<span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small"> oleDbCommand1.CommandText = </span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"insert into ali(name=mohammadhani,password=Parham,mobile=mohammadhani,email=MEHDI,code=camelia.ji) "</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">;</span></span>

<span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small"> oleDbCommand1.Parameters.AddWithValue(</span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"mohammadhani"</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">, textBox1.Text);</span></span>

<span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small"> oleDbCommand1.Parameters.AddWithValue(</span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"Parham"</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">, textBox2.Text);</span></span>

<span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small"> oleDbCommand1.Parameters.AddWithValue(</span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"mohammadhani"</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">, textBox3.Text);</span></span>

<span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small"> oleDbCommand1.Parameters.AddWithValue(</span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"MEHDI"</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">, textBox4.Text);</span></span>

<span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small"> oleDbCommand1.Parameters.AddWithValue(</span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"camelia.ji"</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">, textBox5.Text);</span></span>

oleDbConnection1.Open();

oleDbCommand1.ExecuteNonQuery();

oleDbConnection1.Close();

<span style="color: #2b91af;font-family: Consolas;font-size: small"><span style="color: #2b91af;font-family: Consolas;font-size: small"><span style="color: #2b91af;font-family: Consolas;font-size: small">MessageBox</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">.Show(</span></span><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small"><span style="color: #a31515;font-family: Consolas;font-size: small">"ثبت شد"</span></span></span><span style="font-family: Consolas;font-size: small"><span style="font-family: Consolas;font-size: small">);</span></span>

در خط

oleDbCommand1.ExecuteNonQuery();

خطا میده . مشکل از کجاست .در ضمن بانک اطلاعاتی رو درست به معرفی کردم

در حال بررسی 0
2016-05-21T02:37:14+03:30 1 پاسخ ها کاربر 0

پاسخ ( 1 )

  1. SOLTANE GHALBHA
    0
    2016-05-21T05:36:30+03:30
    پاسخ

    سلام

    چرا هم مقدار Value و هم نام جداول رو کنار هم نوشتید ؟

    کد زیر را امتحان کنید :

    private void btn_save_Click(object sender, EventArgs e)
{
	OleDbConnection OleDbConnection1 = new OleDbConnection(ConnectionString);
	OleDbCommand OleDbCommand1 = new OleDbCommand();
	OleDbCommand1.Connection = OleDbConnection1;
	OleDbCommand1.CommandType = CommandType.Text;
	OleDbCommand1.CommandText = "INSERT INTO ali(name,password,mobile,email,code) VALUES ('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"','"+textBox5.Text+"')";
	OleDbConnection1.Open();
	int result = OleDbCommand1.ExecuteNonQuery();
	OleDbConnection1.Close();

	if (result>0)
	{
		MessageBox.Show("Insert OK");
	}
	else
	{
		MessageBox.Show("Error In Insert");
	}
}

    موفق باشید

ارسال یک پاسخ