Hello. How to set up and work with DataGridView correctly, if the structure of datarow and grid is different? At the moment, I am filling the grid with the Add() method. I will give an example code:
dgv.Rows.Add(sName, sCount); The data to add is taken from datarow [] . Tell me, please, can I fill the grid faster?
In the comments flashed information that loading from the DataSource is not used due to the fact that the structure of the resulting query is different from the structure DataGridViev.
This is not a problem; you can control the bound columns by knobs, choosing which column from the source to display on a particular DataGridView column.
dataGridView.AutoGenerateColumns = false;//Колонки генерироваться не будут=> где-то потребуется их сгенерировать перед привязкой dataGridView.DataSource = result; dataGridView.Columns["GridColumnName"].DataPropertyName = "ResultColumnName"; Data that has not been attached is not lost.
That is, if you get a Row from a DataGridView, you can bring it to the desired type and refer to fields that were not reflected.
Ideally, DataGrid or DataGrid View should not be filled in principle.
Ideally, you need to switch to virtual mode (VirtualMode = true) and load data directly from any data resource. Be it dataset, arrey strings, a sheet of custom objects or something else.
That is, in dataGridView1_NewRowNeeded you write exactly what kind of macar you need to get and process the data. And whether it is necessary to insert everything from actually available data.
Including you can load data directly from SQL.
Source: https://ru.stackoverflow.com/questions/611475/
All Articles
VirtualMode = truemode toVirtualMode = trueand handle the corresponding events. Read more in MSDN . But, I suppose, it will be enough for you to simply use regular data binding. - Ev_Hyperdgv.DataSource = datarows.CopyToDataTable().DefaultView;- Ev_Hyperdgvcolumns fordgvother thandatarowsor what? - Ev_Hyper