How to populate a database in WinForms GridControl?
Populate a database
The WinForms GridControl does not have support to bind the DataSource directly. So, you can use the PopulateValues method to populate the data source and also populate the header using the PopulateHeaders method in GridControl.
this.gridControl1.PopulateHeaders(GridRangeInfo.Cells(0, 1, gridControl1.RowCount, gridControl1.ColCount), CreateTable());
this.gridControl1.PopulateValues(GridRangeInfo.Cells(1, 1, gridControl1.RowCount, gridControl1.ColCount), CreateTable());Me.gridControl1.PopulateHeaders(GridRangeInfo.Cells(0, 1, gridControl1.RowCount, gridControl1.ColCount), CreateTable())
Me.gridControl1.PopulateValues(GridRangeInfo.Cells(1, 1, gridControl1.RowCount, gridControl1.ColCount), CreateTable())The output is as follows:
Note:
Edited values are not committed to the data source here because you can populate only the data values in GridControl.
Reference Link: Populating Data
Conclusion
I hope you enjoyed learning about how to populate a
database in WinForms GridControl.
You can refer
to our WinForms GridControl feature tour page to know about
its other groundbreaking feature representations and WinForms GridControl documentation, and how
to quickly get started for configuration specifications.
For current
customers, you can check out our components from the License and
Downloads page. If you are new to Syncfusion, you can try our
30-day free trial to check out our other controls.
If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
