1)Master and detail grid
Example
I have 2 sql statments master and detail and assign to oledb recordset
I want 2 grids 1 master and 1 detail and when select a row in master grid show details in detail grid
Columns DOCID,SUBSYSID
This code for datasource
aAdapter.Fill(cut1, aRecordset)
aAdapter.Fill(cut2, aRecordset)
Dim T() As DataColumn = {dt1.Tables("Cut1").Columns("DOCID")}
Dim T1() As DataColumn = {dt1.Tables("Cut2").Columns("DOCID")}
dt1.Tables(
"Cut1").PrimaryKey = T
Dim relCustOrder As DataRelation
relCustOrder =
New DataRelation( _
"CustomersOrders", T, T1)
' Add the relation to the DataSet.
dt1.Relations.Add(relCustOrder)
wgMasterDetails.Datasource = dt1.Tables(
"Cut1")
wgMasterDetails.DataBind()
wgMasterDetailsSlave.Datasource = dt1.Tables(
"Cut2")
wgMasterDetailsSlave.DataBind()
This code for grids ( take from example 2)
<
WG:Grid ID="wgMasterDetails" Debug="true" RecordsPerRow="3" DefaultVisibility="None"
runat="server" Width="900px" OnGridPostBack="wgMasterDetails_GridPostBack">
<Columns>
<WG:GridColumn AllowEdit="False" HideEditTitle="True" UseAllRows="True" ColumnId="wgMasterDetailsSlave"
GridId="wgMasterDetailsSlave" Priority="250" Visibility="Edit" GridAlign="Left"
AllowUpdate="True" HideIfEmpty="False" SearchOption="False" />
<WG:Number ColumnId="DOCID" Visibility="Both" HyperLinkColumn="True" Priority="10"
AllowEdit="True" AllowEmpty="False" AllowUpdate="True" GridAlign="Right" IsInDataSource="True"
Required="True" Title="DOCID" UniqueValueRequired="True" WidthColumnHeaderTitle="120px"
SearchOption="False" />
<WG:Number ColumnId="SUBSYSID" Visibility="Both" HyperLinkColumn="True" Priority="10"
AllowEdit="True" AllowEmpty="False" AllowUpdate="True" GridAlign="Right" IsInDataSource="True"
Required="True" Title="SUBSYSID" UniqueValueRequired="True" WidthColumnHeaderTitle="120px"
SearchOption="False" />
</Columns>
</WG:Grid>
<WG:Grid ID="wgMasterDetailsSlave" Width="450px" DefaultVisibility="Edit" runat="server">
<Columns>
<WG:Foreignkey ColumnId="DOCID"
Visibility="Both" WidthColumnHeaderTitle="250px" />
<WG:Number ColumnId="DOCID" Visibility="Both" HyperLinkColumn="True" Priority="10"
AllowEdit="True" AllowEmpty="False" AllowUpdate="True" GridAlign="Right" IsInDataSource="True"
Required="True" Title="DOCID" UniqueValueRequired="True" WidthColumnHeaderTitle="120px"
SearchOption="False" />
<WG:Number ColumnId="SUBSYSID" Visibility="Both" HyperLinkColumn="True" Priority="10"
AllowEdit="True" AllowEmpty="False" AllowUpdate="True" GridAlign="Right" IsInDataSource="True"
Required="True" Title="SUBSYSID" UniqueValueRequired="True" WidthColumnHeaderTitle="120px"
SearchOption="False" />
</Columns>
</WG:Grid>
But return error !
Any suggestions ?
2) Is there anyway to have a bar on row that have focus on grid
Thanks !!!