我在Winform中连接Sql 2k5始终不成功。
App.config的配置如下:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="connstr"
connectionString="server=(local);uid=sa;pwd=cqchz;database=test"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>数据库连接类的代码如下:public static SqlConnection con()
{
string con_string =
System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString;
SqlConnection conn = new SqlConnection(con_string);
return conn;
}运行以后:Sql 2k5设置如下:
App.config的配置如下:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="connstr"
connectionString="server=(local);uid=sa;pwd=cqchz;database=test"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>数据库连接类的代码如下:public static SqlConnection con()
{
string con_string =
System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString;
SqlConnection conn = new SqlConnection(con_string);
return conn;
}运行以后:Sql 2k5设置如下:
你可以试试!