How to insert Datatable value in to multiple tables

See more:

C#

Hi All i want to insert one ID in to 2 table
my code are as below

DataTable dt = new DataTable();
                   dt = FnTableIDInsert();
                       SqlConnection connn = new SqlConnection(ConnectionString);
                       connn.Open();
                       string sqlselect = "INSERT INTO tbl_clientcolumnnames(tableid) values('tableid')";
                       SqlCommand cmdselect = new SqlCommand(sqlselect, connn);
                       cmdselect.ExecuteNonQuery();
                       string sqlselect2 = "INSERT INTO tbl_Intellectcolumnnames(tableid) values('tableid')";
                       SqlCommand cmdselect2 = new SqlCommand(sqlselect2, connn);
                       cmdselect2.ExecuteNonQuery();

pls help me wt change i do in my code for insert data into multiple tables

EDIT (Moved from answer)

---

DataTable dt = new DataTable();
                    dt = FnTableIDInsert();
                    foreach (DataRow dr in dt.Rows)
                    {
                        string value = dr["tableid"].ToString();
                        SqlConnection connn = new SqlConnection(ConnectionString);
                        connn.Open();
                        string sqlselect = "INSERT INTO tbl_clientcolumnnames(tableid) values("+value+")";
                        SqlCommand cmdselect = new SqlCommand(sqlselect, connn);
                        cmdselect.ExecuteNonQuery();
                        string sqlselect2 = "INSERT INTO tbl_Intellectcolumnnames(tableid) values(" + value + ")";
                        SqlCommand cmdselect2 = new SqlCommand(sqlselect2, connn);
                        cmdselect2.ExecuteNonQuery();

                    }

i Have done change in code know every thing is okey but bata come like below format

columnintellectid	tableid	ScriptId	ColumnnameInt
8	NULL	8	Name
9	5	NULL	NULL
10	NULL	9	Name
11	6	NULL	NULL

But i want

columnintellectid   tableid ScriptId    ColumnnameInt
8   5    8   Name     
9   6    9   Name 

pls reply if some know