Custom Paging in GridView Using LINQ

added by hunterz_85
2/15/2010 10:36:53 AM


LINQ to SQL is another capability which we can use to manage the relational database object as .net object. We can query, insert, update and delete the underlying database object with these classes. When we query/update/delete these .net object, LINQ to SQL will automatically take care of the underlying relational data objects operations. In short, LINQ to SQL provides an Object-Relational Mapping (O/R Mapping) which maps objects of different type system. In our case, it is relational to object oriented type system. With these information’s, we will move to our subject matter with these introductions. To understand the custom paging implementation, we will bind the GridView with employee data. The sample will contain 2 tables, Employee and Department in APP_Data folder. We will bind the GridView with the data fetched from the database using LINQ to SQL classes.