绑定列表的两种方法（很简单，只是比较一下，分一下情况而已）

        /// <summary>
        /// 绑定列表
        /// </summary>
        private void BindMonthData()
        {
            string sqlSelect = string.Format(@"SELECT * FROM BMIS_ProjectBudgetMonthDetail WHERE BudgetProjectExecuteEntityID='{0}'
                                 AND [Year]= {1} ORDER BY WhichMonth", ExeId, ddlYear.SelectedValue);

            using (DataTable dt = PortalDB.ExecuteDataSet(CommandType.Text, sqlSelect).Tables[0])
            {
                //方法1：这种方法就是把所有的内容都加载出来
                gvMonthDetail.UseDefaultDataSource = true;
                gvMonthDetail.DataSource = dt;
                gvMonthDetail.PagingData();

                //方法2：在表的内容很多的时候，这种方法可能有些麻烦，但是在分页的时候这种方法的使用更加的准确？
                //gvMonthDetail.TableNames = "BMIS_ProjectBudgetMonthDetail";//表名
                //gvMonthDetail.ColumnNames = "*";//列名
                //gvMonthDetail.OrderColumn = "WhichMonth";//需要排序的名
                //gvMonthDetail.SqlWhere = "BudgetProjectExecuteEntityID='{0}' AND [Year]= {1}";//where语句的内容
                //gvMonthDetail.PagingData();
            }