c# - 自定义网格 LINQ to SQL

Question

下面是我自定义的控件网格:

public partial class LinqGrid : UserControl
{
        object tmpDataTable = new object();
        public LinqGrid()
        {
            InitializeComponent();
        }
        public void Bind<T>(System.Data.Linq.Table<T> listSource) where T : class
        {          
            Project.dbClassesDataContext dbc = new Project.dbClassesDataContext();
            tmpDataTable = listSource;
            var query = (from c in listSource select c);
            dgvRecords.DataSource = query.Take(10).ToList();
        }
        private void btnNext_Click(object sender, EventArgs e)
        {
// now what do I have to do here if I want next 10 records? I mean how to retrieve tmpDataTable object here? I can't find the type of variable.
        }
}

Answer 1

如下定义你的类:

public partial class LinqGrid<T> : UserControl where T : class, new()
{
        System.Data.Linq.Table<T> tmpDataTable;
        public LinqGrid()
        {
            InitializeComponent();
        }
        public void Bind(System.Data.Linq.Table<T> listSource)
        {          
            Project.dbClassesDataContext dbc = new Project.dbClassesDataContext();
            tmpDataTable = listSource;
            var query = (from c in listSource select c);
            dgvRecords.DataSource = query.Take(10).ToList();
        }
        private void btnNext_Click(object sender, EventArgs e)
        {
            tmpDataTable.Skip(10).Take(10); ....
        }
   }