C#便捷的执行存储过程
public void 方法名称(string sUrl, string sImgName)
{
using (SqlConnection conn = new SqlConnection( System.Configuration.ConfigurationSettings.AppSettings["连接串"].ToString()))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("存储过程名称", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cImageName", SqlDbType.NVarChar, 50).Value = sImgName;
cmd.Parameters.Add("@cUrlAli", SqlDbType.NVarChar, 200).Value = sUrl;
cmd.ExecuteNonQuery();
}
}
}