代码如下,运行的时候,总是在DataTable dt 那块显示connectionstring 尚未初始化
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
getGoods();
dataGridView1.Rows.Add(ID, GoodsAmount,Money,DateMonth);
SqlConnection cn1 = new SqlConnection(Properties.Settings.Default.CSConnectionString);
string sql1 = "SELECT ID,DateMonth,SUM(GoodsAmount)AS GoodsAmount,SUM(Money) AS Money FROM GoodsOrder2 WHERE DateMonth like '%" + DateMonth + "%' GROUP BY ID,DateMonth ORDER BY Money";
SqlCommand com = new SqlCommand(sql1, cn1);
cn1.Open(); SqlDataReader dr = com.ExecuteReader();
dr.Read(); DataTable dt = SQLServerOleDBHelper.GetDataTable(sql1);app.config里是这样的:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="CS.Properties.Settings.CSConnectionString" connectionString="Data Source=20110921-1127;Initial Catalog=CS;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="CS.Properties.Settings.db_CSManageConnectionString"
connectionString="Data Source=20110921-1127;Initial Catalog=db_CSManage;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
using 部分是这样的:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;
using DBUtility;
求指点>_<
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
getGoods();
dataGridView1.Rows.Add(ID, GoodsAmount,Money,DateMonth);
SqlConnection cn1 = new SqlConnection(Properties.Settings.Default.CSConnectionString);
string sql1 = "SELECT ID,DateMonth,SUM(GoodsAmount)AS GoodsAmount,SUM(Money) AS Money FROM GoodsOrder2 WHERE DateMonth like '%" + DateMonth + "%' GROUP BY ID,DateMonth ORDER BY Money";
SqlCommand com = new SqlCommand(sql1, cn1);
cn1.Open(); SqlDataReader dr = com.ExecuteReader();
dr.Read(); DataTable dt = SQLServerOleDBHelper.GetDataTable(sql1);app.config里是这样的:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="CS.Properties.Settings.CSConnectionString" connectionString="Data Source=20110921-1127;Initial Catalog=CS;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="CS.Properties.Settings.db_CSManageConnectionString"
connectionString="Data Source=20110921-1127;Initial Catalog=db_CSManage;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
using 部分是这样的:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;
using DBUtility;
求指点>_<
if (connection == null)
{
connection = new SqlConnection(conStr);
connection.Open();
}
ConfigurationManager那里显示上下文中不存在ConfigurationManager"..... ,你升级一下.net framework 吧。
是的,断点看下
还有,Properties.Settings取的是Properties下Settings.settings里面配置的值而非你App.config里面的值
你可以在Settings.settings的添加CSConnectionString这个值
如果你想读App.config里面的值的话按照一楼的方法即可
这个方法干了什么你贴出代码,怎么知道咋回事.