I thought you might be interested in WiredNav, which has just been released by Mabry Software. WiredNav is an innovative self-wiring .NET control that I authored for filling, navigating, searching, updating, and reporting ADO.NET data tables. You can use the control in database applications without making any initial property settings or writing a single line of code.
There are no DataAdapter, DataSet, DataSource, or DataTable properties for the control. At runtime, the navigator automatically wires itself to every data object found on the Windows form to which it is added. With this technique, you only need one navigator per form instead of one per data table. WiredNav can be used with SQL, Oracle, OLEDB, and ODBC data adapters.
Along with the Windows Forms DataGrid control, WiredNav can connect to your favorite third-party grids:
- ComponentOne Flex Grid for .NET
- ComponentOne True DBGrid for .NET
- Infragistics UltraWinGrid
- Janus GridEX Control for .NET
- Xceed Grid for .NET
I designed WiredNav to address many of the data binding and other disconnected data problems that I’ve read about on this message board. In addition to self-wiring, WiredNav has the following features:
- Automatic data control switching for navigating and updating
- Data table filling based on selection criteria
- Regular, transaction, and automatic source table updating
- Update results lists with total rows modified, added, and deleted
- Update error lists with error resolution when updates fail
- Row search based on primary key values or other search criteria
- Report printing and viewing with table filtering
- Selection criteria saving when filling, searching, and reporting data tables
- Time-saving date codes for common date values used in selection criteria
- Text validation for TextBox and ComboBox input controls with error providers
- Customizable navigator bar with section hiding
- Auto-incrementing key value retrieval for SQL Server, Oracle, and Access 2000
- Globally unique identifier (GUID) value generation for UniqueIdentifier columns
- Navigator buttons context menu with customizable shortcut keys
If you build database applications using ADO.NET, you should check out WiredNav. I think this is how Microsoft envisioned disconnected data would be handled. A trial copy of WiredNav can be downloaded from Mabry’s web site at www.mabry.com.