public override ProductPropertyCollection GetProductPropertySet(string sql, int pageIndex, int pageSize, bool includePageIndex, bool returnFullThread)
        {
            using (SqlConnection myConnection = new SqlConnection(this.connectionString))
            {
                using (SqlCommand command = new SqlCommand("dbo.[RS_Get_ProductPropertySet]", myConnection))
                {
                     = CommandType.StoredProcedure;

                    command.Parameters.Add("@PageIndex", SqlDbType.Int, 4).Value = pageIndex;
                    command.Parameters.Add("@PageSize", SqlDbType.Int, 4).Value = pageSize;
                    command.Parameters.Add("@sqlPopulate", SqlDbType.NText).Value = sql;
                    command.Parameters.Add("@IncludePageIndex", SqlDbType.Bit).Value = includePageIndex;
                    command.Parameters.Add("@ReturnFullThread", SqlDbType.Bit).Value = returnFullThread;
                    command.Parameters.Add("@TotalRecords", SqlDbType.Int).Direction = ParameterDirection.Output;

                    ProductPropertyCollection productpropertySet = new ProductPropertyCollection();

                    // Execute the command
                    myConnection.Open();
                    using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
                    {
                        while (dr.Read())
                        {
                            productpropertySet.Add(PopulateProductPropertyEntryFromIDataReader(dr));
                        }

                        if (includePageIndex)
                        {
                            dr.NextResult();
                            while (dr.Read())
                                productpropertySet.PageIndex.Add(dr[0], dr[1]);
                        }

                        dr.Close();
                        myConnection.Close();
                        productpropertySet.TotalRecords = (int)command.Parameters["@TotalRecords"].Value;
                    }

                    return productpropertySet;
                }
            }
        }


SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))

CommandBehavior.CloseConnection  这个找不到哪里定义的? 高手帮忙解答下了? 谢谢!

这段代码是在调用一个SQL Server的存储过程，这个存储过程是用来读取数据库中的数据进行分页的，用存储过程来看估计数据库中存有的数据很多这时就得需要使用存储过程来读取了，CommandBehavior.CloseConnection 这个不用解释了吧？刚才说过了静态类成员是不需要实例化(也就是定义)的。
而且楼主的基础知识都没学过吗？

谢谢 我半路出家， 没有那么专。 工作要看多点。

CommandBehavior.CloseConnection是在关闭Connection的时候也关闭SqlDataReader吧