DropDownList| SqlDataSource | and Parameters??~

[Brad Isaacs]

Good evening friends,

I have added a Drop Down List box control to my web form. I am using the
web.config connection string to access my SQL Server 2000 db. Inside that
db I have a table named Provinces.

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:DropDownLi st ID="ddlProvince " runat="server"
DataSourceID="P rovSqlDataSourc e"

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

</asp:DropDownLis t></td>

<asp:SqlDataSou rce ID="ProvSqlData Source" runat="server"
CacheExpiration Policy="Sliding "

ConnectionStrin g="<%$ ConnectionStrin gs:MyConnection String %>"

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

</asp:SqlDataSour ce>

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.QuerySt ring("lang")
If Request.QuerySt ring("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

[=?Utf-8?B?SmFzb24gVmVybWlsbGlvbg==?=]

Brad,

You can manually update your parameters and select the data through code via:

Me.ProvSqlDataS ource.SelectPar ameters("langua geID").DefaultV alue = langID
Me.ProvSqlDataS ource.Select(Da taSourceSelectA rguments.Empty)

Also, try handling the querystring logic in your page_load event.

See the code below.

Hope this helps,
Jason Vermillion

<asp:SqlDataSou rce ID="ProvSqlData Source" runat="server"
SelectCommand=" SELECT DISTINCT [province] FROM [provinces] WHERE
([languageID] = @languageID ) ORDER BY [province]">
<SelectParamete rs>
<asp:Paramete r Name="languageI D" />
</SelectParameter s>
</asp:SqlDataSour ce>

Then in your page_load...

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s)
Handles Me.Load
Dim altlang As String
Dim lang As String

Dim langID As Int32

lang = Request.QuerySt ring("lang")
If Request.QuerySt ring("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

Me.ProvSqlDataS ource.SelectPar ameters("langua geID").DefaultV alue = langID
Me.ProvSqlDataS ource.Select(Da taSourceSelectA rguments.Empty)
End Sub
"Brad Isaacs" wrote:

Good evening friends,

I have added a Drop Down List box control to my web form. I am using the
web.config connection string to access my SQL Server 2000 db. Inside that
db I have a table named Provinces.

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:DropDownLi st ID="ddlProvince " runat="server"
DataSourceID="P rovSqlDataSourc e"

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

</asp:DropDownLis t></td>

<asp:SqlDataSou rce ID="ProvSqlData Source" runat="server"
CacheExpiration Policy="Sliding "

ConnectionStrin g="<%$ ConnectionStrin gs:MyConnection String %>"

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

</asp:SqlDataSour ce>

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.QuerySt ring("lang")
If Request.QuerySt ring("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]

Jason,

Thanks for your input.

I was able to use the QueryString parameter. My problem was that I was not
sending the langID=1 or langID=2 when the user had chosen a language for the
page. I needed to PASS the value. Once I passed the value, all I had to do
was add the QueryString parameter and it all worked.

Thanks again for your input.

~Brad
"Jason Vermillion" <Ja************ *@discussions.m icrosoft.comwro te in
message news:3E******** *************** ***********@mic rosoft.com...

Brad,

You can manually update your parameters and select the data through code
via:

Me.ProvSqlDataS ource.SelectPar ameters("langua geID").DefaultV alue = langID
Me.ProvSqlDataS ource.Select(Da taSourceSelectA rguments.Empty)

Also, try handling the querystring logic in your page_load event.

See the code below.

Hope this helps,
Jason Vermillion

<asp:SqlDataSou rce ID="ProvSqlData Source" runat="server"
SelectCommand=" SELECT DISTINCT [province] FROM [provinces] WHERE
([languageID] = @languageID ) ORDER BY [province]">
<SelectParamete rs>
<asp:Paramete r Name="languageI D" />
</SelectParameter s>
</asp:SqlDataSour ce>

Then in your page_load...

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s)
Handles Me.Load
Dim altlang As String
Dim lang As String

Dim langID As Int32

lang = Request.QuerySt ring("lang")
If Request.QuerySt ring("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

Me.ProvSqlDataS ource.SelectPar ameters("langua geID").DefaultV alue =
langID
Me.ProvSqlDataS ource.Select(Da taSourceSelectA rguments.Empty)
End Sub
"Brad Isaacs" wrote:

>Good evening friends,

I have added a Drop Down List box control to my web form. I am using the
web.config connection string to access my SQL Server 2000 db. Inside
that
db I have a table named Provinces.

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:DropDownL ist ID="ddlProvince " runat="server"
DataSourceID=" ProvSqlDataSour ce"

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

</asp:DropDownLis t></td>

<asp:SqlDataSo urce ID="ProvSqlData Source" runat="server"
CacheExpiratio nPolicy="Slidin g"

ConnectionStri ng="<%$ ConnectionStrin gs:MyConnection String %>"

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

</asp:SqlDataSour ce>

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.QuerySt ring("lang")
If Request.QuerySt ring("lang") = "" Then

lang = "en"

End If

'Response.Writ e("<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