C# 之行存储过程操作数据库演示
public void LogRequest(string requestor, string messageBody)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("wp_InsertRequest", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("Requestor", requestor));
cmd.Parameters.Add(new SqlParameter("EmailBody", messageBody));
cmd.ExecuteNonQuery();
}
}
开心洋葱 , 版权所有丨如未注明 , 均为原创丨未经授权请勿修改 , 转载请注明C# 之行存储过程操作数据库示范！
