Posts tagged with 'c1truedbgrid'
Presentation is one of the most important features when it comes to managing data in grids. When data are analysed and interpreted, the most challenging part of the job is done but it is far from being over. Just as important is to present and print the data in the right way because even the best interpretation will not achieve its goal if it is not presented in a clear, easy to understand and interesting way. Interactive data visualization goes a step further – moving beyond the display of static spreadsheets to drill down for more details, and interactively (and immediately) changing what data you see and how it is processed.
ComponentOne's TrueDBGrid apart from being robust and persuasive, also provides an accessibility to its users to implement various functionalities which in turn widens the usage of the control. In this blog, we will be discussing one such functionality: Copy and Paste a Cell Range.
ComponentOne TrueDBGrid for WinForms is a robust, easy-to-use .NET grid control that allows you to create complex bound and unbound grid applications quickly. TrueDBGrid for WinForms's strength is data binding; with an ADO.NET managed database interface.
We must have observed many web sites where the sizes of the web pages are automatically adjusted according to the screen resolution they are being displayed on. In this blog, we would be discussing how the same feature can be implemented in a Windows Forms Application and also with a Grid control.
While creating TrueDBGrid it was decided that the control would be light weight, efficient and feature packed. However, it was worthwhile to note that light and feature packed are usually contrary to each other. This was the initial difficulty that we faced, deciding feature over efficiency. Our developers later decided that we won't let this dilemma ruin the development of TrueDBGrid. They replaced a feature heavy control with a flexible and versatile control. This vision was something which made TrueDBGrid a very special control for us.
There are many scenarios where we would want to export data into Excel format. The data could be from multiple ComponentOne TrueDbGrid for WinForms controls or from any other data bound control. However, using a C1TrueDbGrid control's ExportToExcel method we can't export multiple C1TrueDbGrids to a single Excel file.
Exporting data to a PDF file is one of the most commonly preferred features in the .NET world. The essential ComponentOne TrueDbGrid for WinForms control has in-built support for PDF export. ExportToPDF method provides support for exporting data from a C1TrueDbGrid control to a PDF file. However, using ExportToPDF() method we can't export multiple C1TrueDbGrids to a single PDF file.
Cascading dropdown lists can be a generic requirement when it comes to grids. Cascading dropdown means that the contents of one of the dropdown is dependent on the selection made in the other dropdown. MS Excel implements these cascading dropdowns with the help of validation rules.
C1TrueDBGrid supports multiple selections of rows through record selector by setting MultiSelect property to MultiSelectEnum.Simple|MultiSelectEnum.Extended. Some customers want this functionality to be implemented by clicking on the row rather than using the record selector.
C1TrueDBGrid for Winforms can be bound to a database that has different types of values including text, numbers or a combination of both. Sometimes these values are longer than the width of the data column, hence the cell text in this column is simply cut off. It only displays the text that fits the cell width. For example the value 12345.678910 might be displayed as 1234.67 or a bit longer depending on the column width. You would need to enlarge the column width to view the complete text.
Grouping is a common feature found in most of the grids. To apply grouping in C1TrueDBGrid all we need to do is set the DataView property of C1TrueDBGrid to GroupBy. Please refer to the following link to know more about it.
C1TrueDBGrid for Winforms provides various selection methods for selecting Rows using Control Key or Shift Key. For information on available Selection mode, you can refer to this documentation link.
While developing an application using C1TrueDBGrid which is bound to a business object, one may come across a situation when data needs to be displayed in a Hierarchical View. Now, if we need to create a hierarchical-grid-like general user interface in an application, the easiest solution is to assign the grid's DataSource property to the data of interest and let the control take care of the display of data in whichever view we need.
ComponentOne TrueDBGrid for WinForms being a Databound control provides robust filtering options like Value Filtering, Conditional Filtering and Custom Filtering. Along with this it provides FilterBar to input the filtering text for the columns.
Customers using C1TrueDbgrid often find themselves in need of changing the border color of the control. For instance, change the control border when the control has focus. However, there is no property or VisualStyle in C1TrueDbgrid to do this.
ComponentOne TrueDBGrid for WinForms provides an option to view data in different ways through the DataView property. This property supports Hierarchical, Drop-down Hierarchical, Form, Inverted, and multiple line views. Along with this, C1TrueDbGrid also provides the option to filter the data rows with the help of FilterBar available under the Column Headers.
Creating Hierarchical View in C1TrueDbGrid at runtime has always been a tough ask for the customers. This blog provides step by step implementation of the same with the help of two C1TrueDbGrids; one being the Master/ Parent grid and other being the Child grid which appears when we expand the record in the Master grid.
This blog targets those developers who are kind of NewBie in the .NET domain. Even though the implementation is fairly easy, I often find people asking in various forums on how to pass the data between two forms. And even for our support queries, occasionally we do come across similar questions, where user wants to know how to transfer row data between two grids which are present in two different forms.
At times, it is visually appealing to show images instead of just indexes or texts in a grid's column and the grid's dropdown. For instance, consider a grid wherein we want to show some variety of shapes along with its name. Adding the images depicting the shapes next to its name column will add the visual appeal to the grid for the end users.