Using Parameters within SqlDataSource Object--Need Help~

From: "Brad Isaacs" <bisaacs@xxxxxxxxxx>
Date: Mon, 29 Jan 2007 20:04:09 -0500

Good evening friends,

I have added a Drop Down List box control to my web form.
The table contains 3 fields :

LanguageID
ProvinceID
Province

I have also added a SqlDataSource object and configured it to retrieve
Provinces based on my parameter named @languageID

<asp:DropDownList ID="ddlProvince" runat="server"
DataSourceID="ProvSqlDataSource"

DataTextField="province" DataValueField="province" Width="196px">

</asp:DropDownList></td>

<asp:SqlDataSource ID="ProvSqlDataSource" runat="server"
CacheExpirationPolicy="Sliding"

ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"

SelectCommand="SELECT DISTINCT [province] FROM [provinces] WHERE
([languageID] = @languageID ) ORDER BY [province]">

</asp:SqlDataSource>

If I dump the following:
SelectCommand="SELECT DISTINCT [province] FROM [provinces] WHERE
([languageID] = '1') ORDER BY [province]">

it works however, I need to find a way to gain access to the @LanguageID
parameter.

My problem is how I may gain access to the @languageID parameter. I feel
kinda stoopid, as this may be an easy solution.

It has to change either "1" for English and "2" for French,,,

Depending on the language chosen for the web form page. So I use this code
to retrieve the language chosen by the user.

<%

Dim languageSuffix, altlang, lang As String

Dim langID As Int32

lang = Request.QueryString("lang")

If Request.QueryString("lang") = "" Then

lang = "en"

End If

'Response.Write("<br />The Lang is--> " & lang)

If (lang = "fr") Then

langID = 2

altlang = "fr"

Else ' lang = "en"

langID = 1

altlang = "en"

End If

Response.Write(("<br />The LangID is--> " & langID))

%>

But I cannot for the life of me figure out how to gain access to the
@languageID and add 1 if English or 2 if French.

Any ideas, code examples or urls would be greatly appreciated,

Thanks in advance

~Brad

--
------------------------------
Brad Isaacs
Developer, Consultant
www.webdevcreations.com
bisaacs@xxxxxxxxxx

.

Prev by Date: Re: Error Handling
Next by Date: Re: Too many objects loaded at the same time and cause OutOfMemory exception.
Previous by thread: The server committed a protocol violation. Section=ResponseStatusLine
Next by thread: Re: Running jscript in initialization of ContentPlaceHolder
Index(es):
- Date
- Thread

Relevant Pages

DropDownList| SqlDataSource | and Parameters??~
... I have added a Drop Down List box control to my web form. ... web.config connection string to access my SQL Server 2000 db. ... My problem is how I may gain access to the @languageID parameter. ... Dim languageSuffix, altlang, lang As String ...
(microsoft.public.dotnet.framework.aspnet)
RE: DropDownList| SqlDataSource | and Parameters??~
... Dim altlang As String ... Dim lang As String ... Dim langID As Int32 ... My problem is how I may gain access to the @languageID parameter. ...
(microsoft.public.dotnet.framework.aspnet)