Populate a ListBox From DataSet

Question

Is possible populate a ListBox from a DataSet with several colums? If any1 know how to do it, plz post some code. Thanx in advance.

Carlos Sanchez · Answer

Thanx Kanna, it's works... but if I want to display 2 colums in the ListBox, do u know how to do it? thank you again, I appreciate your help.

eyes · Answer

Hi, Upto my knowledge, it is possible to set the values of a single column of a particular DataTable within a DataSet . . . Check this code . . . DataTable table = new DataTable ( ) ; table.Columns.Add ( "Name" ) ; DataRow row ; row = table.NewRow ( ) ; row [ "Name"] = "Santhosh" ; table.Rows.Add ( row ) ; row = table.NewRow ( ) ; row [ "Name"] = "Muthu" ; table.Rows.Add ( row ) ; row = table.NewRow ( ) ; row [ "Name"] = "Naveen" ; table.Rows.Add ( row ) ; DataSet dataSet = new DataSet ( ) ; dataSet.Tables.Add ( table ) ; lstNames.DataSource = dataSet.Tables[0] ; lstNames.DisplayMember = "Name" ; where lstNames is the name of the list control . . . Is this u expected, or anything more . . . Cheers, Kanna . . .

Populate a ListBox From DataSet

Answers (2)