Question

C#，update 的where条件是两个，但是用and连接时总提示用分号隔开；

public void Update1(Hashtable leibie, string leibie_bianhao,string leibie_fubianhao)
{
Database db = new Database();
string strCond = "Where leibie_bianhao = '" + leibie_bianhao and "leibie_fubianhao=" + leibie_fubianhao;
db.Update("[leibie]", leibie, strCond);
}

Answer 1

字符串的单引号位置错了。
public void Update1(Hashtable leibie, string leibie_bianhao,string leibie_fubianhao)
{
Database db = new Database();
string strCond = "Where leibie_bianhao = '" + leibie_bianhao +"' and leibie_fubianhao='" + leibie_fubianhao + "'";
db.Update("[leibie]", leibie, strCond);
}

Answer 2

public void Update1(Hashtable leibie, string leibie_bianhao,string leibie_fubianhao)
{
Database db = new Database();
string strCond = "Where leibie_bianhao = '" + leibie_bianhao+"' and leibie_fubianhao='" + leibie_fubianhao+"'";
db.Update("[leibie]", leibie, strCond);
}

Answer 3

public void Update1(Hashtable leibie, string leibie_bianhao,string leibie_fubianhao)
{
Database db = new Database();
string strCond = "Where leibie_bianhao = '" + leibie_bianhao and "leibie_fubianhao=" + leibie_fubianhao;
string strCond = "Where leibie_bianhao=' "+leibie_bianhao+" ' and leibie_fubianhao=' " +leibie_fubianhao+" ' ";
db.Update("[leibie]", leibie, strCond);
}

Answer 4

1. 你的sql语句拼接有错误
2. update语句为什么没有看到update关键字？