Connection

go throw this link

http://msdn.microsoft.com/en-us/library/aa480507.aspx[^]

You can use it also
In Web.Config file

<connectionstrings>
    <clear />
    <add name="ConnectionString" connectionstring="Data Source=cql-01\sqlexpress;Initial Catalog=eden_outdoor;Integrated Security=True">
      providerName="System.Data.SqlClient">
  </add>
</connectionstrings>

C# code for access

string CS = WebConfigurationManager.ConnectionStrings[0].ConnectionString;

In the web.config, write this...

<appSettings>
  <add key="connect" value="Server=Server_Name; Integrated Security=true; Database=Database_Name"/>
</appSettings>

In the .cs file, write this...


public SqlConnection con = new SqlConnection();
SqlCommand com = new SqlCommand();
AppSettingsReader appobj = new AppSettingsReader();
string str = appobj.GetValue("connect", typeof(String)).ToString();
con = new SqlConnection(str);
con.Open();



I think it might help you....

<connectionstring>

<add name="DBSource" connectionString="Database=perfact;Server=Amrit;UID=sa;PWD=amrit@123" providerName="System.Data.SqlClient"/>

write the above code in web.config file

add the Code In code behined file e.g con1.aspx

using System.text;
using System.Configuration;
using Mycon;

protect void page_load(object sender, eventArgs e)
{
// to know that connection name DBSource exits or not
lblcon.text=configurationManager.connectionstring["DBSource"].connectionstring;
}

// Make a class in app_code folder

Name it myConnection
and
make a namespace
write the folling code

using System.data;
using System.text;
using System.Configuration.

namespace Mycon // Add this namespace in codebehind file con1.aspx.cs
{
public partial myConnection: classname
{
//Constrotor logic
}
// Make a connection string

public static string connectionstring=configurationManager.connectionstring["DBSource"].connectionstring.
}
//save the file never forgert to add this namespace Mycon in con1.aspx.cs code behind file

In Web.Config file

<connectionStrings>
  <add name="Connectionstring" providerName="System.Data.SqlClient" connectionString ="Data Source=111.11.11.11;Initial Catalog=DBName;User ID=UserID;Password=pass"/>
</connectionStrings>

and in the .cs file
using System.ConfigurationManager;

string str=ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString;