Examples: Data Binding

最新推荐文章于 2020-05-17 00:07:17 发布

happymagic

最新推荐文章于 2020-05-17 00:07:17 发布

阅读量148

点赞数

分类专栏： DevExpress C#

本文链接：https://blog.csdn.net/happymagic/article/details/103428899

版权

C# 同时被 2 个专栏收录

70 篇文章 1 订阅

订阅专栏

DevExpress

28 篇文章 0 订阅

订阅专栏

https://docs.devexpress.com/WindowsForms/3002/controls-and-libraries/data-grid/examples/data-binding/examples-data-binding

Examples: Data Binding

Apr 01, 2018

#Examples

#Knowledge Base Articles

How to: Bind a Control to a Database at Runtime

https://docs.devexpress.com/WindowsForms/2240/common-features/data-binding/how-to-bind-a-control-to-a-database-at-runtime

This example demonstrates how to bind a data-aware control (XtraGrid, XtraPivotGrid, XtraVerticalGrid, etc.) to a database at runtime. Note that specific controls may need additional customization after the control is bound to a data source. For more information, refer to documentation of the corresponding control.

The following code demonstrates a way of binding a GridControl to the Products table of the NWind database.

C# VB.NET


using System.Data.OleDb;
// ...
// Create a connection object.
OleDbConnection connection = new OleDbConnection(
  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\DBs\\NWIND.MDB");

// Create a data adapter.
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Products", connection);

// Create and fill a dataset.
DataSet sourceDataSet = new DataSet();
adapter.Fill(sourceDataSet);

// Specify the data source for the grid control.
gridControl1.DataSource = sourceDataSet.Tables[0];