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