C# 与 SQL SERVER 的连接字符串
来源:百度知道 编辑:UC知道 时间:2024/09/21 11:16:56
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 我想问下 还又没其他的写法???
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 我想问下 还又没其他的写法???
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 想法很多种
server = 远程地址; uid = sa ;pwd = sa ;database = yourDb
请问server=后面应该写什么内容 还有创建数据源后是不是可以c#写代码直接访问数据库内容?我是菜鸟哈 请多多帮帮忙哈 在做网络数据库 遇到链接问题不懂处理
server = .; uid = sa ;pwd = sa ;database = yourDb
把sever=localhost也可以
用SqlDataSource控件
有很多的写法