parentrow

[little83]

Dear all

My question is mixed between c# and sql so I would perfere to ask here

I want to insert data in sql database but by using C# language...and I two table with relationship between them...the first one has a parent row of the sec. one and the vice versa..the sec. one has childrow of the first one

to insert the data by these philosopy I used dataset..then I update the data in the sql server....

like


DataRow floorsrow = floors.NewRow();
for (int i = 0; i < Buliding.Rows.Count; i++)
{

if (thedata.Tables["Buliding"].Rows[i]["Buliding"].ToString() == comboBox1.SelectedItem.ToString())
{
string x = string.Format("{0}-{1}", comboBox1.SelectedItem.ToString(), fl.ToString());
x = x.Replace(" ", "");
floorsrow["Floor"] = x.ToString();
floorsrow.SetParentRow(thedata.Tables["Buliding"].Rows[i]);
floors.Rows.Add(floorsrow);

}

}

bulidingadapter.Update(thedata, "Buliding");

so the question how could l inset this data with this relation directly to the database without using dataset

thanks