Tuesday, May 31, 2011

Linq - fetch data from database using linkq

create database "Eventmanagement" in SQL server.
Add table tblUser with fields "username","password","userid"
Add "Linq to SQL class" named "Eventmanagement"
Add table "tbluser" from database "Eventmanagement" to the layout in dbml file created
under app_code folder.
Add a GridView in default page.

Paste the following code in Page Load event


EventmanagementDataContext db = new EventmanagementDataContext();
var v = from user in db.tblUsers select new {user.username, user.password, user.userid};
GridView1.DataSource = v;
GridView1.DataBind();

No comments:

Post a Comment