trouble with Master-Details list

[brian.newman]

I'm trying to link a gridview to another gridview in a Master-Details
architecture. But the Details list isn't filtering like it is
suppossed to. It will show all items on page load and it won't remove
any items when an item in the Masters list is selected. It shouldn't
show anything until an item in the Master's list is selected and then
only show the details which are associated with the selected item in
the Masters list.
I'm new to ASP.NET (one of the last straglers moving from VBScript)
and, so, I'm probably doing something pretty stupid, but some help
would be really appreciated.
Here's the code

<asp:AccessData Source ID="AccessDataS ource1" runat="server"
DataFile=""

SelectCommand=" SELECT DISTINCT org FROM Orgs"
OnSelecting="Ac cessDataSource1 _Selecting1"></asp:AccessDataS ource>

<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False"

DataSourceID="A ccessDataSource 1" Style="z-index: 100; left:
6px; position: absolute;

top: 7px" DataKeyNames="o rg"
OnSelectedIndex Changed="GridVi ew1_SelectedInd exChanged"
BorderStyle="No ne" PageSize="20">

<Columns>

<asp:HyperLinkF ield DataNavigateUrl Fields="org"
DataNavigateUrl FormatString="D etails.aspx?fie ld={0}"

DataTextField=" org" />

</Columns>

</asp:GridView>

<asp:AccessData Source ID="AccessDataS ource2" runat="server"
DataFile=""

OnSelecting="Ac cessDataSource2 _Selecting1"
SelectCommand=" SELECT Orgs.org, ThreeLetter.[position],
ThreeLetter.loc ation, [user].Name, rights.Type FROM (((Orgs INNER JOIN
ThreeLetter ON Orgs.ID = ThreeLetter.Org s_ID) INNER JOIN rights ON
ThreeLetter.off iceKey = rights.officeKe y) INNER JOIN [user] ON
rights.userKey = [user].userKey) ORDER BY Orgs.org"
FilterExpressio n="Org='@Org' ">

<FilterParamete rs><asp:Control Parameter Name="Org"
ControlID="Grid View1" PropertyName="S electedValue"
/></FilterParameter s>

</asp:AccessDataS ource>

<asp:GridView ID="GridView2" runat="server"
AutoGenerateCol umns="False" DataKeyNames="o rg,Name"

DataSourceID="A ccessDataSource 2" Style="z-index: 103; left:
115px; position: absolute;

top: 9px">

<Columns>

<asp:CommandFie ld HeaderText="Edi t Rights"
ShowEditButton= "True" ShowHeader="Tru e" />

<asp:BoundFie ld DataField="posi tion"
HeaderText="pos ition" SortExpression= "position" />

<asp:BoundFie ld DataField="loca tion"
HeaderText="loc ation" SortExpression= "location" />

<asp:BoundFie ld DataField="Type " HeaderText="Typ e"
SortExpression= "Type" />

</Columns>

</asp:GridView>

[Dave Sexton]

Hi Brian,

The OleDb provider (used by AccessDataSourc e) uses ordered parameters, not named parameters. Also, because you have @Org quoted in
FilterExpressio n it's being used as a string literal. Try naming your parameter OrgParam and using it as is, without a prefix or
quotes directly in a WHERE clause of your query:

SELECT Orgs.Org
[...]
WHERE Org = OrgParam

The details grid should be hidden, by default, until the page is posted back when the user selects a master grid row and if there is
at least one child record to be displayed.

--
Dave Sexton

<br**********@w pafb.af.milwrot e in message news:11******** *************@p 79g2000cwp.goog legroups.com...

I'm trying to link a gridview to another gridview in a Master-Details
architecture. But the Details list isn't filtering like it is
suppossed to. It will show all items on page load and it won't remove
any items when an item in the Masters list is selected. It shouldn't
show anything until an item in the Master's list is selected and then
only show the details which are associated with the selected item in
the Masters list.
I'm new to ASP.NET (one of the last straglers moving from VBScript)
and, so, I'm probably doing something pretty stupid, but some help
would be really appreciated.
Here's the code

<asp:AccessData Source ID="AccessDataS ource1" runat="server"
DataFile=""

SelectCommand=" SELECT DISTINCT org FROM Orgs"
OnSelecting="Ac cessDataSource1 _Selecting1"></asp:AccessDataS ource>

<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False"

DataSourceID="A ccessDataSource 1" Style="z-index: 100; left:
6px; position: absolute;

top: 7px" DataKeyNames="o rg"
OnSelectedIndex Changed="GridVi ew1_SelectedInd exChanged"
BorderStyle="No ne" PageSize="20">

<Columns>

<asp:HyperLinkF ield DataNavigateUrl Fields="org"
DataNavigateUrl FormatString="D etails.aspx?fie ld={0}"

DataTextField=" org" />

</Columns>

</asp:GridView>

<asp:AccessData Source ID="AccessDataS ource2" runat="server"
DataFile=""

OnSelecting="Ac cessDataSource2 _Selecting1"
SelectCommand=" SELECT Orgs.org, ThreeLetter.[position],
ThreeLetter.loc ation, [user].Name, rights.Type FROM (((Orgs INNER JOIN
ThreeLetter ON Orgs.ID = ThreeLetter.Org s_ID) INNER JOIN rights ON
ThreeLetter.off iceKey = rights.officeKe y) INNER JOIN [user] ON
rights.userKey = [user].userKey) ORDER BY Orgs.org"
FilterExpressio n="Org='@Org' ">

<FilterParamete rs><asp:Control Parameter Name="Org"
ControlID="Grid View1" PropertyName="S electedValue"
/></FilterParameter s>

</asp:AccessDataS ource>

<asp:GridView ID="GridView2" runat="server"
AutoGenerateCol umns="False" DataKeyNames="o rg,Name"

DataSourceID="A ccessDataSource 2" Style="z-index: 103; left:
115px; position: absolute;

top: 9px">

<Columns>

<asp:CommandFie ld HeaderText="Edi t Rights"
ShowEditButton= "True" ShowHeader="Tru e" />

<asp:BoundFie ld DataField="posi tion"
HeaderText="pos ition" SortExpression= "position" />

<asp:BoundFie ld DataField="loca tion"
HeaderText="loc ation" SortExpression= "location" />

<asp:BoundFie ld DataField="Type " HeaderText="Typ e"
SortExpression= "Type" />

</Columns>

</asp:GridView>