如何将数据库从sql server 2008连接到visual studio 2008。

问题描述：

我在sql server 2008中创建了数据库。

现在，我想要在Visual Studio 2008中附加该数据库。

plz写ConnectionString和web.config连接。

谢谢。

Hi,

I hv created database in sql server 2008.

now, i want to attach that database in visual studio 2008.

plz write ConnectionString and web.config connection.

Thanks.

答

hi，

写入web.config文件。

如果sql身份验证：

Write in web.config file.

if sql authentication :

<connectionStrings>
<add name="myConnectionString" Data Source=serverName;Initial Catalog=myDb;uid=myUser;password=myPass;" />
</connectionStrings>

if windows authentication :
<connectionstrings>
<add name="myConnectionString" connectionstring="Data Source=serverName;Initial Catalog=myDb; Integrated Security=True" />
</connectionstrings>

getting connection string from web.config file.
need to add following namespace

using System.Configuration;

and connect the open the database connection is,

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);


regards,
Prakash.T

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-ac-desktop-app-in-visual-studio-2010 [ ^ ] [ ]

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[^][]

两种方式：

1：使用Appsetting部分

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>

从.CS文件访问此文件试试这个：

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：使用连接字符串部分：

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>

从.CS文件访问此文件试试这个：

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);

如何将数据库从sql server 2008连接到visual studio 2008。

相关推荐