make two tables as one table

Question

0.00/5 (No votes)

See more:

I want to ask you if you can help me

I have a web application by using visiual studio 2010( asp.net tech. written by c#)

There are two tables FirstTable (Id-Name) ,SecondTable (NameOfCourses-NumOfCourse)

in a data base there is no relation between these tables and no option to change the structer of these tables.

The problem I want to solve it:
I have gridview for the fisrt table and when I clicked on the name of student I want to navigate me to other page have the (Id-Name-NameOfCourses-NumOfCourse)

How can I merge beteween these unrelated tables to make one table.

Thank you for your help

Posted 8-Apr-11 21:16pm

dedoooo

Add a Solution

Comments

OriginalGriff 9-Apr-11 3:18am

Sorry?
If there is no relation between them, how do you expect to construct a single table out of the two?
Can you construct a single table out of a train timetable and your bank statement?

dedoooo 9-Apr-11 3:43am

In SQL statment
I expected there is a possible way to make the Id as colum in second table but I don't know how make it?

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Answer 1 · 2011-04-08T21:28:00

Your question isn't very clear, perhaps an example would help. As OriginalGriff stated, if there's no relation between the tables, you cannot 'navigate' in the data.

However if you want to create all combinations of students and courses, you could create a cartesian product between them. For example:

var all = from student in FirstTable.AsEnumerable()
          from course in SecondTable.AsEnumerable()
          select {
             student.Id,
             student.Name,
             course.NameOfCourse,
             course.NumOfCourse
          }

This should contain all the combinations and you can put the results into a new datatable.

Prasanta_Prince · Answer 2 · 2011-04-14T23:52:00

Solution 2

You can use cross join linke,-

SELECT     FirstTable.ID, FirstTable.Name,SecondTable.NameOfCourses,SecondTable.NumOfCourse 
FROM         FirstTable CROSS JOIN
                      SecondTable

Posted 14-Apr-11 23:52pm

Prasanta_Prince

Jeffrey Enzo · Answer 3 · 2011-04-14T23:54:00

Solution 3

You must create an SQL view in the Management studio. Their you can combine tables: http://msdn.microsoft.com/en-us/library/ms187956.aspx[^]

Posted 14-Apr-11 23:54pm

Jeffrey Enzo

sravanirn · Answer 4 · 2011-04-15T00:01:00

You can make use of the student id which is in the first table....you have another colomn in the second table where student id is the foreign key...when the id is selected then correspondingly pass a query which the gets the value from the second table based on the student id...

if you want values from both the first and second table, write a query with inner join...

make two tables as one table

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0