How to bind data with DataList control

Question

Hi, How to bind sql server data with DataList control in asp.net ?

Satyapriya Nayak · Answer

Hi legolas, If this post helps you mark it as answer Thanks

Satyapriya Nayak · Answer

Hi Legolas, Use the below code and run the attachments. Default.aspx code Untitled Page Id Name Address Marks 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 Dighe · Answer

This Link can be helpful to you.... Check it.... http://immortaldotnet.blogspot.com/search/label/DataList

How to bind data with DataList control

Answers (3)