Dictionary<string, string> dcts = new Dictionary<string, string>();
dct.Add("UserPess", "123456789");
dct.Add("StaffName", "死歌");
dcts.Add("UserName", "zsexaq"); foreach (string i in dct.Keys)
{
foreach (string u in dct.Values)
{
sqltextss += u;
sqltexts = i + "='" + sqltextss.Substring(0, sqltextss.Length - 1);
}
sqltext += sqltexts.Substring(0, sqltexts.Length - 1) +"' ";
}我写的是这样·但是不对呀··
update T_StaffNews set UserPess='123456789死歌zsex' StaffName='123456789死歌zsexaq123456789死歌zsex' UserName='123456789死歌zsexaq123456789死歌zsexaq123456789死歌zsex'这完全不对呀·那位大神教教我怎么改哟!
dct.Add("UserPess", "123456789");
dct.Add("StaffName", "死歌");
dcts.Add("UserName", "zsexaq"); foreach (string i in dct.Keys)
{
foreach (string u in dct.Values)
{
sqltextss += u;
sqltexts = i + "='" + sqltextss.Substring(0, sqltextss.Length - 1);
}
sqltext += sqltexts.Substring(0, sqltexts.Length - 1) +"' ";
}我写的是这样·但是不对呀··
update T_StaffNews set UserPess='123456789死歌zsex' StaffName='123456789死歌zsexaq123456789死歌zsex' UserName='123456789死歌zsexaq123456789死歌zsexaq123456789死歌zsex'这完全不对呀·那位大神教教我怎么改哟!
{ }
StringBuilder sb = new StringBuilder();
sb.Append("update table set ");
foreach (KeyValuePair<string, string> kvp in dics)
{
sb.Append(string.Format(" {0}='{1}',", kvp.Key, kvp.Value));//<-假定都是字符串
}
string sql = sb.ToString().TrimEnd(',');
dcts.Add("UserPess", "123456789");
dcts.Add("StaffName", "死歌");
dcts.Add("UserName", "zsexaq");
string sqltexts = "update T_StaffNews set ";
foreach (string i in dcts.Keys)
{
sqltexts = sqltexts + i + "='" + dcts[i] + "',";
}
sqltexts = sqltexts.Remove(sqltexts.Length - 1);
说错了·那里被我改了··
现在运行·说 sqltexts 是空的