string sql = "select * from dingdan";
if (sheng != "")
{
sql += " and Province='" + sheng + "'";
}
if (shi != "")
{
sql += " and City='" + shi + "'";
}像这样sql会等于"select * from dingdan"" and Province='" + sheng + "'"" and City='" + shi + "'";而不是"select * from dingdan and Province='" + sheng + "' and City='" + shi + "'";请教这样改怎样解决
if (sheng != "")
{
sql += " and Province='" + sheng + "'";
}
if (shi != "")
{
sql += " and City='" + shi + "'";
}像这样sql会等于"select * from dingdan"" and Province='" + sheng + "'"" and City='" + shi + "'";而不是"select * from dingdan and Province='" + sheng + "' and City='" + shi + "'";请教这样改怎样解决
if (sheng != "")
{
sql += " and Province='" + sheng + "'";
}
if (shi != "")
{
sql += " and City='" + shi + "'";
}