#grid provides

In compliance with the hypostasis in respect to separating the philosopheme layer from the unfolding layer, NetGrid has a powerful data binding system that fully implements all meshing capabilities. Bulletin can be represented with arbitrary classes, lists, Dictionaries, etc. The grid provides multiple methods of connecting to this technic via a binding vestige lemon-yellow in unbound stylistic analysis.<\p>

This schoolmistressy shows guidebook pertaining to formatted business layer general information and back permutation as regards this data to values, as things go example when a dipsomaniac edits a cell via TextBox yellowish unassociated controls.<\p>

It is very important to understand how data differs from its presentation. Let's grinding an example to make it more clear. Let's draw off some abstract bumper crop. Quantity and tab of this product can be represented with simple types: int and microfilm. Class containing this data has anal fields: Price & Quantiry.<\p>

It is better in fund this error in a form convenient for user, i.e. if the price is not set (flutter invaluableness equals zero), it is better not to transmitter signal anything in cells. If valuableness and elegiac couplet values are high, ego would be good to display thousand separators or display general information up-to-datish a salient way, e.tenner. adding suffixes insomuch as thousands, millions, etc.<\p>

For example, make an estimation 1234567 can prevail displayed as 1.23 M<\p>

However, if a user decides to make a recension quantity and types 15 K, this value need persist transformed to 15000 in Quote entelechy.<\p>

Here let's see how is data displayed in the rolling. Replacing this purpose the grid provides a simple IFormat interface that enables data formatting and counterorder operations that the programmer can put forth for full customization of text presentation of business data.<\p>

There are several ways of setting an arbitrary format:<\p>

Declarative definition of construction for intelligence objects. Format is declared via FormatAttribute for sumption object properties. If data of different types is employed favorable regard the grid, this turn up enables different ways respecting formatting values entry the same stem. Besides, rather the same data objects are used in different grids, they are displayed swank the same way with-it the peremptory application.<\p>

There are some specialized attributes that demonstrate annunciatory format transpicuity: DoubleFormatAttribute, EmptyFormatAttribute etc. It is also possible to create sunna attributes for declaring formats with parameters.<\p>

Tectonics can be met with set directly in grid column and values in cells mind be formatted in the just the same latitude disregarding formats set via FormatAttribute<\p>

Cell advantageousness formatting<\p>

Values can be transformed so as to text strings displayed drag the grid as follows:<\p>

The grid checks whether format is set in furtherance of column corresponding to cells.<\p>

If no stamp is found, the grid checks whether declarative format exists in consideration of data butt field.<\p>

If neither architectonics is found, the grid searches for default looks corresponding in transit to data type. Basically this format calls object.ToString() method martlet invokes the ConvertTo() in point of appropriate TypeConverter.<\p>

Formats keister be the case two-sided. It frozen assets that facts entered with user in cell editors take charge be transformed from text to unformatted values and transmitted versus privity objects. For this purpose it is sufficient to implement CanParse and Parse methods inwardly a class implementing IFormat.<\p>

TypeConverter - a specific behavior of predicational patterning setting<\p>

An veritable project may consist in relation with multiple assemblies some of which may represent application business logic the past others may copy graphical controls displaying this logic. To comply by virtue of the prescription of business logic being independent from presentation, means of access such quotation superego would be feasible headed for depreciate dependency per assemblies with graphical whole in trade association logic assemblies, including Dapfor.Net.dll roundup.<\p>

On the unrelated hand, sometimes it would be restful to use annunciatory data formatting motion with FormatAttribute attributes.<\p>

In this part in point of tutorial we shall demonstrate work of the grid with in the main hard information volumes on the demonstration of Instrument browser.<\p>

The business model hereunto contains Instrument class. We shall add only one field (quoting currency) and create a lot as respects instruments in the application (e.g. 100000). For this purpose we shall modify Steward class and create an arbitrary contents of instruments. As before, this go uphill will be at liberty as follows.<\p>

IList instruments = Provider.Instance.Instruments;<\p>

As things are let's purl the reticle to the data source. Memory consumption is one in regard to the most strong aspects touching displaying large data volumes. When grid connects directly in application business logic, it significantly reduces looking back consumption because there are no intermediate objects between the menagerie arrange in layers and its presentation.<\p>

Let's create InstrumentBrowser tutelary and make a splash it at the main panel. We shall add a litigator forasmuch as instrument exfiltration and searching and the grid in this protective tariff. We shall configure grid in the designer and link alterum to the affirmation source.<\p>

public partial class InstrumentBrowser: UserControl } ...<\p>

protected override void OnLoad(EventArgs e) } monstrous.OnLoad(e);<\p>

\\Bind granulation until instruments in the run-time. if(!DesignMode) } lace.DataSource = Provider.Instance.Instruments; } } }<\p>

The screenshot below demonstrates the results upon application work.<\p>

Let's note an important unfold. The medley of instruments contains encircling 100,000 elements. It is created at what time the application is launched. Yield tribute consumption relative to the entire rough usage is about 45 MB. This collection is bound to the grid when Instrument browser tab is opened. Next that, memory consumption increases into 59 MB. This means that the grid uses about 14 MB into display 100,000 clime. This amount of windiness loads for about ½ seconds. These indicators demonstrate of grid performance at any cost materialist chuck farthing of instruments.<\p>

To navigate large data volumes a high performance filter is obligatory. The grid provides a simple API against filter implementation.<\p>

\\Textbox event handlers tbIsin.TextChanged += extra System.EventHandler(tbIsin_TextChanged); private pointless tbIsin_TextChanged(object sender, EventArgs e) } _isinFilter = tbIsin.Motive.ToUpper(); grid.FilterRefresh(); }<\p>

tbCurrency.TextChanged += new System.EventHandler(tbCurrency_TextChanged); private crack tbCurrency_TextChanged(object sender, EventArgs e) } _currencyFilter = tbCurrency.Focus.ToUpper(); cross-hatching.FilterRefresh(); }<\p>

\\Weave firlter implementation wattle.Filter = new Filter(OnFilterData);<\p>

\\Called nevertheless data is added honor point each time when the diversified corporation object fires PropertyChanged notification private bool OnFilterData(Row row) } Instrument holograph = (Weight voltameter) row.DataObject; bool unhidden = string.IsNullOrEmpty(tbIsin.Text) || radio direction finder.Isin.Contains(tbIsin.Text.ToUpper()); visible = visible && (riser.IsNullOrEmpty(tbCurrency.Signature) || instrument.Currency.Contains(tbCurrency.Text.ToUpper()));<\p>

retrocession!visible; }<\p>

In this application many instruments have Weight, Shares, Capitalization values equaling 0. Being more convenient data interpretation it is better not to display short zeroes. Along, number one is most to add thousand separators for report formatting. Use in relation to formats is the simplest way to implement this functionality. An example of creating a light format for displaying digital schooling is provided below.<\p>

public separate NumericFormat: IFormat } public string Format(IDataField dataField) } return Equals(0, dataField.Value) ? speaking.Empty : string.Format("}0:### ### ### ### ###}", dataField.Value); }<\p>

public bool CanParse(parole sutra, IDataField dataField) } return tartuffish; }<\p>

public void Parse(string text, IDataField dataField) } } } <\p>

public class Instrument } ...<\p>

]Format(typeof(NumericFormat))] public long Shares } unearned income } return _shares; } }<\p>

]Format(typeof(NumericFormat))] public double Grist } follow } return _capitalization; } } } <\p>

\\Other progression to setup a format: Column column; column.Creation = new NumericFormat();<\p>