Question

急急急！VS2008，asp.net（C#），关键字 'Order' 附近有语法错误。 怎么解决？

protected void Button3_Click(object sender, EventArgs e)
{

string shipping_name = TextBox1.Text;
string shipping_phone = TextBox2.Text;
string shipping_city = TextBox3.Text;
string shipping_add = TextBox4.Text;
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["db_database02ConnectionString2"].ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("Insert Into Order(shipping_name,shipping_phone,shipping_city,shipping_add) values(@shipping_name,@shipping_phone,@shipping_city,@shipping_add)", connection);
command.CommandType = CommandType.Text;
command.Parameters.Add("@shipping_name", SqlDbType.VarChar, 50).Value = shipping_name;
command.Parameters.Add("@shipping_phone", SqlDbType.VarChar, 50).Value = shipping_phone;
command.Parameters.Add("@shipping_city", SqlDbType.VarChar, 50).Value = shipping_city;
command.Parameters.Add("@shipping_add", SqlDbType.VarChar, 50).Value = shipping_add;

command.ExecuteNonQuery();
Page.RegisterStartupScript("", "<script language=javascript> parent.window.alert('订单提交成功!');</script>");
}
}
这是“提交订单”button的语句
数据库中OrderID设置的主键，并表示增量设置成1

Answer 1

order是数据库的保留字，有一个 order by 是将查询结果按照某个字段排序的作用
为了区别保留字的表名
将order外加上[]试一下

Answer 2

order是关键字，你用[]方括号，给括下，去试下！！！

Answer 3

Insert Into Order(shipping_name,shipping_phone,shipping_city,shipping_add) values(@shipping_name,@shipping_phone,@shipping_city,@shipping_add)

order是关键字

Insert Into [Order] (shipping_name,shipping_phone,shipping_city,shipping_add) values(@shipping_name,@shipping_phone,@shipping_city,@shipping_add)