如何在网站建设（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;
    }