还是不行，不是这里的问题。我在insert的时候全部用的 cmd.Parameters.AddWithValue(":zongjie", txt_Zongjie.Text.ToString());就没问题，以下是全部代码，希望有高手能指点。
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int int_Zhujian = int.Parse(Request.QueryString[0]);
string id_User = Session["id"].ToString();
if (e.CommandName == "edit")
{
RepeaterItem ri = e.Item;
TextBox txt_Dbfzr = ri.FindControl("txt_Dbfzr") as TextBox;//当班负责人
TextBox txt_Sjyls_Xh = ri.FindControl("txt_Sjyls_Xh") as TextBox;//三讲一落实序号
TextBox txt_Weixian = ri.FindControl("txt_Weixian") as TextBox;//危险点
TextBox txt_Cuoshi = ri.FindControl("txt_Cuoshi") as TextBox;//措施
TextBox txt_Zongjie = ri.FindControl("txt_Zongjie") as TextBox;//总结
TextBox txt_Jishi = ri.FindControl("txt_Jishi") as TextBox;//记事栏
TextBox txt_Xiuban = ri.FindControl("txt_Xiuban") as TextBox;//休班加班情况
Label lb_Lrr = ri.FindControl("lb_Lrr") as Label;//录入人
string str_Id = ""; string str_Nr = ""; string str_Fz = ""; string str_Gz = ""; string str_Gzsj = "";
for (int i = 1; i < 19; i++)
{
TextBox txt_No = ri.FindControl("no" + i) as TextBox;
TextBox txt_Context = ri.FindControl("context" + i) as TextBox;
TextBox txt_Fz = ri.FindControl("name_fuze" + i) as TextBox;
TextBox txt_Gz = ri.FindControl("name_gongzuo" + i) as TextBox;
TextBox txt_Sj = ri.FindControl("time" + i) as TextBox;
str_Id = str_Id + txt_No.Text.ToString() + "\r\n";//序号
str_Nr = str_Nr + txt_Context.Text.ToString() + "\r\n";//内容
str_Fz = str_Fz + txt_Fz.Text.ToString() + "\r\n";//负责人
str_Gz = str_Gz + txt_Gz.Text.ToString() + "\r\n";//工作人员
str_Gzsj = str_Gzsj + txt_Sj.Text.ToString() + "\r\n";//工作时间
}
using (OracleConnection conn = new OracleConnection(strConn))
{
string str_Cmd_a = "update gzrz set dbfzr='" + txt_Dbfzr.Text.ToString() + "',sn='" + str_Id + "',context='" + str_Nr + "',name_fuze='" + str_Fz + "',name_gongzuo='" + str_Gz + "',time='" + str_Gzsj + "',jishi='" + txt_Jishi.Text.ToString() + "',weixian='" + txt_Weixian.Text.ToString() + "',cuoshi='" + txt_Cuoshi.Text.ToString() + "',zongjie='" + txt_Zongjie.Text.ToString() + "',xiuban='" + txt_Xiuban.Text.ToString() + "',sjyls_xh='" + txt_Sjyls_Xh.Text.ToString() + "',lrr='"+lb_Lrr.Text.ToString()+"' where id=" + int_Zhujian;
string str_Cmd = "update gzrz set dbfzr=:dbfzr,sn=:sn,context=:context,name_fuze=:name_fuze,name_gongzuo=:name_gongzuo,time=:time,jishi=:jishi,weixian=:weixian,cuoshi=:cuoshi,zongjie=:zongjie,xiuban=:xiuban,sjyls_xh=:sjyls_xh,lrr=:lrr where id=" + int_Zhujian;
conn.Open();
using (OracleCommand cmd = new OracleCommand(str_Cmd, conn))
{
cmd.Parameters.AddWithValue(":dbfzr", txt_Dbfzr.Text.ToString());//当班负责人签字
cmd.Parameters.AddWithValue(":sn", str_Id);//日志编号
cmd.Parameters.AddWithValue("context", str_Nr);//日志内容
cmd.Parameters.AddWithValue(":name_fuze", str_Fz);//负责人
cmd.Parameters.AddWithValue(":name_gongzuo", str_Gz);//工作人员
cmd.Parameters.AddWithValue(":time", str_Gzsj);//工时
cmd.Parameters.AddWithValue(":jishi", txt_Jishi.Text.ToString());//记事栏
cmd.Parameters.AddWithValue(":sjyls_xh", txt_Sjyls_Xh.Text.ToString());//三讲一落实序号
cmd.Parameters.AddWithValue(":weixian", txt_Weixian.Text.ToString());//主要危险点
cmd.Parameters.AddWithValue(":cuoshi", txt_Cuoshi.Text.ToString());//根据主要危险点采取的措施
cmd.Parameters.AddWithValue(":zongjie", txt_Zongjie.Text.ToString());//总结
cmd.Parameters.AddWithValue(":xiuban", txt_Xiuban.Text.ToString());//休班加班等情况
cmd.Parameters.AddWithValue(":lrr", lb_Lrr.Text.ToString());//录入人
if (cmd.ExecuteNonQuery() > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');location.href='query.aspx'</script>");
}
}
}
}
}
如果用字符串拼接更新数据库就可以，如果用参数就不行，弄了一天了没想清楚为什么，代码如下：
