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 belowHere 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