I have 2 Datagrids. One Grid display the parenttable
and the other display the childtable
in relation to the current row in grid1.
Now I want to click on a row in grid2 and like to get
that currentrow of the Childtable.
But the Bindingcontext of this Grid2 returns
the currentrow (Datarow) from...
Me.DataGrid2.SetDataBinding(Me.DataSet1, "Table1.Rel1")
Dim bmb As BindingManagerBase =
Me.DataGrid2.BindingContext(Me.DataGrid2.DataSource,
Me.DataGrid2.DataMember)
bmb.Current only returns the current Datarow from
Parenttable("Table1")
How can I get a Datarow from
a Childtable...
I'd like to set Relations with more than one Datacolumn
in my Dataset between Datatables.
dim Col as DataColumn()
Col = New DataColumn() {DataSet1.Tables(tvSel.Nodes(1).Text).Columns(0), DataSet1.Tables(tvSel.Nodes(1).Text).Columns(1)}
Static constructor of the Datacolumn-array is no problem...
SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store
State].&[CA], [Store].[Store State].&[WA]} ON ROWS
FROM [Sales]
I think CA and WA are Members of this Dimension.
Insert & and it will work
Is it possible to add ADODB.Recordsets
(filled with flattened MDX-Query)
to a shaped Recordset
(opened with MSDataShape-Provider).
It seems to me that MSDataShape can only handle SQL.
Momentarily I fill a shaped Recordset manually with
ADOMDCellset but the performance is really bad.
Any idea...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.