App.config文件如下:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="conStr" connectionString="Data Source=DELL-PC;Initial Catalog=mydb2;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
connTest.cs文件如下:
using System;
using System.ComponentModel;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Drawing;
namespace MyProject
{
public partial class connTest:Form
{
public connTest()
{
InitializeComponent();
}
public string GetConnectionString()
{
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; // 这句报错
if (connStr!= null)
{
return connStr;
}
else
{
return null ;
}
}
private void connTest_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(GetConnectionString());
try
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
label1.Text = "该连接字符串为:\r\n";
label1.Text += GetConnectionString() + "\r\n";
label1.Text += "数据库连接成功";
}
}
catch (Exception ex)
{
label1.Text = ex.Message;
}
finally
{
conn.Close();
}
}
}
}
急救啊
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="conStr" connectionString="Data Source=DELL-PC;Initial Catalog=mydb2;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
connTest.cs文件如下:
using System;
using System.ComponentModel;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Drawing;
namespace MyProject
{
public partial class connTest:Form
{
public connTest()
{
InitializeComponent();
}
public string GetConnectionString()
{
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; // 这句报错
if (connStr!= null)
{
return connStr;
}
else
{
return null ;
}
}
private void connTest_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(GetConnectionString());
try
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
label1.Text = "该连接字符串为:\r\n";
label1.Text += GetConnectionString() + "\r\n";
label1.Text += "数据库连接成功";
}
}
catch (Exception ex)
{
label1.Text = ex.Message;
}
finally
{
conn.Close();
}
}
}
}
急救啊
解决方案 »
- 请教如何把txt中的每一行的值赋值一维数组
- 【求助】关于自定义控件【Button和Textbox】
- 请教简单问题问题!等!
- 各位好,我用的系统是XP,请问如何安装SQL2000企业版??急急急!谁先告诉我,愿以20分相送!!!
- 高手进来指点,和谐社会,共同进步!!!
- 当用鼠标拖动改变ListView的ColumnHeader的宽度的时的事件是什么?
- 如何让一个listbox中的内容可以被选定并复制?哪个属性控制?
- 从一个ICertificate2实例 ,怎么构造一个RSACryptoServiceProvider实例出来
- 类型“OWC10.Workbook”在未被引用的程序集中定义,紧急求救!!!
- 请问高手们,html workshop 怎么使用?请指教!!越具体越好,感激。
- 求助,关于程序外网发布
- C#客户端模拟Https请求,证书验证不通过报错未能为 SSL/TLS 安全通道建立信任关系
providerName="System.Data.SqlClient" />ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; // 这句报错