注册 登录
编程论坛 ASP.NET技术论坛

高手看看为什么老是出现这样的错误?

yeyuanzhi 发布于 2008-08-14 16:13, 1061 次点击
高手看看为什么老是出现这样的错误?
异常详细信息: System.Data.OleDb.OleDbException: 未指定的错误

源错误:


行 27:         {
行 28:
行 29:             conn.Open();
行 30:
行 31:         }

怎么解决?谢谢!!
2 回复
#2
yeyuanzhi2008-08-14 16:13
下面我把源码贴出来,在DB.aspx.cs的源码是这样的:
public class DB
{
    public static OleDbConnection Getconn()
    {
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["ConnectionString"].ToString()));
        if (conn.State.Equals(ConnectionState.Closed))
        {
           conn.Open();
        }
        return conn;
        }
        private static void closeConnection()
    {
        OleDbConnection conn = DB.Getconn();
        OleDbCommand cmd = new OleDbCommand();
        if (conn.State == ConnectionState.Open)
        {
            conn.Close();
            conn.Dispose();
            cmd.Dispose();
        }
    }
public static void binddatalist(string sql, DataList dl)
    {
        try
        {
            OleDbConnection conn = DB.Getconn();
            DataSet ds = getdataset(sql);
            dl.DataSource = ds.Tables[0].DefaultView;
            dl.DataBind();
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);

        }
        finally
        {
            closeConnection();
        }
    }
}
然后在网页的后台引用如下:
string topsql1 = "select top 10 * from info  order by hits,id desc";//教育动态
        DB.binddatalist(topsql1, this.DataList1);
时而可以运行,时而出现上面所说的情况。为什么?怎么解决?谢谢!!
#3
yeyuanzhi2008-08-15 15:51
怎么没人能解答吗?
1