grazie mille
html
Code behind
DsDati = new DataSet();
OleDbCommand myCommandEC = new OleDbCommand("SP_1", myConnection);
myCommandEC.CommandType=CommandType.StoredProcedure;
OleDbDataAdapter DataAdapt = new OleDbDataAdapter(myCommandEC);
OleDbCommand myCommandEC2 = new OleDbCommand("SP_2", myConnection);
myCommandEC2.CommandType=CommandType.StoredProcedure;
OleDbDataAdapter DataAdapt2 = new OleDbDataAdapter(myCommandEC);
DataAdapt.Fill(DsDati, "tabella1");
DataAdapt2.Fill(DsDati, "tabella2");
DataColumn Parent;
DataColumn Child;
DataRelation CustomerRelation;
Parent = DsDati.Tables["tabella1"].Columns["IntestazioneAttivitaProgetto"];
Child = DsDati.Tables["tabella2"].Columns["ID"];
CustomerRelation = new DataRelation("CustomerRelation", Parent, Child, false);
DsDati.Relations.Add(CustomerRelation);
DataGrid1.DataSource = DsDati.Tables["tabella1"].DefaultView;
DataGrid1.DataBind();
myConnection.Close();