为什么提示“=”附近有语法错误
来源:百度知道 编辑:UC知道 时间:2024/05/27 01:40:20
private void button1_Click(object sender, EventArgs e)
{
string sql = "select no,sex,name,city from coo";
switch (comboBox1.Text ) {
case "男":
sql += "where sex='男'";
break;
case"女":
sql += "where sex='女'";
break;
default:
break;
}
dataset.Tables["coo"].Clear();
dataadapter.SelectCommand.CommandText = sql;
dataadapter.Fill(dataset,"coo");
{
string sql = "select no,sex,name,city from coo";
switch (comboBox1.Text ) {
case "男":
sql += "where sex='男'";
break;
case"女":
sql += "where sex='女'";
break;
default:
break;
}
dataset.Tables["coo"].Clear();
dataadapter.SelectCommand.CommandText = sql;
dataadapter.Fill(dataset,"coo");
sql语句写错了就会提示=号附近有错误
where sex='男'
where sex='女'
注意:要加空格 where sex='男' where sex='女'
或者string sql = "select no,sex,name,city from coo 这里加几个空格也可以";
where前缺少一个空格
sql+=" where sex='女'";就可以了
sql += " where sex='男'";
就可以了
where前面没有空格吧?