<FilterParamete rs>, please.... I'm stuck on this one !

[Radu]

Hi. On the first page of my website the user selects one document
which can be in either English or French. I store that choice in a
class, and I can extract it with:
CType(Session(" UsersSessionCla ss"), UserSessionClas s).SelLanguage

Later in my 'wizard' I have a page which contains this html:
_______________ _______________ _______________ _______________ ______
<form id="frmStep4Con figureDoYous" runat="server">

<%-- Store the language somewhere - it will be used for filtering the
SqlDataSource below --%>
<% Dim strScLang As String%>
<% strScLang = CType(Session(" UsersSessionCla ss"),
UserSessionClas s).SelLanguage% >
<% HyperLinkScorec ardLanguage.Tex t = strScLang%>
<asp:HyperLin k ID="HyperLinkSc orecardLanguage " runat="server"> </
asp:HyperLink>
<div>
_______________ _______________ _______________ _______________ ______
(For some reason I could not assign the language directly to the text
property of the HyperLink).
I can see the language 'FR' or 'EN', depending on the choice on the
first page. So far so good.

In the same page, below, I have the HTML:
_______________ _______________ _______________ _______________ ______
<asp:DropDownLi st ID="cboDoYou"
AppendDataBound Items="True"
DataSourceID="D oYousSqlDataSou rce"
DataTextField=" DoYou"
DataValueField= "DoYou"
runat="server">
</asp:DropDownLis t>
<asp:SqlDataSou rce
ID="DoYousSqlDa taSource"

SelectCommand=" SELECT DISTINCT
Principles.[Principle ID] as PrincipleID,
DoYous.[DoYou Description] as DoYou,
DoYous.[DoYou Language] as ScorecardLangua ge
FROM DoYous_BY_Princ iple_BY_ScType
INNER JOIN Principles
ON DoYous_BY_Princ iple_BY_ScType.[Principle ID] = Principles.
[Principle ID]
INNER JOIN DoYous
ON DoYous_BY_Princ iple_BY_ScType.[DoYou ID] = DoYous.[DoYou ID]"

EnableCaching=" True"
CacheDuration=" 60"
FilterExpressio n="PrincipleI D = {0} AND ScorecardLangua ge = '{1}'"
ConnectionStrin g="Data Source='...."
RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkPrincipleI D"
PropertyName="T ext" />
<asp:ControlPar ameter ControlID="Hype rLinkScorecardL anguage"
PropertyName="T ext" />
</FilterParameter s>
</asp:SqlDataSour ce>
_______________ _______________ _______________ _______________ ______
Question 1. Although I can clearly see the language in the control
'HyperLinkScore cardLanguage' at the beginning of the page, I can't
reference it in my FilterParameter s, meaning that it does not throw an
error, but it doesn't filter properly either - it populates cboDoYou
with the values from the 'DoYou' column of table DoYous, for the
correct PrincipleID (the one on the current row in the repeater), but
for BOTH EN and FR....

However, if I hardcode the FilterExpressio n to
FilterExpressio n="PrincipleI D = {0} AND ScorecardLangua ge = 'EN'"
or
FilterExpressio n="PrincipleI D = {0} AND ScorecardLangua ge = 'FR'"
it all works great !
If in break mode in the code-behind page I interrogate
HyperLinkScorec ardLanguage.tex t, it returns an empty string (although
I can see 'EN' in the HyperLinkScorec ardLanguage control !), so
therefore I guess I'm not referencing the HyperLinkScorec ardLanguage
control properly in my line
<asp:ControlPar ameter ControlID="Hype rLinkScorecardL anguage"
PropertyName="T ext" />

What is the correct syntax, please ? Where is my problem ?

Question 2. Instead of hardcoding
ConnectionStrin g="Data Source='blah-blah-blah...."
I would like to use the setting from WebConfig
<appSettings>
<add key="Connection String" value="Data Source=..."/>
by using
System.Configur ation.Configura tionManager.App Settings("Conne ctionString")
as in:
ConnectionStrin g='<%=
System.Configur ation.Configura tionManager.App Settings("Conne ctionString")
%>'
but this does not work ! How can I specify the connection string in
this case ?

Thanks a lot !
Alex.