PDA

View Full Version : مبتدی: syntax error



sadeghx98
چهارشنبه 27 شهریور 1392, 12:29 عصر
سلام ببخشید میشه بگید اشکال این کجاست
void addbook()
{
OleDbCommand bcm = new OleDbCommand("INSERT INTO book(number,bn,bw,bp) VALUES(@number,@bn,@bw,@bp)",cn);
bcm.Parameters.AddWithValue("@number",txtnum.Text.ToString());
bcm.Parameters.AddWithValue("@bn", txtbn.Text.ToString());
bcm.Parameters.AddWithValue("@bw", txtbw.Text.ToString());
bcm.Parameters.AddWithValue("@bp", txtbn.Text.ToString());
cn.Open();
bcm.ExecuteNonQuery();
cn.Close();
}

private void btnaddbook_Click(object sender, EventArgs e)
{
if (txtnum.Text == "" || txtbname.Text == "" || txtbw.Text == "" || txtbn.Text == "")
{
MessageBox.Show("لطفا همه ی فیلد ها را پر کنید");

}
else
{
addbook();
}
}

این خطا رو میده
Syntax error in INSERT INTO statement

hamid_hr
چهارشنبه 27 شهریور 1392, 12:58 عصر
// Create the InsertCommand.
command = new OleDbCommand(
"INSERT INTO Customers (CustomerID, CompanyName) " +
"VALUES (?, ?)", connection);

command.Parameters.Add(
"CustomerID", OleDbType.Char, 5, "CustomerID");
command.Parameters.Add(
"CompanyName", OleDbType.VarChar, 40, "CompanyName");