This tutorial will show you how to use LINQ in conjunction with the ObjectDataSource to enable you to sort the data in a descending format. C# version.
Server Intellect offers Windows Hosting Dedicated Servers at affordable prices. I'm very pleased!
Looking for the VB.NET version? Click here!
Looking for more .NET Database Tutorials? Click Here!
In this tutorial, we will be looking at how we can use LINQ to SQL Classes in conjunction with the ObjectDataSource control. We will be using a SQL database, and then representing that with a LINQ to SQL class. We will then build our own class that will use the LINQ to SQL class to interact with our database. We can then reference the method we build by our ObjectDataSource.
Although it may seem like a long process, Visual Studio.NET actually does most of the work for us.
We will start out by creating a database - or if you have your own, you can use that. For this example, we will be using a SQL database with one table, and three columns - id, name, city.
Once we have our database set up and have added some sample data to it, we can create our LINQ to SQL class. Right-click our project in Solution Explorer and choose Add New Item, LINQ to SQL Classes. In this example, we named it People.dbml
This creates a class to represent our database. Make sure you save it after draggin on the table we will be using.
Now, to add our own class, Right-click the project in Solution Explorer, Add New Item, Class. We want it in the App_Code folder. In this class, we will write a method to select the data from the database, order it, and then return. Our method will look something like this:
public static IEnumerable<tblPeople> Select()
{
PeopleDataContext dBase = new PeopleDataContext();
return dBase.tblPeoples.OrderBy(p=>p.name); } |
Here, we use LINQ to first instantiate our LINQ to SQL class, and then return an ordered collection of data.
The entire class looks like this:
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Data.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Collections.Generic;
public class People
{
public static IEnumerable<tblPeople> Select() {
PeopleDataContext dBase = new PeopleDataContext();
return dBase.tblPeoples.OrderBy(p=>p.name); } |
Need help with Windows Dedicated Hosting? Try Server Intellect. I'm a happy customer!
A snippet from our LINQ to SQL class (which is generated by VS), which represents our database table follows:
public tblPeople()
{
OnCreated(); }
[Column(Storage="_id", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int id
{
get {
return this._id; } set {
if ((this._id != value)) {
this.OnidChanging(value);
this.SendPropertyChanging();
this._id = value;
this.SendPropertyChanged("id");
this.OnidChanged(); } }
[Column(Storage="_name", DbType="VarChar(50)")]
public string name
{
get {
return this._name; } set {
if ((this._name != value)) {
this.OnnameChanging(value);
this.SendPropertyChanging();
this._name = value;
this.SendPropertyChanged("name");
this.OnnameChanged(); } }
[Column(Storage="_city", DbType="VarChar(50)")]
public string city
{
get {
return this._city; } set {
if ((this._city != value)) {
this.OncityChanging(value);
this.SendPropertyChanging();
this._city = value;
this.SendPropertyChanged("city");
this.OncityChanged(); } } |
We can then simply implement this into our web application using a GridView and an ObjectDataSource control. The DataSource will use the Select Method we just created, when we specify its SelectMethod. The TypeName refers to the class we created. The ASPX page will look something like this:
<form id="form1" runat="server">
Alphabetically Ordered By Name using LINQ and ObjectDataSource:<br /> <asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1"
Width="408px" /> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="People" SelectMethod="Select" /> |
I just signed up at Server Intellect and couldn't be more pleased with my Windows Server! Check it out and see for yourself.
Looking for the VB.NET version? Click here!
Looking for more .NET Database Tutorials? Click Here!
|