特急!!!获取DataSet单个值 (未将对象引用设置到对象的实例。)
protected void Page_Load(object sender, EventArgs e)
{
DataSet dt = new DataSet();
dt = show_data("select top 1 * from " + merchandise_name + " order by 推荐指数 desc");
string filepath= dt.Tables["图书"].Rows[0][7].ToString();
}
public DataSet show_data(string sql)
{
string accessstring = access_connection + Server.MapPath("App_Data/Pei.mdb");
OleDbConnection conn = new OleDbConnection(accessstring);
conn.Open();
OleDbDataAdapter apater = new OleDbDataAdapter(sql, conn);
DataSet dataset = new DataSet();
apater.Fill(dataset);
apater.Dispose();
conn.Close();
return dataset;
}