ConnectionString 属性尚未初始化
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data .OleDb ;
/// <summary>
/// Socut 的摘要说明
/// </summary>
public class Socut
{
private string SConnString;
public Socut()
{
SConnString = GetConnString();
}
protected static string GetConnString()
{
return (ConfigurationSettings .AppSettings [ "SocutConnectionString "]);
}
public OleDbConnection getcn()
{
OleDbConnection con=new OleDbConnection (SConnString );
return con;
}
public void GetExecuteNonQuery(string Query)
{
OleDbConnection cn=getcn ();
cn.Open ();
OleDbCommand SDbcommand=new OleDbCommand (Query ,cn);
SDbcommand .ExecuteNonQuery ();
}
public DataSet GetDataSet(string sql,int statindex,int num,string dataname)
{
OleDbConnection cn=getcn ();
cn.Open ();
OleDbCommand SDbcommand=new OleDbCommand (sql ,cn);
OleDbDataAdapter SDataAdapter=new OleDbDataAdapter (SDbcommand );
DataSet SDataSet=new DataSet ();
SDataAdapter .Fill (SDataSet ,statindex ,num ,dataname );
return SDataSet;
}
public OleDbDataReader Read(String sql)
{
OleDbConnection cn = getcn();
cn.Open();//错误,说ConnectionString 属性尚未初始化
OleDbCommand SDbcommand = new OleDbCommand(sql, cn);
return SDbcommand.ExecuteReader();
}
}
web.config中是
<connectionStrings>
<add name= "SocutConnectionString " connectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\www\Data\Socut.mdb " providerName= "System.Data.OleDb "/>
</connectionStrings>
求哪位朋友解决!谢谢!
[解决办法]
你检查一下在执行getcn 之前的SConnString
可能就是这里出错了
[解决办法]
web.config中是
<connectionStrings>
<appSettings>
<add name= "SocutConnectionString " connectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\www\Data\Socut.mdb " providerName= "System.Data.OleDb "/>
</appSettings>
</connectionStrings>
这样试试
[解决办法]
GetExecuteNonQuery
GetDataSet
这两个方法都没有关闭连接
[解决办法]
public class Socut
{
public OleDbConnection getcn()
{
string connString=WebConfigurationManager.ConnectionStrings[SocutConnectionString]. ConnectionString;
OleDbConnection con=new OleDbConnection (connString);
return con;
}
public void GetExecuteNonQuery(string Query)
{
OleDbConnection cn=getcn ();
cn.Open ();
OleDbCommand SDbcommand=new OleDbCommand (Query ,cn);
SDbcommand .ExecuteNonQuery ();
}
public DataSet GetDataSet(string sql,int statindex,int num,string dataname)
{
OleDbConnection cn=getcn ();
cn.Open ();
OleDbCommand SDbcommand=new OleDbCommand (sql ,cn);
OleDbDataAdapter SDataAdapter=new OleDbDataAdapter (SDbcommand );
DataSet SDataSet=new DataSet ();
SDataAdapter .Fill (SDataSet ,statindex ,num ,dataname );
return SDataSet;
}
public OleDbDataReader Read(String sql)
{
OleDbConnection cn = getcn();
cn.Open();//错误,说ConnectionString 属性尚未初始化
OleDbCommand SDbcommand = new OleDbCommand(sql, cn);
return SDbcommand.ExecuteReader();
}
}
[解决办法]
兄台，你是如何调用这个类的，请把调用方法写一下。
