Database connection string

Database connection

1. Add a connection within the file App. Config

1 <?XML version= "1.0" encoding= "Utf-8"?>2 <Configuration>3   <connectionStrings>4     <!--Database Authentication -5     <Addname= "Database1connectionstring"6 connectionString= "Data source=dbservername1;initial catalog=adventureworks2008; User Id=sa; Password=abc123 "7 ProviderName= "System.Data.SqlClient" />8     <!--Windows Integrated Authentication -9     <Addname= "Database2connectionstring"Ten connectionString= "Data source=dbservername2;initial catalog=northwind;integrated security=true" One ProviderName= "System.Data.SqlClient" /> A </Configuration>

2. Adding DLL references

3. Get the database connection string

string constr = system.configuration.configurationmanager.connectionstrings["  database1connectionstring"]. ToString ();