using (DbConnection db = new SqlConnection(sqlConnectstr))
{
//不带参数的存储过程
List<StuInfo> listStuInfo = new List<StuInfo>();
listStuInfo = db.Query<StuInfo>("P_stuMarkInfo", null, null, true, null, CommandType.StoredProcedure).ToList();
if (listStuInfo.Count > 0)
{
listStuInfo.ForEach((stu) => this.textBox1.Text += stu.StuName + " ");
}
//带参数的存储过程
var p = new DynamicParameters();//动态参数类
p.Add("@w", int.Parse(txtw.Text));
p.Add("@l", int.Parse(txtL.Text));
p.Add("@countNum", 0, DbType.Int32, ParameterDirection.Output);
db.Execute("P_stuM