如何绑定多个关联的数据表?
刚入门学C#和ASP.Net,跟朋友借代码来参考,实现了绑定DataGrid和数据库,代码如下
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= C:\Downloaded\Uq\Yr3\INFS3204\Project\projectdb.mdb";
conn.Open();
string mySelectQuery = "Select * from Course";
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(mySelectQuery,conn);
DataSet ds = new DataSet();
adapter.Fill(ds,"Course");
conn.Close();
dt = ds.Tables["Course"];
view = new DataView(dt);
if (!IsPostBack)
{
DataGrid1.DataSource = view;
DataGrid1.DataBind();
}
但是如果我的select语句变成从2个或2个以上关联数据表中读取数据,adapter.Fill(ds,"Course")这句就不知道如何修改了。这段代码似乎只能适用于绑定某一个数据表。哪个朋友能指教?