读书人

ConnectionString 属性尚无初始化

发布时间: 2011-12-26 23:09:58 作者: rapoo

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();

}


}

[解决办法]
兄台,你是如何调用这个类的,请把调用方法写一下。

读书人网 >asp.net

热点推荐