62,025
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE pro_addgoods
@u_name nvarchar(50),
@gi_click int,
@gi_title nvarchar(50)
As
insert into t_goods_info(u_name,gi_click,gi_title) values(@u_name,@gi_click,@gi_title)
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ershouConnectionString"].ToString());
//声明执行存储过程的SqlCommand
SqlCommand scd_sel = new SqlCommand("pro_addgoods", conn);
scd_sel.CommandType = CommandType.StoredProcedure;
//给存储过程的参数赋值
SqlParameter spa;
spa = scd_sel.Parameters.Add("@u_name", SqlDbType.NVarChar, 50);
spa.Direction = ParameterDirection.Input;
spa.Value = Session["account"].ToString();
spa = scd_sel.Parameters.Add("@gi_click", SqlDbType.Int, 4);
spa.Direction = ParameterDirection.Input;
spa.Value = 0;
spa = scd_sel.Parameters.Add("@gi_title", SqlDbType.NVarChar, 50);
spa.Direction = ParameterDirection.Input;
spa.Value = txttitle.Text;
//执行存储过程
if (conn.State == ConnectionState.Closed)
conn.Open();
try
{
scd_sel.ExecuteNonQuery();
scd_sel.Dispose(); //释放资源
}
catch (SqlException ae)
{
throw (ae);
}
conn.Dispose();