Question

C#中连接SQL数据库的语句是什么？

Answer 1

Data Source=服务器名:Initial Catalog=数据库名;User ID=用户名;Pwd=密码；
例如:string connString="Data Source=.;Initial Catalog=pubs;User ID=sa"

第二种:Server=(. 或者 local);Database=数据库名;uid=sa;pwd=sa

Answer 2

string ConnectionString = "Server=(local);DataBase=数据库名;User ID=sa;PWD="; SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();

Answer 3

string ConnectionString = "Server=(local);DataBase=Gdd0005;User ID=sa;PWD="; SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();

追问

string sql = String.Format("insert into FamilyUser values('{0}','{1}')", txtName.Text.Trim(), txtPassWord.Text.Trim()); string connString = "Data Source=./SQLEXPRESS;AttachDbFilename=F:/2011年暑假/Family/Family/data/FamilyFinace.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection con = new SqlConnection(connString);
con.Open();我这样写为什么打不开数据库？