新手学习,遇到这个问题。下面是代码,请高手指点。设置过了断点,总是在catch那里,出现了如标题那样的输出提示。
protected void pubbutton_Click(object sender, EventArgs e)
{
if (titletext.Text == "")
TitleLab.Visible = true;
else TitleLab.Visible = false;
if (contenttext.Text == "")
ContentLab.Visible = true;
else ContentLab.Visible = false;
if (ClassRadio.SelectedItem==null)
ClassLab.Visible = true;
else ClassLab.Visible = false; string sp = ClassRadio.SelectedValue;
SqlConnection conn = new SqlConnection("server=(local);Initial Catalog=Gaga;Integrated Security=True");
try {
conn.Open();
SqlCommand cmd = new SqlCommand(sp, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Title",SqlDbType.VarChar,50);
cmd.Parameters["@Title"].Value = titletext.Text;
cmd.Parameters.Add("@Content",SqlDbType.NVarChar);
cmd.Parameters["@Content"].Value = contenttext.Text;
//cmd.Parameters.Add("@UID", SqlDbType.VarChar, 20);
//cmd.Parameters["@UID"].Value = this.User.Identity;///插入用户名
/////
cmd.Parameters.Add("@Time",SqlDbType.DateTime);
cmd.Parameters["@Time"].Value = System.DateTime.Now;
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
System.Console.WriteLine("数据库链接出错", ex.Message);
}///处理异常
///
finally {
conn.Close();
}
}
protected void pubbutton_Click(object sender, EventArgs e)
{
if (titletext.Text == "")
TitleLab.Visible = true;
else TitleLab.Visible = false;
if (contenttext.Text == "")
ContentLab.Visible = true;
else ContentLab.Visible = false;
if (ClassRadio.SelectedItem==null)
ClassLab.Visible = true;
else ClassLab.Visible = false; string sp = ClassRadio.SelectedValue;
SqlConnection conn = new SqlConnection("server=(local);Initial Catalog=Gaga;Integrated Security=True");
try {
conn.Open();
SqlCommand cmd = new SqlCommand(sp, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Title",SqlDbType.VarChar,50);
cmd.Parameters["@Title"].Value = titletext.Text;
cmd.Parameters.Add("@Content",SqlDbType.NVarChar);
cmd.Parameters["@Content"].Value = contenttext.Text;
//cmd.Parameters.Add("@UID", SqlDbType.VarChar, 20);
//cmd.Parameters["@UID"].Value = this.User.Identity;///插入用户名
/////
cmd.Parameters.Add("@Time",SqlDbType.DateTime);
cmd.Parameters["@Time"].Value = System.DateTime.Now;
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
System.Console.WriteLine("数据库链接出错", ex.Message);
}///处理异常
///
finally {
conn.Close();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货