Click here to Skip to main content
12,405,700 members (71,159 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 asp.net 4.0 with c#
Posted 9-May-13 20:25pm
Rate this: bad
 
good
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..
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 10 May 2013
Copyright © CodeProject, 1999-2016
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