Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
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..
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


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

  Print Answers RSS
0 Maciej Los 580
1 OriginalGriff 420
2 Sascha Lefévre 289
3 Abhinav S 220
4 CHill60 200
0 Sergey Alexandrovich Kryukov 9,773
1 OriginalGriff 9,290
2 Peter Leow 5,137
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 3,036

Advertise | Privacy | Mobile
Web01 | 2.8.150327.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