Insert and Retrive Records form multiple tables

See more:

SQL-Server

SQL-Server-2008

Hi All,

I have a requirement, One parent table and three depended(child) tables. When i click on save button i need to insert those records into the respective tables as shown below, and bind those records to the Gridview. Bellow is the table structure

Table
Id,Name,Desc
Tablech1
id,fkid (parent),name
Tablech2
id,fkid (parent),name
Tablech3
id,fkid (parent),name

Insertion Data:
Table(parent)
1,Name, NameDesc

TableCh1
1,1,Name
2,1,Name1
3,1,name2

Table Ch2
1,1,Name
2,2,Name1
3,3,Name2

Table Ch3
1,1,name
2,1,name1
3,1,name2

i need records like as shown below
1,t1.name,tch1.name,tch2.name,tch3.name
---------------------------------------
1, name,name,name,name
2,name,name1,name1,name1
3,name,name2,name2,name2

how can i insert those records into the table and get those records
Please suggest me. Thanks in advance...