C#连接SQL Server
关于C#连接数据库的介绍,这篇文章总结的比较全面。http://blog.csdn.net/candy1232009/article/details/7654927
对于C#连接MS SQL Server,主要使用sqlconnection。认证方式主要采用windows集成认证方式或者SQL Server认证模式。连接语句主要如下所示:
string constr = "server=.;database=myschool;integrated security=SSPI";
string constr = "server=.;database=myschool;uid=sa;pwd=sa";
string constr = "data source=.;initial catalog=myschool;uid=sa;pwd=sa";
说明:
参考:http://blog.csdn.net/wyaspnet/article/details/5627334
1) server与data source