SQL update更新问题
protected void Button10_Click(object sender, EventArgs e)
{
string strSQL = "select JM_ID,JM_Title,JM_Url,JM_Url1,JM_Url2 from JM_Datas";
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, conn);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
int ID= Convert.ToInt32(dr["JM_ID"].ToString());
string strTitle = dr["JM_Title"].ToString();
string strUrl = dr["JM_Url"].ToString();
string strUrl1 = dr["JM_Url1"].ToString();
string strUrl2 = dr["JM_Url2"].ToString();
strUrl = HtmlDiscode(strUrl);
strUrl1 = HtmlDiscode(strUrl2);
strUrl2 = HtmlDiscode(strUrl2);
string strUp = "update JM_Datas set JM_Url='" + strUrl + "' and JM_Url1='" + strUrl1 + "' and JM_Url2='" + strUrl2 + "' where JM_Title='" + strTitle + "' and JM_ID=" + ID;
OleDbCommand cmdUp = new OleDbCommand(strUp, conn);
conn.Open();
cmdUp.ExecuteNonQuery();
conn.Close();
}
}
/// <summary>
/// 替换字符串函数
/// </summary>
/// <param name="theString">需要替换的字符串</param>
/// <returns>返回替换好的字符串</returns>
public string HtmlDiscode(string theString)
{
theString = theString.Replace("[www.maizi6.com]", "[www.558TV.com]");
theString = theString.Replace("[maizi6.com]", "[www.558TV.com]");
theString = theString.Replace("[www.chinaying.net]", "[www.558TV.com]");
theString = theString.Replace("(qvodzy.com.cn)", "[www.558TV.com]");
theString = theString.Replace("麦子乐", "小猪影视");
return theString;
}
为什么我更新的数据都变为空,-1,或0,断点测试update语句也没错!哪位高人知道?