[dhanavelraj]

Hi,
I am new to this development,now i am doing a project,in which having doubt about how to connect the SQL database by using Application config file.
plz help me....

[dinkar_bhingarde]

dhanavelraj, on 22 Jun, 2009 - 11:45 PM, said:

Hi,
I am new to this development,now i am doing a project,in which having doubt about how to connect the SQL database by using Application config file.
plz help me....

add following code in app.config

<connectionStrings>
<add name="WCFHugeDataserver.Properties.Settings.ServerTestConnectionString"
connectionString="Data Source=servername;Initial Catalog=databasename;User ID=sa;Password=password"
providerName="System.Data.SqlClient" />
</connectionStrings>

get connection string in .cs file by using following lin of code

global::WCFHugeDataserver.Properties.Settings.Default.ServerTestConnectionString


Hope this will help u!
Cheers!

[masteryee]

Another way to do this is:

using System.Configuration;
...
ConnectionStringSettings connStringObj =
   ConfigurationManager.ConnectionStrings["name"]; // "name" = name of the connection string in the config file.
string connString = connStringObj.ConnectionString;
...

You will need to Add a Reference to your project to the System.configuration component. This can be found under the .NET tab in the "Add Reference" window.