首先创建一个udl文件，选择链接oledbsqlserver 写上你的信息用户名密码还有所要链接的数据库。
最后改回记事本的格式
从userid那开始复制就是想要的了如果不行看看password是否写上了，没有就补上
具体例子：
远程数据连接
<add name="ConnectionString" connectionString="Data Source=125.39.191.5;Initial Catalog=qishengtest; User id=qishengtxt;password='qingsheng5774'" providerName="System.Data.SqlClient"/>
本地链接
<add name="ConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Database.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
用sqlhelper C#后台查询
1.DataTable companyIdDataTable = sqlhelper.GetTable(System.Data.CommandType.StoredProcedure, "SelectwenbaTosolved", sp); 存储
2.DataTable companyIdDataTable = sqlhelper.GetTable(" SELECT DISTINCT TOP(60) tb_Question.question_Name, tb_Question.question_Question FROM tb_Question INNER JOIN tb_Company ON tb_Question.company_Id = tb_Company.company_Id"); 直接写语句删除和修改或者插入 sqlhelper.ExecuteNonQuery(System.Data.CommandType.StoredProcedure, "ReplayPublish", sp) > 0
ConnectionString 就是sqlhelper所要链接的名
最后改回记事本的格式
从userid那开始复制就是想要的了如果不行看看password是否写上了，没有就补上
具体例子：
远程数据连接
<add name="ConnectionString" connectionString="Data Source=125.39.191.5;Initial Catalog=qishengtest; User id=qishengtxt;password='qingsheng5774'" providerName="System.Data.SqlClient"/>
本地链接
<add name="ConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Database.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
用sqlhelper C#后台查询
1.DataTable companyIdDataTable = sqlhelper.GetTable(System.Data.CommandType.StoredProcedure, "SelectwenbaTosolved", sp); 存储
2.DataTable companyIdDataTable = sqlhelper.GetTable(" SELECT DISTINCT TOP(60) tb_Question.question_Name, tb_Question.question_Question FROM tb_Question INNER JOIN tb_Company ON tb_Question.company_Id = tb_Company.company_Id"); 直接写语句删除和修改或者插入 sqlhelper.ExecuteNonQuery(System.Data.CommandType.StoredProcedure, "ReplayPublish", sp) > 0
ConnectionString 就是sqlhelper所要链接的名
