求助:DataGrid 绑定多表时出错
我的DataSet有两个表,两个表之间有一个关系,现在我要同datagrid绑定,提示报错:"ID 为“DataGrid1”的 DataGrid 未能从选定数据源自动生成任何列。"
代码如下:
private void Button1_Click(object sender, System.EventArgs e)
{
string commadText,commandText2 ;
commadText = "select * from t1";
commandText2 = "select * from t1_1";
OleDbConnection cnn = new OleDbConnection(“连接串”);
OleDbDataAdapter da1 = new OleDbDataAdapter(commadText,cnn);
OleDbDataAdapter da2 = new OleDbDataAdapter(commandText2,cnn);
DataSet ds = new DataSet();
da1.Fill(ds,"t1");
da2.Fill(ds,"t1_1");
DataRelation datarelation ;
DataColumn datac1 ;
DataColumn datac2 ;
datac1 = ds.Tables["t1"].Columns["tid"];
datac2 = ds.Tables["t1_1"].Columns["tid"];
datarelation = new DataRelation("orderRelation",datac1,datac2);
ds.Relations.Add(datarelation);
DataViewManager dvm = ds.DefaultViewManager ;
DataGrid1.DataSource = dvm;
DataGrid1.DataMember = "t1";
DataGrid1.DataBind();
}
请帮我看看错在什么地方