ecco
codice:
private void fillGrid()
{
try
{
string currentPath = Environment.CurrentDirectory;
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
currentPath+ @"\Northwind.mdb";
string clienti = "SELECT * FROM Clienti";
string ordini = "SELECT * FROM Ordini";
string prodotti = "SELECT * FROM Prodotti";
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(clienti,conn);
da.Fill(ds,"Clienti");
da = new System.Data.OleDb.OleDbDataAdapter(ordini,conn);
da.Fill(ds,"Ordini");
da = new System.Data.OleDb.OleDbDataAdapter(prodotti,conn);
da.Fill(ds,"Prodotti");
DataColumn dc1 = ds.Tables["Clienti"].Columns["IDCliente"];
DataColumn dc2 = ds.Tables["Ordini"].Columns["IDCliente"];
ds.Relations.Add("Dettaglio Prodotti",dc1,dc2);
dg.SetDataBinding(ds,"Clienti");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}