一：c#连接sql数据库 datasource=myserveraddress;initial catalog=mydatabase;userid=myusername;password=mypassword; datasource=190.190.200.100,1433;network library=dbmssocn;initialcatalog=mydatabase;user id=myusername;password=mypassword; ser
一：c#连接sql数据库
datasource=myserveraddress;initial catalog=mydatabase;userid=myusername;password=mypassword;
datasource=190.190.200.100,1433;network library=dbmssocn;initialcatalog=mydatabase;user id=myusername;password=mypassword;
server=myserveraddress;database=mydatabase;userid=myusername;password=mypassword;
trusted_connection=false;
server=myserveraddress;database=mydatabase;trusted_connection=true;
server=myservernametheinstancename;database=mydatabase;trusted_connection=true;
datasource=myserveraddress;initial catalog=mydatabase;integrated security=sspi;
1:integrated security参数
当设置integrated security为 true 的时候，连接语句前面的userid, pw 是不起作用的，即采用windows身份验证模式。
只有设置为 false 或省略该项的时候，才按照 userid, pw 来连接。
integratedsecurity 还可以设置为：sspi,相当于true,建议用这个代替true.
datasource=myserveraddress;initial catalog=mydatabase;integrated security=sspi;
datasource=myserveraddress;initial catalog=mydatabase;integrated security=true;
datasource=myserveraddress;initial catalog=mydatabase;;userid=myusername;
password=mypasswordintegrated security=false;
2:参数trusted_connection
trusted_connection=true,将使用当前的 windows 帐户凭据进行身份验证
trusted_connection=false;将不采用信任连接方式(也即不采用windows验证方式)，而改由sql server 2000验证方式
server=myserveraddress;database=mydatabase;userid=myusername;
password=mypassword;trusted_connection=false;
server=myserveraddress;database=mydatabase;trusted_connection=true;
3:initial catalog是你要连接的数据库的名字
4:wince连接
datasource=myserveraddress;initial catalog=mydatabase;integrated security=sspi;userid=mydomainmyusername;password=mypassword;
二：可以利用sqlconnectionstringbuilder,这样不必去记住名称。
sqlconnectionstringbuilder scsb = new sqlconnectionstringbuilder();
scsb.datasource =@(local)sqlexpress;
scsb.integratedsecurity = true;
scsb.initialcatalog = northwind;
sqlconnectionmyconnection = new sqlconnection(scsb.connectionstring);
三：可以利用属性中的setting来自动设置连接字符串
1:在type中选择(connection string)，
2:在datasouce中选择数据源，，然后再server中输入服务器名，本地用(local)sqlexpress
3:选择登陆验证方式，本次选windows验证(即信任连接integratedsecurity=true)
4:选择数据库名，确认即可
datasource=(local)sqlexpress;initial catalog=northwind;integrated security=true
server =.sqlexpress;integrated security = true;database = northwind
最后附上一个我自己的测试用例：
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
using system.data;
using system.data.sqlclient;
namespace connectdb
{
class program
{
static void main(string[] args)
{
sqlconnection sqlcon = new sqlconnection();
sqlcon.connectionstring = data source=servername;initial catalog=databasename;integrated security=sspi;
sqlcon.open();
sqlcommand sql_command = new sqlcommand();
sql_command.commandtext = query text;
sql_command.connection = sqlcon;
sqldataadapter dbadapter = new sqldataadapter(sql_command);
dataset dbset = new dataset();
dbadapter.fill(dbset);
//dbset.getxml();
console.writeline(dbset.getxml()。tostring());
sqlcon.close();
console.read();
}
}
}