配置文件代码:<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="connString" connectionString="Data Source=(local);Initial Catalog=Test;User ID=sa;Password=sasa"/>
</connectionStrings>
</configuration>static void Main(string[] args)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.AppSettings["connString"];
conn.Open();
SqlCommand cmd = new SqlCommand("select ContactID,FirstName,LastName from Person.Contact where ContactID between 10 and 14", conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Console.WriteLine("ContactID = {0}\tFirstName={1}\tLastName={2}", sdr["ContactID"], sdr["FirstName"], sdr["LastName"]);
}
conn.Close();
}
数据库连接不上,运行结果非理想结果,求解答,谢谢!
<configuration>
<connectionStrings>
<add name="connString" connectionString="Data Source=(local);Initial Catalog=Test;User ID=sa;Password=sasa"/>
</connectionStrings>
</configuration>static void Main(string[] args)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.AppSettings["connString"];
conn.Open();
SqlCommand cmd = new SqlCommand("select ContactID,FirstName,LastName from Person.Contact where ContactID between 10 and 14", conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Console.WriteLine("ContactID = {0}\tFirstName={1}\tLastName={2}", sdr["ContactID"], sdr["FirstName"], sdr["LastName"]);
}
conn.Close();
}
数据库连接不上,运行结果非理想结果,求解答,谢谢!
解决方案 »
- RFID上位机
- xna有前途吗,我是指微软还会不会继续推广支持xna
- webBrowser刷新问题
- 为什么不自动生成资源文件了?
- int FaxTask.Task(string ino,string in1,string in2,string in3,string in4)是什么意思?
- 寻找最优字符替换方案
- 求在VB6中制作标准DLL的步骤方法。我想在VB6中将一些现有的函数制作成DLL,然后在C#中调用这个DLL中的函数。
- 关于C#代码规范
- 班级排名
- 高手进来帮个忙:带有 CLSID {0002E500-0000-0000-C000-000000000046} 的 COM 对象无效或未注册
- 用C#怎么将pdf文件转换成rtf文件
- 新出炉的菜鸟大送分啦,大家过来看啊,先到先得啊^_^
完成后,用记事本打开,就可以看到你的数据库连接字符串了。
1、这样配置的话
<connectionStrings>
<add name="connString" connectionString="Data Source=.;Initial Catalog=Test;User ID=sa;Password=sasa"/>
</connectionStrings>
这样:
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;2、这样配置的话
<appSettings>
<add key="connString" value="Data Source=.;Initial Catalog=Test;User ID=sa;Password=sasa;" />
</appSettings>
这样:
conn.ConnectionString = ConfigurationManager.AppSettings["connString"];
再确认下 连接字符串是否正确