static string  sConnectionString  = "workstation id=ws;packet size=4096;integrated security=SSPI;data source=serv;persist security info=False;initial catalog=base";
public SqlConnection cnNorthwind = new SqlConnection(sConnectionString);
public DataSet dsProducts = new DataSet();
public DataSet details = new DataSet();
public ArrayList history = new ArrayList();
public int curlevel;
public DataGridTableStyle tableStyle = new DataGridTableStyle(false);
public string top;
public string papa;
private void Form1_Load(object sender, System.EventArgs e)
{			
             curlevel =  0 ;
	history.Add("root");
	string s;
	s = "c:/111.xml";
	System.IO.FileInfo  FileInf = new System.IO.FileInfo(s);
	if (FileInf.Exists)
	{
	dsProducts.ReadXml(s);
	dataGrid1.DataSource = dsProducts;
	dataGrid1.DataMember = "root";
	}   
	else
	{   
	SqlCommand cmdProducts = new SqlCommand("tree_getChilds", cnNorthwind);
	cmdProducts.CommandType = CommandType.StoredProcedure;
	SqlDataAdapter daGetProducts = new SqlDataAdapter(cmdProducts);
	daGetProducts.Fill(dsProducts, "root");
	dataGrid1.DataSource = dsProducts;
	dataGrid1.DataMember = "root";				
            }
}

private void dataGrid1_Click(object sender, System.EventArgs e)
{		
  id = dsProducts.Tables[history[curlevel].ToString()].Rows[dataGrid1.CurrentCell.RowNumber]["id"].ToString();
  Guid g = new Guid(id);
  SqlCommand det = new SqlCommand("Tree_getChildAllSetAttributes", cnNorthwind);
  det.CommandType = CommandType.StoredProcedure;
  SqlParameter prmCustomerID = new SqlParameter();
  prmCustomerID.ParameterName = "@id";
  prmCustomerID.SqlDbType = SqlDbType.UniqueIdentifier;
  prmCustomerID.Value = g;
  det.Parameters.Add(prmCustomerID);
  SqlDataAdapter daGetDetails = new SqlDataAdapter(det);
  details.Clear();
//==============TORMOZ ON==================
  daGetDetails.Fill(details,"details");
//==============TORMOZ OFF=================
  dataGrid2.DataSource = details;
  dataGrid2.DataMember = "details";
}

procedure TForm1.FormCreate(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.sql.add('tree_getChilds');
  ADOQuery1.open;
end;

procedure TForm1.DBGrid1CellClick(Column: TColumn);
var 
  id,str:string;
begin
  id:=ADOQuery1.fieldbyname('id').asstring;
  ADOQuery2.Close;
  ADOQuery2.SQL.Clear;
  str:='Tree_getChildAllSetAttributes '+# 39 +id+# 39 ;
  ADOQuery2.sql.add(str);
  ADOQuery2.open;
end;

daGetDetails.MissingSchemaAction = MissingSchemaAction.Error;  // add this line

daGetDetails.MissingSchemaAction = MissingSchemaAction.Error;  // add this line