在查询中加入条件的语句怎么写？（条件是变量）

[qiqian]

string strSQL =
"SELECT * FROM Customer where City"+Label1.Text.ToString();

用这句话查询总是出错,请问到底是为什么
private void Button1_Click(object sender, System.EventArgs e)
{
Label2.Text ="Your Select City Is "+CityName.SelectedItem.Text;
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Inetpub\\wwwroot\\aspbbs\\data\\xtreme.mdb";
string strSQL ="SELECT * FROM Customer where City="+CityName.SelectedItem.Text.ToString();
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbCommand myCmd = new OleDbCommand(strSQL,myConn);
myCmd.Connection.Open();
DataGrid1.DataSource=myCmd.ExecuteReader();
DataGrid1.DataBind();
}

[lcooky]

string strSQL =
"SELECT * FROM Customer where City='"+Label1.Text.ToString()+"'";

[qiqian]

哦对了
我忘了在where子句后面要加引号的
多谢！！！

[zag]

看清楚City在数据库中是什么类型的

[hmbory]

应该解决了吧！：）