我的程序是实现编辑功能 ,从数据库中读出数据,然后更改,在存到数据库中,里面总出现错误,希望各位帮忙.谢谢我的程序如下: private void Button1_Click(object sender, System.EventArgs e)
{
Response.Write(biaoti.Text);
SqlConnection JX_Conn;
SqlCommand cmdUploadInfo; Stream objStream;
string Fujian_Type;
int Fujian_Len;
int fjnum = 0;
if(Fujian.PostedFile.ContentLength != 0)
{
fjnum = 1;
}
string neirong2;
neirong2 = Server.HtmlEncode(neirong.Text.Trim());
if ((biaoti.Text.Trim().Length==0)||(neirong2==""))
{
Response.Write("<script>alert(\"标题或内容不能为空\")</script>");
return;
}
else if (biaoti.Text.Trim().Length >= 200)
{
Response.Write("<script>alert(\"你的标题太长了!\")</script>");
return;
}
Fujian_Len = Fujian.PostedFile.ContentLength;
Fujian_Type = Fujian.PostedFile.ContentType;
byte[] Fujian_buffer = new byte[Fujian_Len]; objStream = Fujian.PostedFile.InputStream;
objStream.Read(Fujian_buffer ,0,Fujian_Len);
JX_Conn = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"]); cmdUploadInfo = new SqlCommand("P_JX_Upload_update",JX_Conn);
cmdUploadInfo.CommandType = CommandType.StoredProcedure;
cmdUploadInfo.Parameters.Add("@JX_ID_1 ",SqlDbType.Int,4);
cmdUploadInfo.Parameters.Add("@JX_Title_3 ",SqlDbType.VarChar,200);
cmdUploadInfo.Parameters.Add("@JX_F_Title_4 ",SqlDbType.VarChar,200);
cmdUploadInfo.Parameters.Add("@JX_Content_5",SqlDbType.VarChar,4000);
cmdUploadInfo.Parameters.Add("@JX_Fujiannum_6",SqlDbType.Int,4 );
cmdUploadInfo.Parameters.Add("@JX_Fujian_7",SqlDbType.Image );
cmdUploadInfo.Parameters.Add("@JX_Fujian_Type_8",SqlDbType.VarChar ,50);
cmdUploadInfo.Parameters[0].Value = Id;
cmdUploadInfo.Parameters[1].Value = biaoti.Text.Trim();
cmdUploadInfo.Parameters[2].Value = fbiaoti.Text.Trim();
cmdUploadInfo.Parameters[3].Value = neirong2.Trim();
cmdUploadInfo.Parameters[4].Value = fjnum;
cmdUploadInfo.Parameters[5].Value = Fujian_buffer;
cmdUploadInfo.Parameters[6].Value = Fujian_Type; try
{
JX_Conn.Open();
if(cmdUploadInfo.ExecuteNonQuery() == 1)
{
if(fjnum==1)
{
Response.Write("<script>alert(\"编辑成功,有附件\")</script>");
}
else
Response.Write("<script>alert(\"编辑成功,没有附件\")</script>");
}
else
Response.Write("<script>alert(\"更新失败\")</script>");
JX_Conn.Close();
}
catch(Exception err)
{
Console.WriteLine(err.ToString());
} biaoti.Text ="";
fbiaoti.Text ="";
neirong.Text ="";
}
{
Response.Write(biaoti.Text);
SqlConnection JX_Conn;
SqlCommand cmdUploadInfo; Stream objStream;
string Fujian_Type;
int Fujian_Len;
int fjnum = 0;
if(Fujian.PostedFile.ContentLength != 0)
{
fjnum = 1;
}
string neirong2;
neirong2 = Server.HtmlEncode(neirong.Text.Trim());
if ((biaoti.Text.Trim().Length==0)||(neirong2==""))
{
Response.Write("<script>alert(\"标题或内容不能为空\")</script>");
return;
}
else if (biaoti.Text.Trim().Length >= 200)
{
Response.Write("<script>alert(\"你的标题太长了!\")</script>");
return;
}
Fujian_Len = Fujian.PostedFile.ContentLength;
Fujian_Type = Fujian.PostedFile.ContentType;
byte[] Fujian_buffer = new byte[Fujian_Len]; objStream = Fujian.PostedFile.InputStream;
objStream.Read(Fujian_buffer ,0,Fujian_Len);
JX_Conn = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"]); cmdUploadInfo = new SqlCommand("P_JX_Upload_update",JX_Conn);
cmdUploadInfo.CommandType = CommandType.StoredProcedure;
cmdUploadInfo.Parameters.Add("@JX_ID_1 ",SqlDbType.Int,4);
cmdUploadInfo.Parameters.Add("@JX_Title_3 ",SqlDbType.VarChar,200);
cmdUploadInfo.Parameters.Add("@JX_F_Title_4 ",SqlDbType.VarChar,200);
cmdUploadInfo.Parameters.Add("@JX_Content_5",SqlDbType.VarChar,4000);
cmdUploadInfo.Parameters.Add("@JX_Fujiannum_6",SqlDbType.Int,4 );
cmdUploadInfo.Parameters.Add("@JX_Fujian_7",SqlDbType.Image );
cmdUploadInfo.Parameters.Add("@JX_Fujian_Type_8",SqlDbType.VarChar ,50);
cmdUploadInfo.Parameters[0].Value = Id;
cmdUploadInfo.Parameters[1].Value = biaoti.Text.Trim();
cmdUploadInfo.Parameters[2].Value = fbiaoti.Text.Trim();
cmdUploadInfo.Parameters[3].Value = neirong2.Trim();
cmdUploadInfo.Parameters[4].Value = fjnum;
cmdUploadInfo.Parameters[5].Value = Fujian_buffer;
cmdUploadInfo.Parameters[6].Value = Fujian_Type; try
{
JX_Conn.Open();
if(cmdUploadInfo.ExecuteNonQuery() == 1)
{
if(fjnum==1)
{
Response.Write("<script>alert(\"编辑成功,有附件\")</script>");
}
else
Response.Write("<script>alert(\"编辑成功,没有附件\")</script>");
}
else
Response.Write("<script>alert(\"更新失败\")</script>");
JX_Conn.Close();
}
catch(Exception err)
{
Console.WriteLine(err.ToString());
} biaoti.Text ="";
fbiaoti.Text ="";
neirong.Text ="";
}
解决方案 »
- 打印功能的实现
- vs2010里类图添加类不能定义命名空间吗
- SQL2005连接问题
- richtextbox中如何实现下面这段文字的字体颜色设置?
- 求教我在VS2003.net下的DataGrid控件的单元格中通过样式添加了ComboBox控件但是如何得到SelectValue
- 请问如何使用C#模拟登录这种HTTPS验证页面
- 使用自动化在word文档中找页尾
- 从“10-100能被3或5整除的数的和”想到的
- 数据绑定的问题,搞不定了,着急等待帮忙
- 急问在datagrid中用DataFormatString="{0:d}"如何规定日期的显示格式为dd/mm/yyyy!!!!!!
- 问一个listview控件的光标和mousemove的问题
- windowsform的问题,大家帮顶谢谢
我是用Int32.Parse(Id)方法的,其中Id是string类型,但转了还是有问题