cs:
if (Request.QueryString["ID"] == null)
{
string intoSQL = "";
intoSQL = "insert into webabout (nFile,nTitle,nHtmlText,ncode) values (";
intoSQL += "" + myClass.replace(txtid.Text) + ",";
intoSQL += "'" + myClass.replace(txtitle.Text) + "',";
intoSQL += "'" + txtContent.Text + "',";
intoSQL += "'" + dbobj.getautoNum("webabout", "nFile") + "')";
dbobj.getcom("insert into " + intoSQL);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");
}类为:
public SqlConnection getcon()
{
string myStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
// string myStr = "server=ADMIN;database=test;User id=sa;password=123";
SqlConnection Sqlcon = new SqlConnection(myStr);
return Sqlcon;
}
public bool getcom(string M_str_Sqlstr)
{
SqlConnection Sqlcon = this.getcon();
Sqlcon.Open();
SqlCommand Sqlcom = new SqlCommand(M_str_Sqlstr, Sqlcon);
try
{
Sqlcom.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
Sqlcon.Close();
}
}表为webabout:nFile为int,nTitle为nvarchar,nHtmlText为ntext,ncode为int,
为什么提示添加成功,数据库却为空
if (Request.QueryString["ID"] == null)
{
string intoSQL = "";
intoSQL = "insert into webabout (nFile,nTitle,nHtmlText,ncode) values (";
intoSQL += "" + myClass.replace(txtid.Text) + ",";
intoSQL += "'" + myClass.replace(txtitle.Text) + "',";
intoSQL += "'" + txtContent.Text + "',";
intoSQL += "'" + dbobj.getautoNum("webabout", "nFile") + "')";
dbobj.getcom("insert into " + intoSQL);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");
}类为:
public SqlConnection getcon()
{
string myStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
// string myStr = "server=ADMIN;database=test;User id=sa;password=123";
SqlConnection Sqlcon = new SqlConnection(myStr);
return Sqlcon;
}
public bool getcom(string M_str_Sqlstr)
{
SqlConnection Sqlcon = this.getcon();
Sqlcon.Open();
SqlCommand Sqlcom = new SqlCommand(M_str_Sqlstr, Sqlcon);
try
{
Sqlcom.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
Sqlcon.Close();
}
}表为webabout:nFile为int,nTitle为nvarchar,nHtmlText为ntext,ncode为int,
为什么提示添加成功,数据库却为空
'" + dbobj.getautoNum("webabout", "nFile") + "'这个到底什么意思?函数吗?如果是,是不能这样拼接的
{
int Num;
DataSet myds = GetDataSet("select top 1 * from " + P_str_table + " order by " + P_str_tbColumn + " desc ", P_str_table);
if (myds.Tables[0].DefaultView.Count != 0) Num = Convert.ToInt32(myds.Tables[0].Rows[0][P_str_tbColumn]) + 1;
else Num = 1;
return Num;
}
string intoSQL = "";
int ncode= dbobj.getautoNum("webabout", "nFile");//不是整数嘛?为什么加单引号
intoSQL = "insert into webabout (nFile,nTitle,nHtmlText,ncode) values (";
intoSQL += "" + myClass.replace(txtid.Text) + ",";
intoSQL += "'" + myClass.replace(txtitle.Text) + "',";
intoSQL += "'" + txtContent.Text + "',";
intoSQL += "" +ncode+ ")";
dbobj.getcom("insert into " + intoSQL);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");
晕!给你写代码吧:public void getcom(string M_str_Sqlstr)
{
using(SqlConnection Sqlcon = this.getcon())
{
Sqlcon.Open();
SqlCommand Sqlcom = new SqlCommand(M_str_Sqlstr, Sqlcon);
Sqlcom.ExecuteNonQuery();
}
}这样你就能开始学会调试程序、知道自己怎样改进程序代码了。
可能写入 日志文件中,也可以写到数据库中啊,
也可以写时 各变量都记录下来。当然 调试时不用 try catch
——这席话,瞬间让我改变了对楼主的负面想法....
对楼主 负面的印象 开始抬高....——当我进入楼主的博客:男的,楼主在我心目中的形象再次急速坠落到地上....
—————————————————————————————————————
我记得。我写过一个 小程序,导入 80G,总计 几千万行要导入到数据库,我当时就没有写一行 try-catch 程序内存也没有爆掉:不依靠 try-catch 写出稳定代码 会让一个程序员觉得非常自豪(当然,这个项目 也算简单,代码也不很多)try-catch 是种病.....
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");
=========
getcom没有判断返回值,所以不论插入是否成功,都会提示成功
调试阶段还是把return false改成throw吧。。