variable Connectionstrin g= in a <asp:SqlDataSou rce ... ?

[tbh]

is it possible in the ConnectionStrin g of an asp:SqlDataSour ce construction
to refer to a variable i define at the top of my ASPX script and initialize,
for example, during Page_Init()?

(the only examples i have seen use hard-coded references to connection
strings defined in machine.config, e.g.

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs: connStrInMachCo nfig %>"
not knowing quite how the
<%$ ... %>
magic is definied i'm at a loss to figure it out on my own.
)

i'd be grateful for pointers.

Tim Hanson

[bruce barker \(sqlwork.com\)]

you cannot use <%= %with server side controls, and the <%# %is for
binding. in OnPreInit set the value rom the code behind.

-- bruce (sqlwork.com)
"tbh" <fe****@newsgro ups.nospamwrote in message
news:eI******** ******@TK2MSFTN GP02.phx.gbl...

is it possible in the ConnectionStrin g of an asp:SqlDataSour ce
construction to refer to a variable i define at the top of my ASPX script
and initialize, for example, during Page_Init()?

(the only examples i have seen use hard-coded references to connection
strings defined in machine.config, e.g.

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs: connStrInMachCo nfig %>"
not knowing quite how the
<%$ ... %>
magic is definied i'm at a loss to figure it out on my own.
)

i'd be grateful for pointers.

Tim Hanson

[tbh]

thanks, Bruce.

sounds like you know some magic i need. do you have a reference (book, URL)
that explains the rules for (what i take to be 3 forms of magic)
<%$ ... %>
<%= %>
<%# %>
?

cheers,

Tim

you cannot use <%= %with server side controls, and the <%# %is for
binding. in OnPreInit set the value rom the code behind.

-- bruce (sqlwork.com)

[Ken Cox [Microsoft MVP]]

Hi Tim,

Why not just assign the connection string in code?

Protected Sub Page_Load _
(ByVal sender As Object, _
ByVal e As System.EventArg s)
sqldatasource1. ConnectionStrin g = _
System.Web.Conf iguration.WebCo nfigurationMana ger. _
ConnectionStrin gs("authorsConn ectionString"). _
ConnectionStrin g
End Sub

Ken
Microsoft MVP [ASP.NET]

"tbh" <fe****@newsgro ups.nospamwrote in message
news:eI******** ******@TK2MSFTN GP02.phx.gbl...

is it possible in the ConnectionStrin g of an asp:SqlDataSour ce
construction to refer to a variable i define at the top of my ASPX script
and initialize, for example, during Page_Init()?

(the only examples i have seen use hard-coded references to connection
strings defined in machine.config, e.g.

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs: connStrInMachCo nfig %>"
not knowing quite how the
<%$ ... %>
magic is definied i'm at a loss to figure it out on my own.
)

i'd be grateful for pointers.

Tim Hanson

[tbh]

thanks, Ken, that's excactly what i needed -- translated to C# and I used
Page_Init().

in retrospect it seems like a dumb question, but i sometimes have trouble
remembering how the declarative bits relate to the procedural bits, even
though i shouldn't.

cheers,

Tim

[DieHardGuy]

In Asp.net the WEB.CONFIG file has been created for the purpose of accessing
GLOBAL Application variables. This is where you should store your connection
string. If your using the free and Brilliant Visual Web Developer, you
should see that a web.config file is created for you when you create a new
website. If your using an existing website without a WEB.CONFIG file you can
create one in VWD or VS.NET by right clicking on your project and clicking
ADD NEW ITEM.

Once you've done this you can add a new connection string in this XML based
document.

Heres the code for the KEY valued pair connection variables:

<appSettings>
<add key="MyConnStri ng"
value="server=l ocalhost;databa se=Northwind;ui d=sa;password=s ecret;" />
</appSettings>

Now in any subsequent classes or ASPX pages that you create simply call the
connectionstrin g as:

Dim cn As New
SqlConnection(C onfigurationSet tings.AppSettin gs("MyConnStrin g").ToString ())

or in ASP.NET 2.0

Dim cn As New
SqlConnection(C onfigurationMan ager.Connection Strings("Connec tionString").Co nnectionString. ToString())

Hope this helps!

Damian
MCP

[tbh]

hmm, the plot thickens. this works initially, but on it fails as attached on
__doPostBack().

any ideas? i've tried adding a couple of additional event handlers (that
call my initialization code), but no luck so far. e.g.

protected override void OnPreRender(Eve ntArgs e) {
initConnectionS trings();
base.OnPreRende r(e);
}

cheers,

Tim

Stack Trace:

[InvalidOperatio nException: The ConnectionStrin g property has not been
initialized.]
System.Data.Sql Client.SqlConne ction.Permissio nDemand() +852019
System.Data.Sql Client.SqlConne ctionFactory.Pe rmissionDemand( DbConnection
outerConnection ) +22
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Sql Client.SqlConne ction.Open() +111
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
+83
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments
arguments) +1770
System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s arguments,
DataSourceViewS electCallback callback) +17
System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +149
System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +70
System.Web.UI.W ebControls.Grid View.DataBind() +4
System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd() +82
System.Web.UI.W ebControls.Grid View.OnPreRende r(EventArgs e) +24
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +77
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +161
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +161
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +1360

[Luke Zhang [MSFT]]

Hello Tim,

Have you try to set the connction string in SqlDataSource's Init event or
load event?

Sincerely,

Luke Zhang

Microsoft Online Community Support
=============== =============== =============== =====
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
=============== =============== =============== =====

This posting is provided "AS IS" with no warranties, and confers no rights.

[tbh]

thanks, Luke, seems like a great idea. once again i didn't know there was
such a thing. haven't learned to think enough in DotNet yet, i fear.

what are my options here? i see from an MSDN document that i can name the
Init Event Handler. but wouldn't it be better to know what the default
handler is (so i can call it before or after my code)?

Have you try to set the connction string in SqlDataSource's Init event or
load event?

[Luke Zhang [MSFT]]

Hello,

What is the "default handler" here? The SqlDataSource's event handler? You
may refer following page to see all of its events we can use:

http://msdn2.microsoft.com/en-us/library/5b6ksy3z.aspx

Sincerely,

Luke Zhang

Microsoft Online Community Support
=============== =============== =============== =====
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
=============== =============== =============== =====

This posting is provided "AS IS" with no warranties, and confers no rights.