This example demonstrates how to create and initialize ASPxGridView at runtime.
using DevExpress.Web;
...
protected void Page_Load(object sender, EventArgs e) {
ASPxGridView grid1 = new ASPxGridView();
grid1.ID = "grid1";
grid1.AutoGenerateColumns = false;
grid1.DataSourceID = "SqlDataSource1";
grid1.KeyFieldName = "ProductID";
grid1.Columns.AddRange(new GridViewDataColumn[]{
new GridViewDataColumn { FieldName="ProductID", ReadOnly = true, VisibleIndex = 0},
new GridViewDataColumn() { FieldName = "ProductName", VisibleIndex = 1 },
new GridViewDataColumn() { FieldName = "UnitPrice", VisibleIndex = 2 },
});
Page.Form.Controls.Add(grid1);
}
Imports DevExpress.Web
...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim grid1 As ASPxGridView = New ASPxGridView()
grid1.ID = "grid1"
grid1.AutoGenerateColumns = False
grid1.DataSourceID = "SqlDataSource1"
grid1.KeyFieldName = "ProductID"
grid1.Columns.AddRange(New GridViewDataColumn() {
New GridViewDataColumn With {
.FieldName = "ProductID",
.[ReadOnly] = True,
.VisibleIndex = 0
},
New GridViewDataColumn() With {
.FieldName = "ProductName",
.VisibleIndex = 1
},
New GridViewDataColumn() With {
.FieldName = "UnitPrice",
.VisibleIndex = 2
}
})
Page.Form.Controls.Add(grid1)
End Sub
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb;
Persist Security Info=True" ProviderName="System.Data.OleDb"
SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice], [UnitsInStock] FROM [Products]">
</asp:SqlDataSource>