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