update the tables sql,asp.net c#

Hello Friend,
               If you are using sql server as your database you can simply make use of join query and start copying the data into your t3 table. following would be the query for the same.

Assume that your t1 contains columns as (Id,Name,Address)

Assume that your t2 contains column as (Id,DeptId,DeptName)

Assume that your t3 contains column as (Id,Name,DeptName)

and now i want to copy id,name and deptname in t3 from t1 and t2 respectively.

insert into t3(Id,Name,DeptName)
select m1.Id,m1.Name,m2.DeptName
from t1 as m1 join t2 as m2
on m1.Id==m2.Id


And finally for displaying the records from t3 on gridview. Following code you can make use of

SqlConnection con=new SqlConnection("ConnectionString here");
SqlDataAdapter da=new SqlDataAdapter("Select * from t3",con);
DataSet ds=new DataSet();
da.Fill(ds);
if(ds.Tables[0].Rows.Count>0)
      gridview1.DataSource=ds.Tables[0].DefaultView;
else
        gridview1.EmptyDataText="No Records Found";
gridview1.DataBind();

Hope that helps you.

With Regards,
Vishal Gilbile.