大家帮我看看这段代码有什么错误,谢谢了
s_sql = "insert into [New_news]([n_大类id],[n_标题],[n_正文],[n_小图片],[n_来源],[n_发布人],[n_置顶],[n_小类id],[n_关键字]) values(" +
"" + s_lb + ",'" + s_title + "','" + s_content + "','" + s_xtp + "','" + s_ly + "','" + Session["User"].ToString() + "'," + i_top + "," + i_zl + ",'"+s_gjz+"')"; //SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connb2b"].ToString());
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connb2b"].ToString());
conn.Open();
SqlTransaction myTran = conn.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Transaction = myTran;
try
{ myCommand.CommandText = s_sql;
//myCommand.ExecuteNonQuery();
myCommand.ExecuteNonQuery();
toHtml th = new toHtml();
myCommand.CommandText = "select nid from Nes_news where nid=(select @@ideintity)";
Response.Write(myCommand.CommandText);
Response.End();
SqlDataReader sdr = myCommand.ExecuteReader();
bool flag;
while(sdr.Read())
{
flag = th.writeHtml(Convert.ToInt32(sdr["nid"]));
}
myTran.Commit();
Response.Write("<script language=javascript>alert('提交成功');location.href='NewsList.aspx'; </script>");
Response.End(); }
catch (Exception ee)
{
myTran.Rollback();
Response.Write("<script language=javascript>alert('提交失败');location.href='NewsAdd.aspx'; </script>");
Response.End();
}
conn.Close();
其中到myCommand.ExecuteNonQuery();就跳到catch 语句了
s_sql = "insert into [New_news]([n_大类id],[n_标题],[n_正文],[n_小图片],[n_来源],[n_发布人],[n_置顶],[n_小类id],[n_关键字]) values(" +
"" + s_lb + ",'" + s_title + "','" + s_content + "','" + s_xtp + "','" + s_ly + "','" + Session["User"].ToString() + "'," + i_top + "," + i_zl + ",'"+s_gjz+"')"; //SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connb2b"].ToString());
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connb2b"].ToString());
conn.Open();
SqlTransaction myTran = conn.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Transaction = myTran;
try
{ myCommand.CommandText = s_sql;
//myCommand.ExecuteNonQuery();
myCommand.ExecuteNonQuery();
toHtml th = new toHtml();
myCommand.CommandText = "select nid from Nes_news where nid=(select @@ideintity)";
Response.Write(myCommand.CommandText);
Response.End();
SqlDataReader sdr = myCommand.ExecuteReader();
bool flag;
while(sdr.Read())
{
flag = th.writeHtml(Convert.ToInt32(sdr["nid"]));
}
myTran.Commit();
Response.Write("<script language=javascript>alert('提交成功');location.href='NewsList.aspx'; </script>");
Response.End(); }
catch (Exception ee)
{
myTran.Rollback();
Response.Write("<script language=javascript>alert('提交失败');location.href='NewsAdd.aspx'; </script>");
Response.End();
}
conn.Close();
其中到myCommand.ExecuteNonQuery();就跳到catch 语句了
解决方案 »
- C# 里,封装一个函数,既把函数执行结果返回,又要返回部分内容,不用,REF还有它法不?
- 64位 sql 2005 问题
- c#.net 编写的sql数据库分页和控件分页结合的实例
- 为何在自定义类中无法调用application,session等对象。
- 如何将两个查询合并??
- 绑定到对象后的数据刷新问题
- IrisSkin2.dll控件引用之后,所有控件格式统一,如果局部想取消显示自定义格式,怎么办呢?
- 在C#中如何写程序让电脑定时关机
- VS2010中文版如何打包成英文版的安装包?
- SqlCommand,SqlDataAdapter在连接的启动上的问题?我快没有分了,帮帮忙!
- ling 数组问题
- timer计时器问题
二、可能数据库没有连上或没有打开