This tutorial will show you how to display data using the .NET DataList Control, ASP.NET 2.0 and VB.NET
The DataList control is an easy to use tool similiar to the Repeater control.
First, you will need to import the System.Data.SqlClient namespace.
The System.Data.SqlClient namespace contains the SqlCommand and SqlConnection classes that we need in order to connect to our database and to send an SQL command to it.
|
Imports System.Data.SqlClient |
We are using Server Intellect and have found that by far, they are the most friendly, responsive, and knowledgeable support team we've ever dealt with!
We'll put our code in the Page_Load() event.
When the Page_Load() event fires, a new SqlCommand object is instantiated with our connection string and our command.
Afterwards, we will attempt to connect using the Open() method of our cmd.Connection object. Once it is connected we will attempt to execute the command we specified earlier (in this example "SELECT TOP 5 firstname,lastname,hiredate FROM EMPLOYEES" in the Northwind db).
If all goes well, we will have the results of our SQL query assigned to the dlExample's DataSource property. Now all we have to do is call the DataBind() method of our dlExample to bind the data to the control. The data is now ready to be displayed.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
Try
Dim cmd As SqlCommand = New SqlCommand("SELECT TOP 5 firstname,lastname,hiredate FROM EMPLOYEES", New SqlConnection("Server=localhost;Database=Northwind;Trusted_Connection=True;"))
cmd.Connection.Open()
dlExample.DataSource = cmd.ExecuteReader()
dlExample.DataBind()
cmd.Connection.Close()
cmd.Connection.Dispose()
Catch ex As Exception
lblStatus.Text = ex.Message
End Try |
If you're ever in the market for some great Windows web hosting, try Server Intellect. We have been very pleased with their services and most importantly, technical support.
We have to add a few tags on the front end of the .aspx page to place where we want the DataList control to display its bound data. Inside of the main DataList tag, we use the <HeaderTemplate> tag to specify the column titles for our repeated data and the <ItemTemplate> tag to specify what HTML tags can go around that repeated data (in this case, <td> tags surround each item). So, the front end .aspx page looks something like this:
<td align="center" bgcolor="#FFFFFF">
<asp:DataList ID="dlExample" runat="server" CssClass="basix" GridLines="Both">
<HeaderTemplate>
<td>First Name</td>
<td>Last Name</td>
<td>Hire Date</td>
</HeaderTemplate>
<ItemTemplate>
<td><%# DataBinder.Eval(Container.DataItem,"firstname") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"lastname") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"hiredate") %></td>
</ItemTemplate>
</asp:DataList>
<asp:label ID="lblStatus" runat="server"></asp:label></td>
|
Need help with Windows Dedicated Hosting? Try Server Intellect. I'm a happy customer!
The flow for the code behind page is as follows.
Imports System.Data.SqlClient
Partial Public Class _Default : Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
Dim cmd As SqlCommand = New SqlCommand("SELECT TOP 5 firstname,lastname,hiredate FROM EMPLOYEES", New SqlConnection("Server=localhost;Database=Northwind;Trusted_Connection=True;"))
Try
cmd.Connection.Open()
dlExample.DataSource = cmd.ExecuteReader()
dlExample.DataBind()
cmd.Connection.Close()
cmd.Connection.Dispose()
Catch ex As Exception
lblStatus.Text = ex.Message
End Try
End Sub |
Download the Full Working Version of this Project written with Visual Studio.NET VB.NET 2005 Here!
Looking for the C#.NET Version? Click Here!
Looking for more ASP.NET Tutorials? Click Here!