Setting up connection string in ASP NET to SQL SERVER

Question

I m trying to set up a connecting string in my web config file  Visual Studio 2008 ASP NET 3 5  to a local server  SQL server 2008    In my web config  how and where do I place the connection string   Here s what web config file looks like right now  http   imwired net aspnet Online web config

User · Answer

Create a section called  lt connectionStrings gt  lt  connectionStrings gt  in your web config inside  lt configuration gt  lt  configuration gt  then add different connection strings to it  for example   lt configuration gt      lt connectionStrings gt      lt add name  ConnectionStringName  providerName  System Data SqlClient  connectionString  Data Source   SQLEXPRESS Initial Catalog DatabaseName Integrated Security True MultipleActiveResultSets True   gt     lt  connectionStrings gt    lt  configuration gt    Here s a list of all the different connection string formats https   msdn microsoft com en-us library jj653752 v vs 110  aspx

User · Answer

You can put this in your web config file connectionStrings    lt add name  myConnectionString  connectionString  Server myServerAddress Database myDataBase User ID myUsername Password myPassword Trusted Connection False   providerName  System Data SqlClient   gt

User · Answer

You can use following format      lt connectionStrings gt       lt add name  ConStringBDName  connectionString  Data Source serverpath Initial Catalog YourDataBaseName Integrated Security SSPI   providerName  System Data SqlClient    gt     lt  connectionStrings gt    Most probably you will fing connectionstring tag in web config after  lt appSettings gt   Try out this

User · Answer

For some reason I don t see the simple answer here   Put this at the top of your code    using System Web Configuration  using System Data SqlClient     Put this in Web Config    lt connectionStrings  gt       lt add          name  myConnectionString            connectionString  Server myServerAddress Database myDataBase User ID myUsername Password myPassword Trusted Connection False            providerName  System Data SqlClient   gt   lt  connectionStrings gt    and where you want to setup the connection variable   SqlConnection con   new SqlConnection      WebConfigurationManager ConnectionStrings  myConnectionString   ConnectionString

User · Answer

Try this for your connection string     Data Source myServerAddress Initial Catalog myDataBase Integrated Security SSPI   User ID myDomain myUsername Password myPassword

User · Answer

If you want to write connection string in Web config then write under given sting   lt connectionStrings gt     lt add name  Conn  connectionString  Data Source 192 168 1 25 Initial Catalog Login Persist Security Info True User ID sa Password example com     providerName  System Data SqlClient    gt    lt  connectionStrings gt    OR  you right in aspx cs file like   SqlConnection conn   new SqlConnection  Data Source 12 16 1 25 Initial Catalog Login Persist Security Info True User ID sa Password example com

User · Answer

You can also use this  it s simpler  The only thing you need to set is  YourDataBaseName       lt connectionStrings gt       lt add name  ConnStringDb1  connectionString  Data Source localhost Initial Catalog YourDataBaseName Integrated Security True   providerName  System Data SqlClient    gt     lt  connectionStrings gt    Where to place the connection string   lt  xml version  1 0  encoding  utf-8   gt       lt configuration gt         lt connectionStrings gt           lt clear   gt           lt add name  Name            providerName  System Data ProviderName            connectionString  Valid Connection String     gt         lt  connectionStrings gt       lt  configuration gt

User · Answer

You can try this  It is very simple   lt connectionStrings gt                lt add name  conString  connectionString  Data Source SQLServerAddress Initial Catalog YourDatabaseName  User Id SQLServerLoginId  Password SQLServerPassword   gt   lt  connectionStrings gt

User · Answer

You can also use external configuration file to specify connection strings section  and refer that file in application configuration file like in web config  Like the in web config file    lt configuration gt         lt connectionStrings configSource  connections config   gt     lt  configuration gt      The external configuration connections config file will contains connections section   lt connectionStrings gt       lt add name  Name        providerName  System Data ProviderName        connectionString  Valid Connection String     gt      lt  connectionStrings gt         Modifying contents of external configuration file will not restart the application  as ASP net does by default with any change in application configuration files

User · Answer

Connection in WebConfig  Add the your connection string to the  lt connectionStrings gt  element in the Web config file    lt connectionStrings gt   lt add name  ConnectionString  connectionString  Data Source 192 168 1 25 Initial Catalog Login Persist Security Info True User ID sa Password example com    providerName  System Data SqlClient    gt   lt  connectionStrings gt    In Class Cs  public static string ConnectionString  get  return ConfigurationManager ConnectionStrings  ConnectionString   ConnectionString   set

User · Answer

it should be within the  lt configuration gt  node      lt connectionStrings  gt       lt add name  myconnectionstring  connectionString  Server myServerAddress Database myDataBase User ID myUsername Password myPassword Trusted Connection False   providerName  System Data SqlClient   gt     lt  connectionStrings gt    this site has more info on it

User · Answer

in header  using System Configuration    in code  SqlConnection conn   new SqlConnection  ConfigurationManager ConnectionStrings  connstrname   ConnectionString

User · Answer

I JUST FOUND   You need to put this string connection and point directly to your database   Same case on server    Provider Microsoft ACE OLEDB 12 0    Data Source c  inetpub wwwroot TEST data data mdb     It works

User · Answer

Store connection string in web config  It is a good practice to store the connection string for your application in a config file rather than as a hard coded string in your code  The way to do this differs between  NET 2 0 and  NET 3 5  and above   This article cover both  https   www connectionstrings com store-connection-string-in-webconfig

User · Answer

I found this very difficult to get an answer to but eventually figured it out  So I will write the steps below    Before you setup your connection string in code  ensure you actually can access your database  Start obviously by logging into the database server using SSMS  Sql Server Management Studio or it s equivalent in other databases  locally to ensure you have access using whatever details you intend to use  Next  if needed   if you are trying to access the database on a separate server  ensure you can do likewise in SSMS  So setup SSMS on a computer and ensure you can access the server with the username and password to that database server    If you don t get the above 2 right  you are simply wasting your time as you cant access the database  This can either be because the user you setup is wrong  doesn t have remote access enabled  if needed   or the ports are not opened  if needed   among many other reasons but these being the most common   Once you have verified that you can access the database using SSMS  The next step  just for the sake of automating the process and avoiding mistakes  is to let the system do the work for you    Start up an empty project  add your choice of Linq to SQL or Dataset  EF is good but the connection string is embedded inside of an EF con string  I want a clean one   and connect to your database using the details verified above in the con string wizzard  Add any table and save the file    Now go into the web config  and magically  you will see nice clean working connection string there with all the details you need       Below was part of an old post so you can ignore this  I leave it in for reference as its the most basic way to access the database from only code behind  Please scroll down and continue from step 2 below     Lets assume the above steps start you off with something like the following as your connection string in the code behind   string conString    Data Source localhost Initial Catalog YourDataBaseName Integrated Security True      This step is very important  Make sure you have the above format of connection string working before taking the following steps  Make sure you actually can access your data using some form of sql command text which displays some data from a table in labels or text boses or whatever  as this is the simplest way to do a connection string   Once you are sure the above style works its now time to take the next steps   1  Export your string literal  the stuff in the quotes  including the quotes  to the following section of the web config file  for multiple connection strings  just do multiple  lines    lt configuration gt       lt connectionStrings gt           lt add name  conString  connectionString  Data Source localhost Initial Catalog YourDataBaseName Integrated Security True   providerName  System Data SqlClient    gt           lt add name  conString2  connectionString  Data Source localhost Initial Catalog YourDataBaseName Integrated Security True   providerName  System Data SqlClient    gt           lt add name  conString3  connectionString  Data Source localhost Initial Catalog YourDataBaseName Integrated Security True   providerName  System Data SqlClient    gt       lt  connectionStrings gt   lt  configuration gt      The above was part of an old post  after doing the top 3 steps this whole process will be done for you  so you can ignore it  I just leave it here for my own reference       2  Now add the following line of code to the C  code behind  prefrably just under the class definition  i e  not inside a method   This points to the root folder of your project  Essentially it is the project name  This is usually the location of the web config file  in this case my project is called MyProject   static Configuration rootWebConfig   WebConfigurationManager OpenWebConfiguration   MyProject      3  Now add the following line of code to the C  code behind  This sets up a string constant to which you can refer in many places throughout your code should you need a conString in different methods   const string CONSTRINGNAME    conString     4  Next add the following line of code to the C  code behind  This gets the connection string from the web config file with the name conString  from the constant above   ConnectionStringSettings conString   rootWebConfig ConnectionStrings ConnectionStrings CONSTRINGNAME     5  Finally  where you origionally would have had something similar to this line of code   SqlConnection con   new SqlConnection conString    you will replace it with this line of code   SqlConnection con   new SqlConnection conString ConnectionString    After doing these 5 steps your code should work as it did before  Hense the reason you test the constring first in its origional format so you know if it is a problem with the connection string or if it is a problem with the code   I am new to C   ASP Net and Sql Server  So I am sure there must be a better way to do this code   I also would appreicate feedback on how to improve these steps if possible  I have looked all over for something like this but I eventually figured it out after many weeks of hard work  Looking at it myself  I still think  there must be an easier way   I hope this is helpful

[asp.net] Setting up connection string in ASP.NET to SQL SERVER

Examples related to asp.net

Examples related to web-config

Examples related to connection

Examples related to connection-string