OBOUT - ASP.NET Grid - Data Binding Tutorial

ASP.NET Grid - Data Binding Tutorial

The ASP.NET Grid has a set of properties and methods that allow developers to bind
the component with many types of objects from the .NET Framework.

Supported types

DataSet
DataReader (SqlDataReader, OleDbDataReader, OdbcDataReader)
DataTable
ObjectDataSource
SqlDataSource
XmlDataSource
LinqDataSource
Linq
Generic Collections

Examples

DataSet

C#		VB.NET
DataSet ds = new DataSet(); // load data from a database grid1.DataSource = ds; grid1.DataBind();		Dim ds = new DataSet() ' load data from a database grid1.DataSource = ds grid1.DataBind()

DataReader

VB.NET

OleDbDataReader myReader;
myReader = myComm.ExecuteReader();

grid1.DataSource = myReader;
grid1.DataBind();

Dim myReader As OleDbDataReader
myReader = myComm.ExecuteReader()

grid1.DataSource = myReader
grid1.DataBind()

DataTable

VB.NET

DataSet ds = new DataSet();
// load data from a database

grid1.DataSource = ds.Tables["Orders"];
grid1.DataBind();

Dim ds = new DataSet()
' load data from a database

grid1.DataSource = ds.Tables("Orders")
grid1.DataBind()

ObjectDataSource

<asp:ObjectDataSource ID="ods1" runat="server" SelectMethod="GetClients"
TypeName="CData"></asp:ObjectDataSource>

<obout:Grid id="grid1" runat="server" DataSourceID="ods1"></obout:Grid>

SqlDataSource

<asp:SqlDataSource ID="sqlDs" Runat="server"
SelectCommand="SELECT ClientID, FirstName, LastName FROM clients"
ConnectionString="<%$ ConnectionStrings:Obout %>" />

<obout:Grid id="grid1" runat="server" DataSourceID="sqlDs"></obout:Grid>

XmlDataSource

<asp:XmlDataSource runat="server" ID="xds1" DataFile="~/App_Data/xml/Grid.xml" />

<obout:Grid id="grid1" runat="server" DataSourceID="xds1">
</obout:Grid>

LinqDataSource

<obout:Grid ID="Grid1" runat="server" DataSourceID="LinqDataSource1" />

<asp:LinqDataSource ID="LinqDataSource1" runat="server"
ContextTypeName="oboutGrid_with_LINQ.NorthwindDataContext"
TableName="Orders"
Select="new (OrderID, ShipName, ShipCity, ShipCountry, OrderDate)">
</asp:LinqDataSource>

See also the Data Binding properties page.

"Fantastic controls."

Gibbons, Bobby

Expertech.net

Random testimonial All testimonials