A custom control, based on the DataGrid, can be created to meet your application's needs. Susan Warren created the Xml Edit Grid, which can be used to edit XML files. The DBVision Grid is based in part on the XML Edit Grid. It adds edit, delete, add new and paging ability to the .NET DataGrid for use with OleDb databases like SQL Server 2000 and Access 2000. The DBVision Grid supports basic data types.
There are only three required properties; DBVConnection(The number of your connection string in the Web.config file - see View Source), DBVTable(The name of the database table to edit), and DataKeyField(The name of the single primary key field; must be integer data type). Additionally, to enable paging you must set the AllowPaging and PageSize properties.
[ Run Sample ] | [ View Source ] | [ Download ]