三、使用代碼綁定到SQL數據

以下代碼說明了如何使用SqlDataSource組件在運行時將GridControl綁定到SQL數據。

在此示例中，使用的是CustomSqlQuery。要了解其他查詢類型，請參閱和類的說明。

要了解支持的數據庫引擎，請參閱的繼承層次結構。

[C#]

using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
// . . . 
// Create a data source. 
Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters("D:\\Work\\nwind.mdb", "", "");
SqlDataSource ds = new SqlDataSource(connectionParameters);

// Create an SQL query to access the Products table. 
CustomSqlQuery query = new CustomSqlQuery();
query.Name = "customQuery1";
query.Sql = "SELECT [Products].[ProductID], [Products].[ProductName], [Products].[QuantityPerUnit], [Products].[UnitPrice], " 
    + "[Products].[UnitsInStock], [Products].[UnitsOnOrder], [Products].[ReorderLevel], [Products].[Discontinued] " 
    +"FROM [Products] [Products]";

ds.Queries.Add(query);
ds.Fill();

//Assign the data source for the grid and retrieve fields. 
gridControl1.DataSource = ds;
gridControl1.DataMember = "customQuery1";

[VB]

Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
' . . .  
' Create a data source.  
Private connectionParameters As New Access97ConnectionParameters("D:\Work\nwind.mdb", "", "")
Private ds As New SqlDataSource(connectionParameters)

' Create an SQL query to access the Products table.  
Private query As New CustomSqlQuery()
query.Name = "customQuery1" 
query.Sql = "SELECT [Products].[ProductID], [Products].[ProductName], [Products].[QuantityPerUnit], [Products].[UnitPrice], " & "[Products].[UnitsInStock], [Products].[UnitsOnOrder], [Products].[ReorderLevel], [Products].[Discontinued] " & "FROM [Products] [Products]" 

ds.Queries.Add(query)
ds.Fill()

'Assign the data source for the grid and retrieve fields.  
gridControl1.DataSource = ds
gridControl1.DataMember = "customQuery1"

請注意，在控件綁定到數據源之后，具體控件可能需要其他自定義。有關更多信息，請參閱相應控件的文檔。

慧都學院2017全新DevExpress線下研修班火熱報名中！