Question

在asp.net里怎么调用access数据库中表的后几条内容显示到前台页面 ？？

Answer 1

/// <summary>
/// 查询后5条数据
/// </summary>
/// <returns></returns>
public static DataSet alldydoc()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 5 * ");
strSql.Append(" FROM dydoc ");
strSql.Append(" order by id desc");
return Query(strSql.ToString());
}

/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.OleDb.OleDbException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}
///连接语句
public static string connectionString = ""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库;

///页面调用用一个repeter就可以了，