How to join to data table column wise.

0.00/5 (No votes)

See more:

Hello. I am trying to combine two data table into a single data table.
My first data table consist of

USN    |Name    |Father Name   
001     abc      ABC
001     abc      ABC

My second data table consist of

CC     |Sem  |Marks
Sub01   3     78
Sub02   3     56

Now, I want to combine those tables into one. So my result will look like as follows

USN    |Name    |Father Name   |CC     |Sem  |Marks
001     abc      ABC            Sub01   3     78
001     abc      ABC            Sub02   3     56

Please help. Thank you

Posted 26-Apr-15 1:43am

partha143

Updated 26-Apr-15 3:57am

Maciej Los

Add a Solution

Comments

[no name] 26-Apr-15 8:47am

What you have tried so far?

partha143 26-Apr-15 8:50am

Sascha Lefèvre 26-Apr-15 9:49am

Usually you do a join on a column with a common value. In your case there doesn't seem to be such a column. Do you want to join row1 to row1, row2 to row2 etc ?

partha143 26-Apr-15 10:06am

I am developing a result sheet for my college, where student is asked to enter their reg num(USN) and it has to pull out the result for that reg num. So I am fetching USN,Name and Father Name into one datatable and CC,Sem and Marks into second datatable and joining those data as I have stated in my main question and lastly displaying the content of the final data in a gridview.

Sascha Lefèvre 26-Apr-15 10:08am

Alright, but that doesn't really answer my question :)
Could you fetch the USN also from the second table?

Maciej Los 26-Apr-15 9:58am

Based on what condition?

partha143 26-Apr-15 10:06am

Based on the USN entered by the students

Maciej Los 26-Apr-15 10:11am

I do not see USN in second table ;(

Sinisa Hajnal 27-Apr-15 3:00am

If you don't have USN in the second table, there is no way to uniquely combine the rows...if you just want to add them, try using CROSS APPLY (for SQL Server) - not sure about other databases...

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

Last 24hrs

This month

Rick York	90
OriginalGriff	60
Pete O'Hanlon	40
Test Mail May2023	20
Dave Kreskowiak	10

Pete O'Hanlon	1,860
OriginalGriff	1,395
Graeme_Grant	895
Richard Deeming	808
Dave Kreskowiak	694

How to join to data table column wise.

Add your solution here

Preview 0

How to join to data table column wise.

Add your solution here

Preview 0

Existing Members

...or Join us