SqlConnection小问题

[j20j]

SqlConnection con=new SqlConnection(connectionstring);
那个connectionstring具体怎么写啊
"Data Source=localhost;Initial Catalog=master;User Id=sa;Password=;"这样行吗



出现如下异常：
System.ArgumentException: 从索引 66 处开始，初始化字符串的格式不符合规范。
at System.Data.Common.DBConnectionString.GetKeyValuePair(Char[] connectionString, Int32 currentPosition, String& key, Char[] valuebuf, Int32& vallength, Boolean& isempty)
at System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at WebService1.Service1.CreateDataSet() in i:\my documents\visual studio projects\webapplication\webservice1\service1.asmx.cs:line 60

[_jfeng]

建议你先用sqlconnnection控件生成字符串，然后拷过来用就可以了

[luyiping]

http://www.connectionstrings.com/

[一半乐事]

一个例子
data source=xxxx;initial catalog=xxxx;password=xxxx;persist security info=True;user id=xxxx;workstation id=xxxx;packet size=4096

[Mypiger]

private const String connSQL="user id=sa;password= ;data source=localhost;DataBase=数据库";

[wangdequan1024]

string connectionstring="server=数据库名;UID=登录数据库的用户名;PWD=密码;DATABASE=数据库中要使用的表名;connect timeout=120"