C 数据库连接字符串集合Sql 验证Windows 身份验证.docVIP

C# 数据库连接字符串集合（Sql 验证/Windows 身份验证） c# 2010-12-20 15:23:20 阅读169 评论0 字号：大中小 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对象:public void OleDBConn