table copy asp.net sql c#

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hi, i have two table t1,t2 and one target table t3

t1 have 3 columns
t2 have 3 columns (different columns)

i inserted t1,t2 tables and stored successfully
now i want to copy(column values) the all t1,t2 values in t3 table based on (t1.id=t2.id )

if t1,t2 updated means t3 automatically update this is possible.
and next i want to fetch all t3 column values in a gridview
plz help

Posted 27-Mar-13 20:41pm

sreeprakash248

Updated 28-Mar-13 2:37am

v2

Add a Solution

2 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)

*Karthik Harve* · Answer 1 · 2013-03-27T21:19:00

Solution 2

Hi,

Try like below.

SQL

IF NOT EXISTS(SELECT OBJECT_ID('t3'))
BEGIN
    SELECT * INTO t3 from 
    (SELECT A.col1, A.col2, A.col3, A.id, B.t2Col1, B.t2Col2 
    FROM t1 A INNER join t2 B ON A.id = B.id) temp
END

select * from t3

This will create new table t3, with the columns from t1 & t2

hope it helps.

Posted 27-Mar-13 21:19pm

Karthik Harve

Comments

sreeprakash248 28-Mar-13 8:22am

where i place this query stored procedure!!! and when t1,t2 updated means t3 default update that information.... thanks

Member 8372011 · Answer 2 · 2013-03-27T21:46:00

Hi,

I think you have to do this stuff from Back-End,

execute below code in SqlServer Might helps you...

Insert Into T3
Select T1.*,T2.* from T1
Inner Join T2 on T1.Id = T2.Id
Where T1.Id is not Null or T2.Id is Not Null
And T1.ID Not In
(
Select (Name if T1.Id) From T3
)
And T2.ID not In
(
Select (Name if T2.Id) From T3
)

after that fire "select * from T3" and get result back and Bind to Grid.