如何在网站建设（asp.net）中使用存储过程

public static SqlCommand CreateCmd(string procName, SqlParameter[] prams, SqlConnection Conn)    {        SqlConnection SqlConn = Conn;        if (SqlConn.State.Equals(ConnectionState.Closed))        {            SqlConn.Open();        }        SqlCommand Cmd = new SqlCommand();        Cmd.CommandType = CommandType.StoredProcedure;//按照存储过程解决        Cmd.Connection = SqlConn;        Cmd.CommandText = procName;//存储过程名        if (prams != null)        {            foreach (SqlParameter parameter in prams)            {                if (parameter != null)                {                    Cmd.Parameters.Add(parameter);                }            }        }        return Cmd;    }