我有一个存储过程ck_list_no参数@rk_date as datetime ,@rk_user as char(30),@rk_depart as char(30),请问在C#中怎么使用这个存储过程小弟做到如下步骤
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ck_list_no";
请问高手接下来该怎么做呢
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ck_list_no";
请问高手接下来该怎么做呢
myComm.Parameters.Add(new SqlParameter("@Tables",SqlDbType.VarChar,1000)).Value = tabelname;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ck_list_no";
SqlParameter sqlpdate = new SqlParameter("@rk_date",SqlDbType.DateTime);
sqlpdate .Value = DateTime.Now;
myComm.Parameters.Add(sqlpdate);SqlParameter sqlpuser = new SqlParameter("@rk_user",SqlDbType.Char);
sqlpuser .Value = "你想要的值";
myComm.Parameters.Add(sqlpuser );
SqlParameter sqlpdepart= new SqlParameter("@rk_depart",SqlDbType.Char);
sqlpdepart.Value = "你想要的值";
myComm.Parameters.Add(sqlpdepart);try
{
cn.open();
myComm.ExecuteNonQuery();
}
catch(Exception ex)
{
//write your log;
}