wwSqlLight DAL = new wwSqlLight(); DataTable table = DAL.ExecuteTable("select * from customers","TCustomers"); this.GridView.DataSource = table; this.GridView.DataBind();Manual step through:
foreach(DataRow row in table.Rows) { Response.Write(row["Company"].ToString() + " " + row["Entered"].ToString("d")); }Ok, that's cheating - ExecuteTable() is a generic function that hides about 15 lines that's reusable <s>... but by using a data single method access wrapper, but one method with 10 lines of code wrapped like this will basically allow syntax like that.
select * from Customers into cursor TCustomers this.dgCustomers.DataSource = "TCustomers" this.dgCustomers.DataBind()Assuming you've added a grid to the page.
SCAN Response.Write( TCustomers.Company + " " + TRANS(TCustomers.Entered) ) ENDSCAN