Populate a ListBox From DataSet

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos Sanchez22y ago
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.
0
eyes22y ago
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 . . .
0