FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : ChildRelationCount Property |
'Declaration Public ReadOnly Property ChildRelationCount As Integer
'Usage Dim instance As DefaultSheetDataModel Dim value As Integer value = instance.ChildRelationCount
public int ChildRelationCount {get;}
Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=D:\\nwind.mdb" Dim sqlStr As String = "SELECT * FROM Customers" Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(conStr) Dim ds As DataSet = New DataSet() Dim daCust As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn) daCust.Fill(ds, "Customers") Dim daOrder As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn) daOrder.Fill(ds, "Orders") Dim rel = New DataRelation("CustOrdRel", ds.Tables("Customers").Columns("CustomerID"), ds.Tables("Orders").Columns("CustomerID")) ds.Relations.Add(rel) Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(ds) FpSpread1.ActiveSheet.Models.Data = dataModel Dim i As Integer i = dataModel.ChildRelationCount ListBox1.Items.Add(i.ToString())
string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source=D:\\nwind.mdb"; string sqlStr = "SELECT * FROM Customers"; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr); DataSet ds = new DataSet(); System.Data.OleDb.OleDbDataAdapter daCust = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn); daCust.Fill(ds, "Customers"); System.Data.OleDb.OleDbDataAdapter daOrder = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn); daOrder.Fill(ds, "Orders"); DataRelation rel = new DataRelation("CustOrdRel", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]); ds.Relations.Add(rel); FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(ds); fpSpread1.ActiveSheet.Models.Data = dataModel; int i; i = dataModel.ChildRelationCount; listBox1.Items.Add(i.ToString());
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8