Fill: SelectCommand.Connection 属性尚未初始化。
行 71: System.Data.DataSet ds = new DataSet();
行 72: System.Data.SqlClient.SqlDataAdapter ad = new SqlDataAdapter(sqlst, this._Connect);
行 73: ad.Fill(ds);
行 74: return ds;
行 75: }源文件: E:ss\DB_Con.cs 行: 73
--------------------------------------
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.SqlClient;/// <summary>
/// DB_Con 的摘要说明
/// </summary>
public class DB_Con
{
private string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//string connStr = System.Configuration.ConfigurationManager.AppSettings["ConnStr"].ToString();
private SqlConnection _Connect = null;
public DB_Con()
{ try
{
_Connect = new SqlConnection(connStr);
if (_Connect.State != ConnectionState.Open)
{
_Connect.Open();
} }
catch
{ }
} public void dbclose()
{
if (_Connect.State == ConnectionState.Open)
{
_Connect.Close();
}
} /// <summary>
/// 查寻SQL语句,若有记录则为真,否则是假(传参数)
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public bool ifexist(string sql)
{
if (this.GetDataset(sql).Tables[0].Rows.Count == 0)
{
return false;
}
else
{
return true;
} } /// <summary>
/// 返回DATASET的数据集
/// </summary>
/// <param name="sqlst">查询的语句</param>
/// <returns></returns>
public DataSet GetDataset(String sqlst)
{
System.Data.DataSet ds = new DataSet();
System.Data.SqlClient.SqlDataAdapter ad = new SqlDataAdapter(sqlst, this._Connect);
ad.Fill(ds);
return ds;
}
望大家赐教 这什么情况
行 71: System.Data.DataSet ds = new DataSet();
行 72: System.Data.SqlClient.SqlDataAdapter ad = new SqlDataAdapter(sqlst, this._Connect);
行 73: ad.Fill(ds);
行 74: return ds;
行 75: }源文件: E:ss\DB_Con.cs 行: 73
--------------------------------------
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.SqlClient;/// <summary>
/// DB_Con 的摘要说明
/// </summary>
public class DB_Con
{
private string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//string connStr = System.Configuration.ConfigurationManager.AppSettings["ConnStr"].ToString();
private SqlConnection _Connect = null;
public DB_Con()
{ try
{
_Connect = new SqlConnection(connStr);
if (_Connect.State != ConnectionState.Open)
{
_Connect.Open();
} }
catch
{ }
} public void dbclose()
{
if (_Connect.State == ConnectionState.Open)
{
_Connect.Close();
}
} /// <summary>
/// 查寻SQL语句,若有记录则为真,否则是假(传参数)
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public bool ifexist(string sql)
{
if (this.GetDataset(sql).Tables[0].Rows.Count == 0)
{
return false;
}
else
{
return true;
} } /// <summary>
/// 返回DATASET的数据集
/// </summary>
/// <param name="sqlst">查询的语句</param>
/// <returns></returns>
public DataSet GetDataset(String sqlst)
{
System.Data.DataSet ds = new DataSet();
System.Data.SqlClient.SqlDataAdapter ad = new SqlDataAdapter(sqlst, this._Connect);
ad.Fill(ds);
return ds;
}
望大家赐教 这什么情况
SqlDataAdapter dAdapt =
new SqlDataAdapter("Select * From Tb", cnStr);
dAdapt.Fill(ds);
<add name="ConnectionString" connectionString="Server=xxx; Port=3306; Database=../sql/about.mdf; uid=sa; pwd=lokfff;" />
</connectionStrings>
_Connect.ConnectionString = connStr;
这个管道都没初始化。 你只打开了连接,没建立填充管道,
老师常说的,你打开了水龙头,没把水导入到水池,连接池没开。
{
_Connect = new SqlConnection(connStr);
if (_Connect.State != ConnectionState.Open)
{
_Connect.Open();
}单步跟踪try 看到底是出错了没有连接对象还是……
下面的方法你可参考一下
private static SqlConnection _Connect;
public class DB_Con
{
get {
private string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
if (_Connect == null)
{
_Connect = new SqlConnection(connStr);
_Connect.Open();
}
else if (_Connect.State == ConnectionState.Closed)
{
_Connect.Open();
}
else if (_Connect.State == ConnectionState.Broken)
{
_Connect.Close();
_Connect.Open();
}
return _Connect;
}
}
/// <summary>
/// 返回DATASET的数据集
/// </summary>
/// <param name="sqlst">查询的语句</param>
/// <returns></returns>
public DataSet GetDataset(String sqlst)
{
System.Data.DataSet ds = new DataSet();
SqlCommand com = new SqlCommand(sqlst), _Connect);
System.Data.SqlClient.SqlDataAdapter ad = new SqlDataAdapter(com);
ad.Fill(ds);
return ds;
}