Question

ASP.NET * 附近有语法错误

protected void Button1_Click(object sender, EventArgs e)
{
//connection
String strCon = "Data Source=suizhikuo;Initial Catalog=mytest;Persist Security Info=True;User ID=sa;Password=suizhikuo12081208";
SqlConnection con = new SqlConnection(strCon);

//commmand
String sqlStr="delete * from userinfo where userid ="+Convert .ToInt16 ( userid.SelectedItem .Text) ;
SqlCommand cmd = new SqlCommand(sqlStr, con);

//open
con.Open();
cmd.ExecuteNonQuery();
Label1.Text = "删除成功";
con.Close();
MyBind();
}

执行 cmd.ExecuteNonQuery();
时，提示 * 附近有语法错误 怎么回事啊？？

Answer 1

String sqlStr="delete * from userinfo where userid .... delete语句错了

去掉 * 号

语法： DELETE FROM 表名称 WHERE 列名称 = 值

Answer 2

delete * from 改成 delete from
delete是不需要写*的

Answer 3

*和from之间应该有空格的，你连在一起肯定错了

Answer 4

去掉 "*" 就行了.