i have a list collection and this contains items from database. And i want to show these items in a list box. But how could i bound this list to my listbox control..
pls help me..
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vishal GilbilePosted Apr 9, 2013, 4:09 AM
What I got from your question is that you have a list and you want to bind this list to your listbox.
Following is the way. Let's say the List name is list.
listBox1.DataSource=list;
listBox1..DataValueField =listBox1.DataTextField="ColumnName";
listBox1.DataBind();
Hope that solves your problem.
With Regards,
Vishal Gilbile
santosh paridaPosted Apr 9, 2013, 4:32 AM
santosh paridaPosted Apr 9, 2013, 3:34 AM
santosh paridaPosted Apr 9, 2013, 3:33 AM
Satyapriya NayakPosted Apr 9, 2013, 3:24 AM
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
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