我将两个表放到一个DataSet中,可是还是无法显示,代码如下:
SqlConnection con1=new SqlConnection("server=windforce;uid=test;pwd=test;database=brs");
string sql1 = "select * from InterviewsInfoTab";
SqlDataAdapter da1 = new SqlDataAdapter(sql1,con1);
SqlConnection con2=new SqlConnection("server=windforce;uid=test;pwd=test;database=brs");
string sql2 = "select * from ResumeInfoTab";
SqlDataAdapter da2 = new SqlDataAdapter(sql2,con2); DataSet ds = new DataSet();
da1.Fill(ds,"InterviewsInfoTab");
da2.Fill(ds,"ResumeInfoTab"); System.Data.DataRelation dr;
System.Data.DataColumn dc1;
System.Data.DataColumn dc2;
dc1 = ds.Tables["InterviewsInfoTab"].Columns["ResumeID"];
dc2 = ds.Tables["ResumeInfoTab"].Columns["ResumeID"];
dr = new System.Data.DataRelation("InterviewsInfoTab2ResumeInfoTab", dc1, dc2);
ds.Relations.Add(dr);
DataGrid1.DataSource = ds.Tables["InterviewsInfoTab"];
DataGrid1.DataSource = ds.Tables["ResumeInfoTab"];
DataGrid1.DataBind();
SqlConnection con1=new SqlConnection("server=windforce;uid=test;pwd=test;database=brs");
string sql1 = "select * from InterviewsInfoTab";
SqlDataAdapter da1 = new SqlDataAdapter(sql1,con1);
SqlConnection con2=new SqlConnection("server=windforce;uid=test;pwd=test;database=brs");
string sql2 = "select * from ResumeInfoTab";
SqlDataAdapter da2 = new SqlDataAdapter(sql2,con2); DataSet ds = new DataSet();
da1.Fill(ds,"InterviewsInfoTab");
da2.Fill(ds,"ResumeInfoTab"); System.Data.DataRelation dr;
System.Data.DataColumn dc1;
System.Data.DataColumn dc2;
dc1 = ds.Tables["InterviewsInfoTab"].Columns["ResumeID"];
dc2 = ds.Tables["ResumeInfoTab"].Columns["ResumeID"];
dr = new System.Data.DataRelation("InterviewsInfoTab2ResumeInfoTab", dc1, dc2);
ds.Relations.Add(dr);
DataGrid1.DataSource = ds.Tables["InterviewsInfoTab"];
DataGrid1.DataSource = ds.Tables["ResumeInfoTab"];
DataGrid1.DataBind();
lz可以在csdn搜索下
SqlDataAdapter da1 = new SqlDataAdapter(sql1,con1);
DataSet ds = new DataSet();
da1.Fill(ds,"InterviewsInfoTab");
................
select * from table1;select * from table2
多试试!!