Andrew Mooney

Loading a dBase/Excel table into a GridView Control in ASP.NET 2.0

To load a dBase table using the AccessDataSource control use the following: DataFile="data;extended properties=dBase IV" SelectCommand="select * from [ACCOUNTS.dbf]" To load an Excel worksheet using the AccessDataSource control use the following: DataFile="data\ACCOUNTS.xls;extended

Access Database Schema with ASP.NET 2.0

The next step in creating My First ASP.NET 2.0 Project is learning how to retrieve Access Database Schema. From database schema alone, there is no way to tell if a column in Access is the AutoNumber type. I have found a simple work around for this short

Editing Access Databases with ASP.NET 2.0

The first step in creating My First ASP.NET 2.0 Project is learning how to use some of the new web server controls like the AccessDataSource, GridView, and Details controls. This article demonstrates their use: Editing Access Databases with ASP.NET 2.0

My First ASP.NET 2.0 Project

My first ASP.NET 2.0 project is going to be a web application that automatically creates view/edit pages for every table in an Access 2000-2003 database (SQL 2005 will come latter). The plan is to make the application open source. I will be using Microsoft