protected void Button1_Click(object sender, EventArgs e)
{
string getNewsTitle = this.TextBox1.Text.ToString().Trim();
string getNewsContent = this.TextBox2.Text.ToString();
string getNewsAuthor = this.TextBox3.Text.ToString();
string strConn = WebConfigurationManager.ConnectionStrings["SteelFactoryConnectionString"].ConnectionString;
SqlConnection myConn = new SqlConnection(strConn);
SqlCommand mycomm = new SqlCommand("sp_AddNews",myConn);
mycomm.CommandType = CommandType.StoredProcedure;
#region 为 3个参数指定数据类型并赋值
SqlParameter[] paras =
{
new SqlParameter("@sNewsTitle",SqlDbType.NVarChar,100),
new SqlParameter("@sNewsContent", SqlDbType.NText),
new SqlParameter("@sNewsAuthor", SqlDbType.NVarChar, 50),
};
paras[0].Value = getNewsTitle;
paras[1].Value = getNewsContent;
paras[2].Value = getNewsAuthor;
foreach (SqlParameter pa in paras)
{
mycomm.Parameters.Add(pa);
}
myConn.Open();
try
{
mycomm.ExecuteNonQuery();
}
catch
{
this.Label1.Text = "操作遇到不可知错误!请与管理员联系";
}
#endregion
}
{
string getNewsTitle = this.TextBox1.Text.ToString().Trim();
string getNewsContent = this.TextBox2.Text.ToString();
string getNewsAuthor = this.TextBox3.Text.ToString();
string strConn = WebConfigurationManager.ConnectionStrings["SteelFactoryConnectionString"].ConnectionString;
SqlConnection myConn = new SqlConnection(strConn);
SqlCommand mycomm = new SqlCommand("sp_AddNews",myConn);
mycomm.CommandType = CommandType.StoredProcedure;
#region 为 3个参数指定数据类型并赋值
SqlParameter[] paras =
{
new SqlParameter("@sNewsTitle",SqlDbType.NVarChar,100),
new SqlParameter("@sNewsContent", SqlDbType.NText),
new SqlParameter("@sNewsAuthor", SqlDbType.NVarChar, 50),
};
paras[0].Value = getNewsTitle;
paras[1].Value = getNewsContent;
paras[2].Value = getNewsAuthor;
foreach (SqlParameter pa in paras)
{
mycomm.Parameters.Add(pa);
}
myConn.Open();
try
{
mycomm.ExecuteNonQuery();
}
catch
{
this.Label1.Text = "操作遇到不可知错误!请与管理员联系";
}
#endregion
}