修改信息的update语句 执行之后 数据库没有更新 求大侠指教!
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand sqlcomm;
sqlcomm = new SqlCommand("update THypertensionManagement set fName='" + fName.Text + "',fBeginTime='" + fBeginTime.Text + "' where fID=" + LBfID.Text, sqlconn);
if (sqlcomm.ExecuteNonQuery() > 0)
{
Response.Write("<script language=javascript>alert('修改成功!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('修改失败!')</script>");
} }
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand sqlcomm;
sqlcomm = new SqlCommand("update THypertensionManagement set fName='" + fName.Text + "',fBeginTime='" + fBeginTime.Text + "' where fID=" + LBfID.Text, sqlconn);
if (sqlcomm.ExecuteNonQuery() > 0)
{
Response.Write("<script language=javascript>alert('修改成功!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('修改失败!')</script>");
} }
输入一下sql语句,在数据库中执行看看
看这个LZ的意思是FID是int类型的吧LZ把条件改下
fID=" + int.parse(LBfID.Text.Trim())...
这样改 fID= "+int.parse(LBfID.Txet.Trim())...
写程序,不能“我觉得没错”,设置断点,你调试运行到这句:
string strsql="update THypertensionManagement set fName='" + fName.Text + "',fBeginTime='" + fBeginTime.Text + "' where fID=" + LBfID.Text;把strsql实际值拷贝出来,粘贴到数据库查询分析器里执行!
DateTime ft=Convert.TodateTime(fBeginTime.Text)fBeginTime='" + ft + "'