Search:   Namespaces Discussions .NET v1.1 Feedback

include DB connection string? Messages   Related Types This message was discovered on microsoft.public.dotnet.framework.aspnet. Post a new message to this list... rc Hello, We have several asp.net pages (.aspx) that access SQL server. Currently, we use a connection string like this: Conn=New SqlConnection("Server=servername;uid=id;pwd=password;database=db") Is there a way to have the connection string (the part in quotes) included from another file? The reason I ask is, in the future, we will move the SQL data to another machine and thus, a different connect string will be needed. It would be nice to only change one file instead of every page that needs the connection. I know include files are commonly used all the time, but I'm not familiar with how to only include one line at this location. Any insight would be helpful. Thank you Reply to this message...        Shiva How about storing the connection string in the web.config file? And access it when required? "rc" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... Hello, We have several asp.net pages (.aspx) that access SQL server. Currently, we use a connection string like this: Conn=New SqlConnection("Server=servername;uid=id;pwd=password;database=db") Is there a way to have the connection string (the part in quotes) included from another file? The reason I ask is, in the future, we will move the SQL data to another machine and thus, a different connect string will be needed. It would be nice to only change one file instead of every page that needs the connection. I know include files are commonly used all the time, but I'm not familiar with how to only include one line at this location. Any insight would be helpful. Thank you Reply to this message...        David Wier Exactly - - like this: <appSettings> <add key="MyDBConnection" value="server=YourServer;uid=Username;pwd=Password;database=DBName" /> </appSettings> Then: Dim myConnection As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("MyDBConnection")) David Wier MCP, MVP ASP.NET, ASPInsider http://aspnet101.com http://aspexpress.com "Shiva" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...        rc Ahh, I hadn't thought of that, I'll give it a try. Thank you "Shiva" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...     System.Configuration.ConfigurationSettings System.Data.SqlClient.SqlConnection Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com