///
/// 执行存储过程
///
/// 存储过程名
/// 存储过程参数
/// SqlDataReader
public static SqlDataReader RunProcedure(string storedProcName, IDataParameter[] parameters)
{
SqlConnection connection = OpenSqlConnection();
SqlCommand command = new SqlCommand();
try
{
command.CommandText = storedProcName;
command.Connection = connection;
if (parameters != null)
{
foreach (IDataParameter parm in parameters)
{
command.Parameters.Add(parm);
}
}
command.CommandType = CommandType.StoredProcedure;
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
SqlDataReader returnReader = command.ExecuteReader(CommandBehavior.CloseConnection);
command.Parameters.Clear();
return returnReader;
}
catch (Exception e)
{
//e.Message;
connection.Close();
throw;
}
}
以上是我写的调用存储过程的方法
如我我页面上要调用存储过程去执行一个参数为1的操作 该怎么传这个参数呢