DataColumn dc1 = ds.Tables["t1"].Columns["ID"];
DataColumn dc2 = ds.Tables["t2"].Columns["ID"];
DataRelation drel = new DataRelation("t", dc1, dc2);
ds.Relations.Add(drel);
dlist.DataSource=ds.Tables["t1"];
dlist.DataBind();
DataColumn dc2 = ds.Tables["t2"].Columns["ID"];
DataRelation drel = new DataRelation("t", dc1, dc2);
ds.Relations.Add(drel);
dlist.DataSource=ds.Tables["t1"];
dlist.DataBind();
Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM [board] INNER JOIN [class] ON [board].class = [class].id WHERE [board].boardID="& boardID &"", MyConnection)調用時,就用<%#Container.DataItem("name")%>就可以了.
如果没有关系,则存成2个table,然后梆定