Bind DataTable to ASP. NET ListBox control

Question

Hi all, How to Bind DataTable to ASP. NET ListBox control ?

Satyapriya Nayak · Answer

Hi Shalini, Please look at the code below,Here you can bind only one column value in DataTextField property on listbox to display that column values only. Default.aspx code Untitled Page SelectionMode="Multiple" Width="337px"> Default.aspx.vb code Imports System.Data Imports System.Data.SqlClient 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 str As String Dim com As SqlCommand Dim sqlda As SqlDataAdapter Dim ds As DataSet Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load con.Open() str = "select * from employee" com = New SqlCommand(str, con) sqlda = New SqlDataAdapter(com) ds = New DataSet sqlda.Fill(ds, "employee") ListBox1.DataValueField = "empid" ListBox1.DataTextField = "empname" ListBox1.DataSource = ds ListBox1.DataMember = "employee" ListBox1.DataBind() con.Close() End Sub End Class Thanks If this post helps you mark it as answer

Bind DataTable to ASP. NET ListBox control

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)