How to bind data with DataList control

Hi Legolas,
Use the below code and run the attachments.

Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

Untitled Page

Default.aspx.vb code
Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim sqlda As SqlDataAdapter
    Dim com As SqlCommand
    Dim ds As DataSet
    Dim str As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        bindlist()
    End Sub
    Sub bindlist()
        Try
            con.Open()
            str = "select * from student"
            com = New SqlCommand(str, con)
            sqlda = New SqlDataAdapter(com)
            ds = New DataSet
            sqlda.Fill(ds, "student")
            DataList1.DataSource = ds
            DataList1.DataMember = "student"
            DataList1.DataBind()
            con.Close()
        Catch ex As Exception
            Response.Write(ex.Message)
        End Try
    End Sub
End Class

Thanks
If this post helps you mark it as answer

Mayur Dighe15y ago

This Link can be helpful to you....

Check it....

http://immortaldotnet.blogspot.com/search/label/DataList

Id	Name	Address	Marks
<%#Eval("sid")%>	<%#Eval("sname")%>	<%#Eval("saddress")%>	<%#Eval("smarks")%>