Question

C# 与 SQL SERVER 的连接字符串

using System.Data.SqlClient;

private SqlConnection sqlCon;
private String server = "server = .; uid = sa ;pwd = sa ;database = yourDb";

sqlCon = new SqlCoonection();
sqlCon.ConnectionString = server;
sqlCon.open();

我现在的连接字符串 server = .; uid = sa ;pwd = sa ;database = yourDb 我想问下 还又没其他的写法？？？

Answer 1

data source=(local);initial catalog=Master;Integrated Security=SSPI
server相等 data source 可以用(local)，“.”，或者IP
initial catalog 相等 database
Integrated Security=SSPI windows登陆

其他写法：
server = .; uid = sa ;pwd = sa ;database = Master 想法很多种

Answer 2

server = .; uid = sa ;pwd = sa ;database = yourDb
把sever=localhost也可以

Answer 3

server = 远程地址; uid = sa ;pwd = sa ;database = yourDb

Answer 4

请问server=后面应该写什么内容 还有创建数据源后是不是可以c#写代码直接访问数据库内容？我是菜鸟哈 请多多帮帮忙哈 在做网络数据库 遇到链接问题不懂处理

Answer 5

用SqlDataSource控件