Mafia_ir
شنبه 15 بهمن 1390, 00:10 صبح
سلام ببخشید من این کدو نوشتم ولی این ارور رو گرفتم :
Syntax error in INSERT INTO statement.
چرا ؟
OleDbConnection ConnectionClass = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;"
+ @"Data Source=|DataDirectory|\Songs.accdb");
OleDbCommand Command = new OleDbCommand();
Command.Connection = ConnectionClass;
Command.CommandText = "INSERT INTO LogIn (UserName, Password, Credit, Age, DN, Email) "
+ "VALUES(@re_UserName, @re_Password, @re_Credit, @re_Age, @re_DN, @re_Email)";
Command.Parameters.AddWithValue("@re_UserName", Usernametxt.Text);
Command.Parameters.AddWithValue("@re_Password", Passwordtxt.Text);
Command.Parameters.AddWithValue("@re_Credit", "FreeUser");
Command.Parameters.AddWithValue("@re_Age", Oldtxt.Text);
Command.Parameters.AddWithValue("@re_DN", '0');
Command.Parameters.AddWithValue("@re_Email", Emailtxt.Text);
ConnectionClass.Open();
Command.ExecuteNonQuery();
ConnectionClass.Close();
Syntax error in INSERT INTO statement.
چرا ؟
OleDbConnection ConnectionClass = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;"
+ @"Data Source=|DataDirectory|\Songs.accdb");
OleDbCommand Command = new OleDbCommand();
Command.Connection = ConnectionClass;
Command.CommandText = "INSERT INTO LogIn (UserName, Password, Credit, Age, DN, Email) "
+ "VALUES(@re_UserName, @re_Password, @re_Credit, @re_Age, @re_DN, @re_Email)";
Command.Parameters.AddWithValue("@re_UserName", Usernametxt.Text);
Command.Parameters.AddWithValue("@re_Password", Passwordtxt.Text);
Command.Parameters.AddWithValue("@re_Credit", "FreeUser");
Command.Parameters.AddWithValue("@re_Age", Oldtxt.Text);
Command.Parameters.AddWithValue("@re_DN", '0');
Command.Parameters.AddWithValue("@re_Email", Emailtxt.Text);
ConnectionClass.Open();
Command.ExecuteNonQuery();
ConnectionClass.Close();