Connection Strings C#

[Sparta71]

Hello,

I'm pretty new with this so please bare with me.

I have an ASP.NET application where all of the calls to the database are stored in a standalone C# file (DataStorage.cs). This file contains all the methods, AddCustomer, etc. and is really nice because I can call it from any of the pages in the application. The problem I'm having is with the connection string. Basically, right now the connection string is hard-coded and I would like it to be dynamic so I didn't need to worry about whether it was on my local machine, on the web server, or perhaps was moved to a different server. Anyways, I've used server.mappath in some of the regular application pages and it works fine but I can't use it in the DataStorage page because it's just a stand-alone C# file. Is there a way to get server.mappath in there? I assume I just need to import something, but I can't figure out what.

Thanks!

[gomzi]

Hello,

I'm pretty new with this so please bare with me.

I have an ASP.NET application where all of the calls to the database are stored in a standalone C# file (DataStorage.cs). This file contains all the methods, AddCustomer, etc. and is really nice because I can call it from any of the pages in the application. The problem I'm having is with the connection string. Basically, right now the connection string is hard-coded and I would like it to be dynamic so I didn't need to worry about whether it was on my local machine, on the web server, or perhaps was moved to a different server. Anyways, I've used server.mappath in some of the regular application pages and it works fine but I can't use it in the DataStorage page because it's just a stand-alone C# file. Is there a way to get server.mappath in there? I assume I just need to import something, but I can't figure out what.

Thanks!

add the connection string in the web.config and use it in c#.

WEB.CONFIG
<configuration>
<appSettings>
<add key="connectionstring" value="Server=yourservername;User Id=yourusername;Database=yourdb;password=yourpwd;"/>
</appSettings>
...


code behind..

Dim con As New MySqlConnection(ConfigurationManager.AppSettings(" connectionstring"))

[Sparta71]

Thanks, I'll give that a try.