How to use function in ConnectionStrin g property in SQLDataSource Webcontrol ?

[Radu]

Hi. In a repeater I have as ItemTemplate the following, among others,
and everything works great:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT blah-blah-blah"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}" RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkMeasureID"
PropertyName="T ext" /> </FilterParameter s>
</asp:SqlDataSour ce>
etc.
I have encrypted in Base64 the "OrderingProces s" which was
<add name="OrderingP rocess" connectionStrin g="server=xxx
\xxx;database=x xx;User ID=xxx;Password =xxx;"
providerName="S ystem.Data.SqlC lient" />

and the "ConnectionStri ng" which was
<add key="Connection String" value="Data Source=xxx\xxx; Initial
Catalog=xxx;Use r ID=xxx;Password =xxx;"/>

and in the code-behind I have a function named DecryptSetting which
can be used as:

DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order ingProcess"))
The question is: how could I use this function in
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
above ?

I cannot say
ConnectionStrin g="<%=
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order ingProcess"))
%>"
In all the places in code behind where I needed the connection string,
I have used
Cache("Connecti onString") which has been set in App_Init as:

HttpContext.Cur rent.Cache("Con nectionString") =
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Conne ctionString"))

Thanks a lot for your time and effort.
Alex.

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

How about something like:

ConnectionStrin g="<%$ DecryptSettings (ConnectionStri ngs:OrderingPro cess) %>"
-- the syntax may not be exactly right, but this approach works fine with
many <%--%delimited items.
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Radu" wrote:

Hi. In a repeater I have as ItemTemplate the following, among others,
and everything works great:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT blah-blah-blah"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}" RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkMeasureID"
PropertyName="T ext" /> </FilterParameter s>
</asp:SqlDataSour ce>
etc.
I have encrypted in Base64 the "OrderingProces s" which was
<add name="OrderingP rocess" connectionStrin g="server=xxx
\xxx;database=x xx;User ID=xxx;Password =xxx;"
providerName="S ystem.Data.SqlC lient" />

and the "ConnectionStri ng" which was
<add key="Connection String" value="Data Source=xxx\xxx; Initial
Catalog=xxx;Use r ID=xxx;Password =xxx;"/>

and in the code-behind I have a function named DecryptSetting which
can be used as:

DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order ingProcess"))
The question is: how could I use this function in
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
above ?

I cannot say
ConnectionStrin g="<%=
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order ingProcess"))
%>"
In all the places in code behind where I needed the connection string,
I have used
Cache("Connecti onString") which has been set in App_Init as:

HttpContext.Cur rent.Cache("Con nectionString") =
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Conne ctionString"))

Thanks a lot for your time and effort.
Alex.

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

You could also create a public static (Shared in VB) function (in App_Code)
which will return decrypted connection string based on a string name
parameter, but will only read the config once per request and store them in a
Generic string dictionary for subsequent calls. Then you can either store the
dictionary in a static variable, or even application Cache.

Then from your aspx pages you could call this function similar to the
following:
ConnectionStrin g="<%= GetMyConnect("O rderingProcess" ) %>

"Peter Bromberg [C# MVP]" wrote:

How about something like:

ConnectionStrin g="<%$ DecryptSettings (ConnectionStri ngs:OrderingPro cess) %>"
-- the syntax may not be exactly right, but this approach works fine with
many <%--%delimited items.
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Radu" wrote:

Hi. In a repeater I have as ItemTemplate the following, among others,
and everything works great:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT blah-blah-blah"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}" RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkMeasureID"
PropertyName="T ext" /> </FilterParameter s>
</asp:SqlDataSour ce>
etc.
I have encrypted in Base64 the "OrderingProces s" which was
<add name="OrderingP rocess" connectionStrin g="server=xxx
\xxx;database=x xx;User ID=xxx;Password =xxx;"
providerName="S ystem.Data.SqlC lient" />

and the "ConnectionStri ng" which was
<add key="Connection String" value="Data Source=xxx\xxx; Initial
Catalog=xxx;Use r ID=xxx;Password =xxx;"/>

and in the code-behind I have a function named DecryptSetting which
can be used as:

DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order ingProcess"))
The question is: how could I use this function in
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
above ?

I cannot say
ConnectionStrin g="<%=
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order ingProcess"))
%>"
In all the places in code behind where I needed the connection string,
I have used
Cache("Connecti onString") which has been set in App_Init as:

HttpContext.Cur rent.Cache("Con nectionString") =
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Conne ctionString"))

Thanks a lot for your time and effort.
Alex.

[Radu]

On May 14, 10:28 pm, Sergey Poberezovskiy
<SergeyPoberezo vs...@discussio ns.microsoft.co mwrote:

You could also create a public static (Shared in VB) function (in App_Code)
which will return decrypted connection string based on a string name
parameter, but will only read the config once per request and store them in a
Generic string dictionary for subsequent calls. Then you can either storethe
dictionary in a static variable, or even application Cache.

Then from your aspx pages you could call this function similar to the
following:
ConnectionStrin g="<%= GetMyConnect("O rderingProcess" ) %>

"Peter Bromberg [C# MVP]" wrote:

How about something like:

ConnectionStrin g="<%$ DecryptSettings (ConnectionStri ngs:OrderingPro cess) %>"
-- the syntax may not be exactly right, but this approach works fine with
many <%--%delimited items.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net

"Radu" wrote:

Hi. In a repeater I have as ItemTemplate the following, among others,
and everything works great:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT blah-blah-blah"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}" RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkMeasureID"
PropertyName="T ext" / </FilterParameter s>
</asp:SqlDataSour ce>
etc.

I have encrypted in Base64 the "OrderingProces s" which was
<add name="OrderingP rocess" connectionStrin g="server=xxx
\xxx;database=x xx;User ID=xxx;Password =xxx;"
providerName="S ystem.Data.SqlC lient" />

and the "ConnectionStri ng" which was
<add key="Connection String" value="Data Source=xxx\xxx; Initial
Catalog=xxx;Use r ID=xxx;Password =xxx;"/>

and in the code-behind I have a function named DecryptSetting which
can be used as:

DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order *ingProcess"))

The question is: how could I use this function in
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
above ?

I cannot say
ConnectionStrin g="<%=
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order *ingProcess"))
%>"

In all the places in code behind where I needed the connection string,
I have used
Cache("Connecti onString") which has been set in App_Init as:

HttpContext.Cur rent.Cache("Con nectionString") =
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Conne *ctionString"))

Thanks a lot for your time and effort.
Alex.- Hide quoted text -

- Show quoted text -

Thank you for answering !

I have tried with
ConnectionStrin g="<%=
DecryptSetting( ConnectionStrin gs:OrderingProc ess) %>"

and it compiles, but when time comes to serve that page, I get
Keyword not supported: '<%'.
When I try with
ConnectionStrin g="<%$
DecryptSetting( ConnectionStrin gs:CNOrderingPr ocess) %>"
(the only change is the '$' sign instead of '='), then I get 98 errors
and warnings, all having NOTHING to do with the problem at hand
(example: Message 88 Could not find schema information for the
element 'http://schemas.microso ft.com/.NetConfigurati on/
v2.0:customErro rs'.) - thank you, compiler, but I also get the real
problem:
Error 90 The expression prefix 'DecryptSetting (ConnectionStri ngs'
was not recognized. Please correct the prefix or register the prefix
in the <expressionBuil derssection of configuration.
The function DecryptSetting is ultra-simple, in MAIN.vb in APP_CODE:

Public Function DecryptSetting( ByVal Source As String) As String

Dim data() As Byte = Convert.FromBas e64String(Sourc e)
Return System.Text.ASC IIEncoding.ASCI I.GetString(dat a)
End Function
Thanks again
Alex.

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

Alex,

Quote from MSDN:
"The dollar sign ($) indicates to ASP.NET that an expression follows. The
expression prefix defines the type of expression, such as AppSettings,
ConnectionStrin gs, or Resources. Following the colon (:) is the actual
expression value that ASP.NET will resolve."

That is the reason why the compiler complains when you are trying <%$
Deccrypt ... your connection - it is not one of the predefined

If you want to call a function from HTML then you would use <%= syntax, but
then the parser will not recognize ConnectionStrin gs:MyStringName syntax

You could do something in between:
- declare your connection string in web.config as <add name="myName"
connectionStrin g="myString" providerName="m yProvider"
- call your shared function from html with <%= syntax passing the connection
name as the parameter: <%= MyDecrypt("myNa me") %>
- in decrypt function use ConfigurationMa nager to retrieve the connection
string
Public Shared Function MyDecrypt(cnNam e As String) As String
Dim result As String =
ConfigurationMa nager.Connectio nStrings(cnName ).ConnectionStr ing
' perform the decryption: result = decrypted(resul t)
Return result
End Function

There may be a better way to do it - but this should get you over the line.
Personally, I do not use DataSources - hence I am not the best source of
info on the topic.

Hope this helps

"Radu" wrote:

On May 14, 10:28 pm, Sergey Poberezovskiy
<SergeyPoberezo vs...@discussio ns.microsoft.co mwrote:

You could also create a public static (Shared in VB) function (in App_Code)
which will return decrypted connection string based on a string name
parameter, but will only read the config once per request and store them in a
Generic string dictionary for subsequent calls. Then you can either store the
dictionary in a static variable, or even application Cache.

Then from your aspx pages you could call this function similar to the
following:
ConnectionStrin g="<%= GetMyConnect("O rderingProcess" ) %>

"Peter Bromberg [C# MVP]" wrote:

How about something like:

ConnectionStrin g="<%$ DecryptSettings (ConnectionStri ngs:OrderingPro cess) %>"
-- the syntax may not be exactly right, but this approach works fine with
many <%--%delimited items.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net

"Radu" wrote:

Hi. In a repeater I have as ItemTemplate the following, among others,
and everything works great:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT blah-blah-blah"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}" RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkMeasureID"
PropertyName="T ext" / </FilterParameter s>
</asp:SqlDataSour ce>
etc.

I have encrypted in Base64 the "OrderingProces s" which was
<add name="OrderingP rocess" connectionStrin g="server=xxx
\xxx;database=x xx;User ID=xxx;Password =xxx;"
providerName="S ystem.Data.SqlC lient" />

and the "ConnectionStri ng" which was
<add key="Connection String" value="Data Source=xxx\xxx; Initial
Catalog=xxx;Use r ID=xxx;Password =xxx;"/>

and in the code-behind I have a function named DecryptSetting which
can be used as:

DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order Â*ingProcess"))

The question is: how could I use this function in
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
above ?

I cannot say
ConnectionStrin g="<%=
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order Â*ingProcess"))
%>"

In all the places in code behind where I needed the connection string,
I have used
Cache("Connecti onString") which has been set in App_Init as:

HttpContext.Cur rent.Cache("Con nectionString") =
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Conne Â*ctionString") )

Thanks a lot for your time and effort.
Alex.- Hide quoted text -

- Show quoted text -

Thank you for answering !

I have tried with
ConnectionStrin g="<%=
DecryptSetting( ConnectionStrin gs:OrderingProc ess) %>"

and it compiles, but when time comes to serve that page, I get
Keyword not supported: '<%'.
When I try with
ConnectionStrin g="<%$
DecryptSetting( ConnectionStrin gs:CNOrderingPr ocess) %>"
(the only change is the '$' sign instead of '='), then I get 98 errors
and warnings, all having NOTHING to do with the problem at hand
(example: Message 88 Could not find schema information for the
element 'http://schemas.microso ft.com/.NetConfigurati on/
v2.0:customErro rs'.) - thank you, compiler, but I also get the real
problem:
Error 90 The expression prefix 'DecryptSetting (ConnectionStri ngs'
was not recognized. Please correct the prefix or register the prefix
in the <expressionBuil derssection of configuration.
The function DecryptSetting is ultra-simple, in MAIN.vb in APP_CODE:

Public Function DecryptSetting( ByVal Source As String) As String

Dim data() As Byte = Convert.FromBas e64String(Sourc e)
Return System.Text.ASC IIEncoding.ASCI I.GetString(dat a)
End Function
Thanks again
Alex.

[Radu]

On May 15, 9:41 pm, Sergey Poberezovskiy
<SergeyPoberezo vs...@discussio ns.microsoft.co mwrote:

Alex,

Quote from MSDN:
"The dollar sign ($) indicates to ASP.NET that an expression follows. The
expression prefix defines the type of expression, such as AppSettings,
ConnectionStrin gs, or Resources. Following the colon (:) is the actual
expression value that ASP.NET will resolve."

That is the reason why the compiler complains when you are trying <%$
Deccrypt ... your connection - it is not one of the predefined

If you want to call a function from HTML then you would use <%= syntax,but
then the parser will not recognize ConnectionStrin gs:MyStringName syntax

You could do something in between:
- declare your connection string in web.config as <add name="myName"
connectionStrin g="myString" providerName="m yProvider"
- call your shared function from html with <%= syntax passing the connection
name as the parameter: <%= MyDecrypt("myNa me") %>
- in decrypt function use ConfigurationMa nager to retrieve the connection
string
Public Shared Function MyDecrypt(cnNam e As String) As String
Dim result As String =
ConfigurationMa nager.Connectio nStrings(cnName ).ConnectionStr ing
' perform the decryption: result = decrypted(resul t)
Return result
End Function

There may be a better way to do it - but this should get you over the line.
Personally, I do not use DataSources - hence I am not the best source of
info on the topic.

Hope this helps

"Radu" wrote:

On May 14, 10:28 pm, Sergey Poberezovskiy
<SergeyPoberezo vs...@discussio ns.microsoft.co mwrote:

You could also create a public static (Shared in VB) function (in App_Code)
which will return decrypted connection string based on a string name
parameter, but will only read the config once per request and store them in a
Generic string dictionary for subsequent calls. Then you can either store the
dictionary in a static variable, or even application Cache.

Then from your aspx pages you could call this function similar to the
following:
ConnectionStrin g="<%= GetMyConnect("O rderingProcess" ) %>

"Peter Bromberg [C# MVP]" wrote:

How about something like:

ConnectionStrin g="<%$ DecryptSettings (ConnectionStri ngs:OrderingPro cess) %>"
-- the syntax may not be exactly right, but this approach works fine with
many <%--%delimited items.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net

"Radu" wrote:

Hi. In a repeater I have as ItemTemplate the following, among others,
and everything works great:

<asp:SqlDataSou rce
ID="LocationSql DataSource"
SelectCommand=" SELECT blah-blah-blah"
EnableCaching=" True"
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
CacheDuration=" 60"
FilterExpressio n="ID = {0}" RunAt="server">

<FilterParamete rs>
<asp:ControlPar ameter ControlID="Hype rLinkMeasureID"
PropertyName="T ext" / </FilterParameter s>
</asp:SqlDataSour ce>
etc.

I have encrypted in Base64 the "OrderingProces s" which was
<add name="OrderingP rocess" connectionStrin g="server=xxx
\xxx;database=x xx;User ID=xxx;Password =xxx;"
providerName="S ystem.Data.SqlC lient" />

and the "ConnectionStri ng" which was
<add key="Connection String" value="Data Source=xxx\xxx; Initial
Catalog=xxx;Use r ID=xxx;Password =xxx;"/>

and in the code-behind I have a function named DecryptSetting which
can be used as:

DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order **ingProcess"))

The question is: how could I use this function in
ConnectionStrin g="<%$ ConnectionStrin gs:OrderingProc ess %>"
above ?

I cannot say
ConnectionStrin g="<%=
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Order **ingProcess"))
%>"

In all the places in code behind where I needed the connection string,
I have used
Cache("Connecti onString") which has been set in App_Init as:

HttpContext.Cur rent.Cache("Con nectionString") =
DecryptSetting( System.Configur ation.Configura tionManager.App Settings("Conne **ctionString") )

Thanks a lot for your time and effort.
Alex.- Hide quoted text -

- Show quoted text -

Thank you for answering !

I have tried with
ConnectionStrin g="<%=
DecryptSetting( ConnectionStrin gs:OrderingProc ess) %>"

and it compiles, but when time comes to serve that page, I get
Keyword not supported: '<%'.

When I try with
ConnectionStrin g="<%$
DecryptSetting( ConnectionStrin gs:CNOrderingPr ocess) %>"
(the only change is the '$' sign instead of '='), then I get 98 errors
and warnings, all having NOTHING to do with the problem at hand
(example: Message 88 Could not find schema information for the
element 'http://schemas.microso ft.com/.NetConfigurati on/
v2.0:customErro rs'.) - thank you, compiler, but I also get the real
problem:
Error 90 The expression prefix 'DecryptSetting (ConnectionStri ngs'
was not recognized. Please correct the prefix or register the prefix
in the <expressionBuil derssection of configuration.

The function DecryptSetting is ultra-simple, in MAIN.vb in APP_CODE:

Public Function DecryptSetting( ByVal Source As String) As String

Dim data() As Byte = Convert.FromBas e64String(Sourc e)
Return System.Text.ASC IIEncoding.ASCI I.GetString(dat a)
End Function

Thanks again
Alex.- Hide quoted text -

- Show quoted text -

Thanks, you're right, this should work - it's logical. Thank you very
much.
Alex.