F:\www.lemongtree.com\bll\BLL\admin.cs(21): “LemongTree.BLL.Admin.admin.dbLayerddddddd”表示“字段”,此处应为“类”
db也只是一个简单的数据访问类
ExecuteDataTable方法
不管怎么生成都出错,是什么原因??
using System;
using System.Data;
using LemongTree.DbLayer;
namespace LemongTree.BLL.Admin
{
/// <summary>
/// admin 的摘要说明。
/// </summary>
public class admin
{
private LemongTree.DbLayer.DbAccess dbLayerddddddd = new DbAccess(false);
public admin()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static DataTable sourceList()
{
string sql = "select * from [location] order by id desc";
return dbLayerddddddd.ExectueDataTable(sql,"tbllocation"); //这里出错
}
}
}
using System.Data;
using LemongTree.DbLayer;
namespace LemongTree.BLL.Admin
{
/// <summary>
/// admin 的摘要说明。
/// </summary>
public class admin
{
private LemongTree.DbLayer.DbAccess dbLayerddddddd = new DbAccess(false);
public admin()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static DataTable sourceList()
{
string sql = "select * from [location] order by id desc";
return dbLayerddddddd.ExectueDataTable(sql,"tbllocation"); //这里出错
}
}
}
db也只是一个简单的数据访问类
ExecuteDataTable方法
/// <summary>
/// 返回一个DataTable
/// </summary>
/// <param name="sql"></param>
/// <param name="tableName">表名</param>
/// <returns></returns>
public DataTable ExectueDataTable(string sql,string tableName)
{
OleDbDataAdapter da = new OleDbDataAdapter(sql,this._conn);
DataSet dst = new DataSet();
da.Fill(dst,tableName);
return dst.Tables[tableName];
}
/// 返回一个DataTable
/// </summary>
/// <param name="sql"></param>
/// <param name="tableName">表名</param>
/// <returns></returns>
public DataTable ExectueDataTable(string sql,string tableName)
{
OleDbDataAdapter da = new OleDbDataAdapter(sql,this._conn);
DataSet dst = new DataSet();
da.Fill(dst,tableName);
return dst.Tables[tableName];
}
不管怎么生成都出错,是什么原因??