Display data from two tables into one gridview through datasource

baijuep

SOLVED CLOSED ACTIVE ANSWERED
User: baijuep
Posted: on Feb 20, 2013 10:03 AM
Forum: Data Controls
Replies: 7
Views: 5602

i have a problem in joining two tables the reason is my first table persdata is having common field as pno (a single row in a particular person) and the second tables is also having pno(having muti entry for a person as this table is of qualification and a person may have more than 3 qualifications and their grading) sample persdata(table) pno name coy appt sample qual(table) pno qual grading recommendation i tried my best to do it and not able to proceed i want the output in a single row as in persdata to a gridview with all the qual combined in one coloumn and all the recommendations combined in one coloumn for a person. i am requesting for you help on this

Download FREE API for Word, Excel and PDF in ASP.Net

baijuep

0 2

Reply
User: baijuep
Replied: on Feb 20, 2013 06:33 PM
Report

Sample Persdata Table

pno name coy appt

136a ak singh it1 sys admin

142k ravi k it2 sys admin

144h ss nair it1 asst sys admin

132P Hussain k it3 mech engr sample qual(table) pno qual grading recommendation

136a ccna A KKLE

142k ddcn B

144h ccna A KKCT

132p btech(mech) D KKME

136A DDCN A

142K CCNA B KKCT

144H BTECH(CS) A

132P BASIC AUTO A

THE PERSDATA IS HAVING A PERSONS NUMBER ONE TIME AND IN QUAL TABLE ONE PERSON HAS MORE THAN TWO ROWS because he had done more then one course

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display data from two tables into one gridview through datasource

Company

Explore

Follow us

Contact Us