how to connect database from sql server 2008 to visual studio 2008.

http://stackoverflow.com/questions/9538297/connecting-sql-server-2008-r2-with-visual-studio-2010[^][]
http://www.youtube.com/watch?v=P7WmIY1s_Mw[^][]
http://www.connectionstrings.com/sql-server-2008[^][]
http://www.daniweb.com/software-development/csharp/threads/368722/how-to-connect-sql-server-2008-with-a-c-desktop-app-in-visual-studio-2010[^][]

two way you can do it:

1: using Appsetting section

<appsettings><add key="APPConnectionString" value="Data Source=ABC-PC\SQLEXPRESS; Initial Catalog=TEST;Persist Security Info=true;User ID=sa; password=SA" />  </appsettings>

to access this from .CS File try this :

private string sqlConnectionString = null;
   private SqlConnection sqlConn = null;
 sqlConnectionString = ConfigurationManager.AppSettings["APPConnectionString"];
 sqlConn = new SqlConnection(sqlConnectionString);

2: Using connection string Section:

<connectionStrings>
        <add name="test" connectionString="Data Source=ABC-PC\SQLEXPRESS; Initial Catalog=TEST;Persist Security Info=true;User ID=sa; password=sa" providerName="System.Data.SqlClient"/>
    </connectionStrings>

to access this from .CS File try this :

private string sqlConnectionString = null;
    private SqlConnection sqlConn = null; 
        sqlConnectionString = ConfigurationManager.ConnectionStrings["test"].ConnectionString;
        sqlConn = new SqlConnection(sqlConnectionString);

Standard Security

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connection to a SQL Server instance

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

hi buddy..

use the connectionStrings section in web.config.

<connectionstrings>
<add name="myConnectionString" connectionstring="server=localhost;database=yourdbname;User Id=sqlid;password=sqlPass;" />
</connectionstrings>

To read the connection string into your code, use the ConfigurationManager class.

string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

Remember to add reference to web page add the namespace using System.Data.SqlClient; in your code to get access to the ConfigurationManager class.

Thanks
Happy to help...