how to insert the records of two tabels in one table

Question

0.00/5 (No votes)

See more:

HI
i want to insert record of two tabels in one tabel by inserting querry using asp.net with c# but records are not inserting my code is that

C#

SqlConnection sq = new SqlConnection(connectionString);
                SqlCommand cm;
                sq.Open();
                cm = new SqlCommand("INSERT INTO Result(Semester,TotalMarks,MarksTheory,MarksLab,GPA,Status)(Select student_id,FullName,FatherName,Class,Program FROM Student)) Values('" + Nametxt.Text + "','" + Fathertxt.Text + "','" + DropDownclass.SelectedValue + "','" + DropDownSmster.SelectedValue + "','" + TotalMarkstxt.Text + "','" + Markstheorytxt.Text + "','" + Markslabtxt.Text + "','" + GPAtxt.Text + "','" + DropDownStatus.SelectedValue + "','" + DropDownProgram.SelectedValue + "')", sq);
                cm.ExecuteNonQuery();
                sq.Close();

Posted 17-May-13 16:22pm

Tahir Mahmood From karachi

Updated 17-May-13 16:33pm

NotPolitcallyCorrect

v2

Add a Solution

Comments

[no name] 17-May-13 22:38pm

Would be a lot easier to read if you used parameterized queries instead of trying to create an SQL injection attack.

Sergey Alexandrovich Kryukov 17-May-13 23:04pm

Aha, now I know: Karachi is in U.S.A. :-)
—SA

Qadri Jillani 18-May-13 0:44am

aoa ! brother tahir is the structure of all the three tables same or not?

1 solution

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)

Qadri Jillani · Answer 1 · 2013-05-17T18:52:00

1.if the structure of your tables is same and you want to insert every record from both tables than you can use this :

SQL

INSERT INTO table1 (col1,col2,col3,.....,coln) 
     SELECT * FROM table2, table3

2.if you want to insert specific records based on some condition than you can use this:

SQL

INSERT INTO table1 (col1,col2,col3,.....,coln) 
     SELECT * FROM table2, table3 where table2.colname=table3.colname

you can use your own condition in "where" clause