Building a dynamically ASP.NET 2.0 GridView control

Abstract

Microsoft Visual Studio 2005 (based on ASP.NET 2.0), the successor to Visual Studio .NET 2003 has a lot of new features and goodies designed for Web developers. This article show how a ASP.NET 2.0 control can be dynamically connected to Microsoft Access database. The delete and update operation will be implemented using a GridView control and SQL queries. The connection between the database and the .NET application will be made with OleDb Data provider, the new Access Data Source control. The SQL queries will be implemented with OleDbCommand.

Keywords

• dynamic GridView
• AccessDataSource
• OleDbConnection
• OleDbCommand.