c#连接数据库sql的几种方式
c#连接数据库sql几种方式
首先引用
using System.Data;
using System.Data.SqlClient;
using System.Data.Odbc;
1.sa连接
//1.sa连接
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
scsb.DataSource = ".";//本地
scsb.UserId = "sa";
scsb.Password = "123456789";
scsb.InitialCatalog = "Demo_db";
//or
scsb.ConnectionString = "Data Source=.;Initial Catalog=Demo_db;User ID=sa;Password = 123456789;"
//or
scsb.ConnectionString = "server=.;database=Demo_db;uid=sa;pwd = 123456789;"
2.windows连接
//直接定义字符串
string strconn = "Data Source=.;Initial Catalog=stu_db;Integrated Security=True";