sqlConnection1=new SqlConnection(frmMain.ConnStr);
sqlConnection1.Open();
sqlDataAdapter1=new SqlDataAdapter("select * from archive",sqlConnection1);
sqlDataAdapter2=new SqlDataAdapter("select * from addrlist",sqlConnection1);
sqlDataAdapter1.Fill(dataSet2,"archive");
sqlDataAdapter2.Fill(dataSet2,"addrlist");
dataSet2.Relations.Add("emp",dataSet2.Tables["archive"].Columns ["EmpNo"],dataSet2.Tables["addrlist"].Columns["EmpNO"]);
dataGrid2.DataMember="archive.emp";
dataGrid1.DataMember=dataSet2.archive
sqlConnection1.Close()你这里需要把RicxBoxText绑定到archive.emp上就够了
sqlConnection1.Open();
sqlDataAdapter1=new SqlDataAdapter("select * from archive",sqlConnection1);
sqlDataAdapter2=new SqlDataAdapter("select * from addrlist",sqlConnection1);
sqlDataAdapter1.Fill(dataSet2,"archive");
sqlDataAdapter2.Fill(dataSet2,"addrlist");
dataSet2.Relations.Add("emp",dataSet2.Tables["archive"].Columns ["EmpNo"],dataSet2.Tables["addrlist"].Columns["EmpNO"]);
dataGrid2.DataMember="archive.emp";
dataGrid1.DataMember=dataSet2.archive
sqlConnection1.Close()你这里需要把RicxBoxText绑定到archive.emp上就够了
代码如下:
DataColumn parentCol;
DataColumn childCol;
// Code to get the DataSet not shown here.
parentCol = dataSet.Tables["tree"].Columns["NodeID"];
childCol = dataSet.Tables["data"].Columns["NodeID"];
// Create DataRelation.
DataRelation relCustOrder;
relCustOrder = new DataRelation("treeID", parentCol, childCol);
// Add the relation to the DataSet.
dataSet.Relations.Add(relCustOrder);请教是什么地方写错
foreach(DataRow dr in dataSet.Tables["tree"].Rows[num].GetChildRows(relCusOrder))
{
处理子表中跟父表中当前记录关联的记录的显示
}才能找出子表中跟父表关联的记录?我以前是学FoxPro的,它的DataRelation是这样用的:
当A表和B表关联之后(A表是父表),当A表的记录移动时,B表中只会显示和父表中当前记录关联的记录,其它的记录被筛选掉,我就是想实现这个功能,不需要建立关联后还要用代码来处理子表中跟父表关联的记录
要在framework1.1下运行,因为1.0有bug!!
可否将xml的数据集换成DataSet呀,我现在还不会xml