C1TrueDBGrid.ChildGrid 怎么设置和子表的关联关系？

收藏

本帖最后由 gls6316 于 2018-11-7 11:31 编辑

比如 c1TrueDBGrid1.ChildGrid = c1TrueDBGrid2;
c1TrueDBGrid1 和 c1TrueDBGrid2都有1列是“ID”
怎么设置用ID关联？

JeffryLI · JeffryLI

您好，可以参考这个\Documents\ComponentOne Samples\WinForms\ControlExplorer\TrueDBGrid的这个页面ChildGrids.cs

gls6316 · gls6316

JeffryLI 发表于 2018-11-7 17:30
您好，可以参考这个\Documents\ComponentOne Samples\WinForms\ControlExplorer\TrueDBGrid的这个页面Chil ...

用DataTable或者DataSet绑定能实现吗？
         ds.Relations.Add("REL", ds.Tables["T1"].Columns["ID"], ds.Tables["T2"].Columns["ID"]);
         c1TrueDBGrid1.SetDataBinding(ds, "T1");
         c1TrueDBGrid2.SetDataBinding(ds, "T2");
         c1TrueDBGrid1.ChildGrid = c1TrueDBGrid2;

JeffryLI · JeffryLI

您好，请参考如下代码

private void Form1_Load(object sender, EventArgs e)
{
this.composerTableAdapter.Fill(this.c1NWindDataSet.Composer);
// Create the DataSet and DataTable
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments),
@"ComponentOne Samples\Common\C1NWind.mdb") + ";";
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbDataAdapter adp_Composer = new OleDbDataAdapter("Select Last, * from Composer", conn);
OleDbDataAdapter adp_Opus = new OleDbDataAdapter("Select * from Opus", conn);
DataSet data = new DataSet();
DataTable table_Composer = new DataTable();
DataTable table_Opus = new DataTable();
data.Tables.Add(table_Composer);
data.Tables.Add(table_Opus);
adp_Composer.Fill(table_Composer);
adp_Opus.Fill(table_Opus);
//Create relation between tables
data.Relations.Add("Composer_Sale", data.Tables[table_Composer.TableName].Columns["Last"],
data.Tables[table_Opus.TableName].Columns["Last"]);
//Bind with the dataset
c1TrueDBGrid1.DataSource = data;//MasterGrid
c1TrueDBGrid2.DataSource = data;// ChildGrid
c1TrueDBGrid1.DataMember = table_Composer.TableName;
//Provide master grid data member and data relation name to the child grid data member
c1TrueDBGrid2.DataMember = c1TrueDBGrid1.DataMember + ".Composer_Sale";
//Set the Child grid
c1TrueDBGrid1.ChildGrid = c1TrueDBGrid2;
}

复制代码

gls6316 · gls6316

JeffryLI 发表于 2018-11-8 16:24
您好，请参考如下代码

非常感谢！

JeffryLI · JeffryLI

不客气的，举手之劳

		自动登录	找回密码
密码			立即注册

[已处理] C1TrueDBGrid.ChildGrid 怎么设置和子表的关联关系？

5 个回复

活字格认证

元老葡萄