Question

System.Data.SqlClient.SqlException: '（' 附近有语法错误。

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "addshop")
{
//商品id
string id = DataList1.DataKeys[e.Item.ItemIndex].ToString();
string username = "nihao";
int goodid = Convert.ToInt32(id);

//购买者

String strconn;
strconn = "Server=ZEE-PC;DataBase=sb;Uid=sa;pwd='123456'";
SqlConnection conn=new SqlConnection(strconn);
conn.Open();

string sqlstr = "insert into carts （username，goodid） values('" + username + "'," + goodid + ")";
SqlCommand scmd = new SqlCommand(sqlstr, conn);
scmd.ExecuteNonQuery();

//Response.Write("id");
}
}
protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{

}
}

Answer 1

SQL语法错误吧，看上面的代码SQL语句中的括号好像不一样啊后面的是不是中文括号。

Answer 2

你看一下括号是不是有全角的括号或中文的括号。