True DBGrid

True DBGrid

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. Universal .NET Data Binding

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. Child Grids

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. Cell Merging

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. Filter Bar

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. Conditional Filtering

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. AutoComplete

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. Cell Presentation

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. Drop-down Controls

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. Conditional Formatting

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

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 Aggregates

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.). Grouping Intervals

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. Inverted Data 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. Hierarchical Data View

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. Multi-line Data Views

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. Form Data View

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. Reorder Columns

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. Frozen Columns

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. Horizontal and Vertical Splits

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. Input Masking and Validation

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. Automatic Data Translation

Microsoft Office Visual Styles

True DBGrid supports Visual Styles that mimic the styles available in Office 2007/2010 including Blue, Silver, and Black. Microsoft Office Visual Styles

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. Flexible Style Model

Run-time Cell Tips

Provide context-sensitive help for end-users by showing cell tooltips when the user's mouse hovers over the grid. Run-time Cell Tips

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. Scroll Tracking and Scroll Tips

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. Print Preview

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. Export Formats and Options

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. Unbound Grids and Columns

Right-to-left Support

C1TrueDBGrid fully supports RTL (or "right-to-left") layout for Arabic and Hebrew cultures. Just set the RightToLeft property to True. Right-to-left Support

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. Extensive Design-time Support

Resources

Whether you are a customer or just trying us out, we stand behind you. Valuable learning resources such as samples, videos, and forums are free and just a click away.

Ready to start your 30-day, risk-free trial?

Includes free technical support.

Ready to buy?

All licenses are developer-based and there are no limits on the distribution of applications–unlimited, royalty-free, run-time distribution.

Pricing

Need help deciding?

Chat with sales, call or email. We're here to answer all your questions.

1.800.858.2739 | 412.681.4343 sales@componentone.com

Chat with Sales