Click here to Skip to main content
11,921,316 members (60,925 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server , +
I have three table from which i need to fetch data and bind in gridview with custom pagging my table schema like tblStudent (id identity(1,1) pk,name nvachar(100) mobileNo char(10)) second is tblMessage (id identity(1,1) pk, message nvarchar(1000)), third tblMsgHistory (id identity(1,1) pk, stuId int references tblStudent(id),msgId int references tblMessage (id), msgdate smalldatetime, deleverysatatus bool)

i want to fetch data these three table using join with my @pageindex and @pagesize condition

please tell me how i can implement my procedure

i am using sqlserver 2008 and 4.0 with c#
Posted 9-May-13 21:25pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

To make query to fetch data from Multiple table you have to use Join like Inner Join.

Steps for Create Joins-

Right Click on your database and click on Query .
Your database all tables will show on pop-up.
Select your Table which you want to fetch data. and
Drag and Drop All Tables Primary Keys and Check Fields name which your want.
Automatic Joins will Create the below and execute than..and use it.
All the best..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 583
1 Dave Kreskowiak 245
2 phil.o 160
3 KrunalRohit 134
4 F-ES Sitecore 130
0 OriginalGriff 6,951
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,171
3 George Jonsson 2,840
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web04 | 2.8.151120.1 | Last Updated 10 May 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100