HOW TO BIND TWO TABLES IN SINGLE GRIDVIEW

Posted by Oswaldlily under ASP.NET on 6/4/2012 | Points: 10 | Views : 4158 | Status : [Member] | Replies : 2
I HAVE GRIDIVIEW COLUMNS WHICH USED TWO TABLES TO DISPLAY IN GRIDVIEW USING TEMPLATE FIELD

tABLE1 HAS DIRECT QUERY

GV1.DATASOURCE=from r in DC.oRDER_daTA_tABLE where _pNo.Contains(r._DOC_No) & _InputToQuery.Contains(r._Order_No) & (r._InvoiceStatus != 'R') select r);
GV1.DATABIND();

TO CALL TABLE2(tABLE2 IS PRESENT IN sp),FOR BINDING IN SAME GRIDVIEW
hOW TO CALL tABLE2 FOR SAME GRIDVIEW???

ONLY IF BOTH ON SAME SP I CAN BIND USING TEMPLATE FIELD...




Responses

Posted by: Gow.Net on: 6/4/2012 [Member] Starter | Points: 25

Up
0
Down
using join query it possible

gowthaman8870226416

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: perfectchourasia-9163 on: 6/8/2012 [Member] Starter | Points: 25

Up
0
Down
the best way to use Join query

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response