c# mysql 连接串_C#数据库连接字符串

sa登陆：

"Data Source=.;Initial Catalog=数据库;User ID=sa,pwd=;";

windows登陆

Data Source=.;Initial Catalog=数据库;Integrated Security=True

c#数据库连接字符串集合

(一)常用连接:

1.使用SqlConnection对象:

a. Sql 验证

public void SqlConnectionOpen()

{

SqlConnection conn= new SqlConnection();

conn.ConnectionString = "user id=sa;password=;initial catalog=northwind;datasource=localhost;connect Timeout=20";

conn.Open();

}

b. Windows 身份验证

public void SqlConnectionOpen()

{

SqlConnection conn= new SqlConnection();

conn.ConnectionString = "Integrated Security=SSPI；initial catalog=northwind;datasource=localhost;connect Timeout=20";

conn.Open();

}

2.使用OleDbConnection对象: