Quickly create databound grid apps with ComponentOne True DBGrid® for WinForms. This .NET grid control features fast data access and data presentation such as Excel-like split views, grouping, filtering, exporting, printing and customized navigation. Get loads of features by just setting a few properties.
Controls Included
- C1TrueDBGrid is a full-featured grid control with dozens of advanced features spanning data access, data presentation and the user interface.
- C1TrueDBDropDown is a multi-column drop-down list box for a C1TrueDBGrid column.
Features
-
Universal .NET Data Binding
True DBGrid can bind to any .NET data source with little or no code, allowing you to create a fully-navigational database browser in seconds.
-
Child Grids
True DBGrid allows you to display a master/child relationship between data sources in such a way that the child data records are available from within the master table in a completely new True DBGrid. By simply setting the ChildGrid property to connect two grid controls and a few lines of code, you can create a fully editable drop-down child that appears within the master table with a simple click. There is no limit to the number of levels True DBGrid can handle.
-
Cell Merging
If the underlying grid data is sorted, the readability of the display may be improved by merging adjacent like-valued cells within the sorted column(s). The column's Merge property can be set to None, Free or Restricted, which combines like values in adjacent rows only in the same row span as the previous column.
-
Filter Bar
Implement custom end-user operations such as incremental search and record set filtering using a filter bar. To turn on filtering you simply set the AllowFiltering property. Enable traditional text input filtering or provide a drop-down of all possible values for any field. You can also specify watermarks on the filter input fields.
-
Conditional Filtering
C1TrueDBGrid also supports conditional filtering as an alternative to the filterbar. With conditional filtering a drop-down appears when the user hovers over any column header with conditional filtering enabled. The built-in filters include a value filter (checkboxes) as well as conditions such as "Greater than" or "Contains." This type of filtering is modeled after the same feature in C1FlexGrid.
-
AutoComplete
Enhance data entry with the AutoDropdown and AutoComplete properties. As the end-user types into a cell, a dropdown can display and auto fill the edit portion with a matched entry; just like in Excel.
-
Cell Presentation
Use in-cell objects for better data display and editing in the grid, including comboboxes, buttons, check boxes, and radio buttons. If the number of allowable values for a column is relatively small, consider a radio button presentation. A default value item can be declared that will be selected when the underlying value does not match an available value.
-
Drop-down Controls
True DBGrid offers a wide variety of built-in controls that enable you to implement virtually any kind of drop-down cell editing interface. Display value options in the built-in combo box which includes sorting and value translation. Or use the separate multicolumn control, C1TrueDBDropDown, to display a data-bound drop down list of items in any column.
-
Conditional Formatting
Apply different styles to individual cells depending upon their contents. For example, show negative numbers in red, or fields containing a particular substring in bold.
-
Grouping
True DBGrid supports a GroupBy DataView which enables standard Microsoft Outlook-style grouping. GroupBy view contains a grouping section above the grid where columns can be dragged. Dragging a column to this area sorts and groups the rest of the grid by this column. You can also perform grouping programmatically and even expand and collapse grouped nodes in code.
-
Grouping Aggregates
Display computed totals for grouped rows. True DBGrid includes many built-in aggregations you can apply by only setting one property per column. The aggregate types include Count, Sum, Average, Min, Max, Standard Deviation, Variance, and Custom.
-
Grouping Intervals
It's common to need grouping by intervals, rather than grouping solely on unique values. True DBGrid supports several built-in interval grouping types, which allow you to group rows alphabetically, by month, year, datespan, or even provide your own custom grouping logic. For example, you can define group intervals based upon specific value ranges (0-10, 11-35, 36-99, etc.).
-
Inverted Data View
True DBGrid includes a DataView property which enables you to easily toggle between several views. The inverted option of the DataView property inverts each row in your data into columns. In effect, the leftmost column becomes the top row, the second column becomes the second row, and so forth. Use this display to maximize screen real estate for tables that have many columns. Horizontal cell merging is also supported in this view.
-
Hierarchical Data View
True DBGrid supports the ability to display hierarchical data. Hierarchical data generally refers to data that is stored in multiple relational tables, where a master (or "parent") table is linked by keyed fields to detail (or "child") tables. The hierarchical display provides the ability to present the master data to users, such that the related detail data can be viewed in the same grid with a single mouse click.
-
Multi-line Data Views
Display any number of lines per data row by simply setting the DataView and LinesPerRow properties. Setting the True DBGrid to Multi-line data views enables the end user to simultaneously view all of the columns of a record within the width of the grid without scrolling horizontally. Column headers can even span multiple lines for better visibility to the end user.
-
Form Data View
True DBGrid also includes a Form data view. Form view shows each record in a Form-like view that is optimal for data-entry. As the user clicks to scroll horizontally the grid traverses the recordset. Effortlessly give end-users multiple ways to view and edit tabular data. To go from this view to any of the other 6 data views simply set the DataView property.
-
Reorder Columns
Allow the end-user to reorder columns by just setting the AllowColMove property to True. True DBGrid provides visual cues for dragging and dropping column headers, so it's very easy for end-users to do.
-
Frozen Columns
Create fixed (frozen), nonscrolling columns anywhere in the grid – create a fixed left or right-most column or even to fix a column in the middle of the grid. Creating fixed columns is also easy to do with splits.
-
Horizontal and Vertical Splits
Excel-like splits let you split the grid horizontally, vertically, or both. Use splits to present data in multiple horizontal or vertical panes. The splits can scroll as a unit or individually and can display different sets of columns or the same set.
-
Input Masking and Validation
Each column has an EditMask property for automatic input formatting and validation. Setting the input mask for a column will prevent the user from entering any information in the cell that is not in the correct format. This property eliminates having to use custom editors for most data types.
-
Automatic Data Translation
True DBGrid provides a mechanism to map data values into more descriptive display values automatically without code. Alternate text or even pictures can be displayed in place of the underlying data values. This feature is ideally suited for displaying numeric codes or cryptic abbreviations in a way that makes sense to end-users. For example, country codes can be rendered as proper names or even as pictures of their respective flags. Or, the numbers 0, 1, and 2 may be displayed as Yes, No, and Maybe.
-
Microsoft Office Visual Styles
True DBGrid supports Visual Styles that mimic the styles available in Office 2007/2010 including Blue, Silver, and Black.
-
Flexible Style Model
True DBGrid uses a style model that is similar to that of Word and Excel. A style object is a combination of font, colors, gradients, images and all formatting information. The Styles collection editor allows you to fully customize every piece of the True DBGrid including the header, footer, caption, selected row, highlighted row, alternating row, record selector, filter bar, group row and more.
-
Run-time Cell Tips
Provide context-sensitive help for end-users by showing cell tooltips when the user's mouse hovers over the grid.
-
Scroll Tracking and Scroll Tips
Enable deferred scrolling by simply setting the ScrollTrack property to false, and no scrolling will occur until the thumb is released. True DBGrid also supports Scroll Tips, which are essentially tooltips that display as the user scrolls to provide information relating to the current record.
-
Print Preview
True DBGrid fully integrates with ComponentOne Print Preview controls, so you get instant previewing, exporting and printing capabilities without any additional coding. Enable print preview features such as zoom, fit in window, page thumbnails, page orientation, margins, and text search. True DBGrid even includes many special printing options including the ability to repeat grid headers on each page. Plus, you can directly export the document to a variety of formats including Excel, PDF, HTML, rich text, and more.
-
Export Formats and Options
Allow users to export True DBGrid to many formats including PDF, Excel (.xls and .xlsx), Word (.docx), RTF, HTML, TIFF, PNG, JPEG, GIF, BMP, and even our performance enhanced C1 Document type. You can also easily add page headers and footers to the output file and set many special export and print options for more flexibility.
-
Unbound Grids and Columns
True DBGrid supports unbound columns and even enables fully unbound grids. An unbound column refers to a column that is part of a bound grid, but is not tied directly to a database field. For example, if your database contains a Balance field, you may instead want to display two columns, Credit and Debit, to show positive and negative numbers separately. Or, you may want to look up data in another database, or convert field data to some other form, such as mapping numeric codes to textual descriptions.
-
Extensive Design-time Support
Design-time features, including SmartTags and full-featured editors allow you to intuitively create grid applications with little or no coding.