原創(chuàng)|使用教程|編輯:龔雪|2017-08-28 16:22:59.000|閱讀 155 次
概述:本示例會(huì)向您演示如何在運(yùn)行時(shí)將數(shù)據(jù)感知控件(XtraGrid、XtraPivotGrid、XtraVerticalGrid等)綁定到數(shù)據(jù)庫(kù)
# 界面/圖表報(bào)表/文檔/IDE等千款熱門(mén)軟控件火熱銷(xiāo)售中 >>
本示例會(huì)向您演示如何在運(yùn)行時(shí)將數(shù)據(jù)感知控件(XtraGrid、XtraPivotGrid、XtraVerticalGrid等)綁定到數(shù)據(jù)庫(kù)。請(qǐng)注意,在將控件綁定到數(shù)據(jù)源之后,可能需要針對(duì)具體控件進(jìn)行額外的自定義。更多相關(guān)信息,請(qǐng)參閱相應(yīng)控件的文檔。
以下代碼演示了如何將GridControl綁定到NWind數(shù)據(jù)庫(kù)的Products表。
[C#]
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];
[VB]
Imports System.Data.OleDb ' ... ' Create a connection object. Dim Connection As New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\DBs\\NWIND.MDB") ' Create a data adapter. Dim Adapter As New OleDbDataAdapter("SELECT * FROM Products", Connection) ' Create and fill a dataset. Dim SourceDataSet As New DataSet() Adapter.Fill(SourceDataSet) ' Specify the data source for the grid control. GridControl1.DataSource = SourceDataSet.Tables(0)
本站文章除注明轉(zhuǎn)載外,均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載,但請(qǐng)務(wù)必注明出處、不得修改原文相關(guān)鏈接,如果存在內(nèi)容上的異議請(qǐng)郵件反饋至chenjj@fc6vip.cn