update the tables sql,asp.net c#

Question

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 )

and next i want to fetch all  t3 column values in a gridview
 plz help

Answer 1

For 'Real World' applications - most of the value of the system arises from the mid-tier (with the business layer). This is where the business logic which provides the requirement solutions resides. My suggestion would be to obtain as much experience with this tier - a recommended book is Lhotka's Business Objects (this is NOT the 'Business Objects Enterprise/Crystal Reports' from SAP which sucks). Lhotka's approach is very unique and is well documented  - more details here: http://www.lhotka.net/

Post your experiences here..
Good Luck!

SBC
Microsoft MVP - Groove:Architecture