Click here to Skip to main content
11,717,509 members (81,068 online)
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 20: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 Sergey Alexandrovich Kryukov 689
1 OriginalGriff 255
2 F-ES Sitecore 210
3 Jochen Arndt 120
4 Maciej Los 120
0 Sergey Alexandrovich Kryukov 1,144
1 Maciej Los 509
2 OriginalGriff 505
3 Richard MacCutchan 440
4 CHill60 415

Advertise | Privacy | Mobile
Web02 | 2.8.150901.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