How to show more than one database collumns in a listbox

[keninfo]

Hello all, Does anyone know how to show more than one database collumns in a listbox?? In documentation i read that it was not possible bus is there anyone who knows a backdoor for it? Thanks.

[Tirthadip]

if you just want to display data then while retrieving Concatenate it in sql query........but i dont think u can see more than one column in a listbox..may be i am wrong

Tirtha Miles to go before I sleep

[CPallini]

Use a ListView. :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.

[keninfo]

Is it that easy? Shame on me!! I wil try it. Thanks

[keninfo]

But how will i bind the listview to the database table? There is no datasource property.

[Tirthadip]

ListView doesn't have any datasource property...u have to add Items and Subitems to display ur data....

Tirtha Miles to go before I sleep

[CPallini]

If you need an object exposing the DataSource property then use the DataGrid. :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.

[Tirthadip]

if u have a dataset(say myDataset) populated with your records then try this....(code is in vb.net) Dim lvItem As ListViewItem For i As Integer = 0 To myDataset.Tables(0).Rows.Count - 1 lvItem = New ListViewItem(myDataset.Tables(0).Rows(i).Item(0)) For j As Integer = 0 To NumberOfSelectedField lsItem.SubItems.Add(CStr(myDataset.Tables(0).Rows(i).Item(j + 1))) Next myListView.Items.Add(lvItem) Next

Tirtha Miles to go before I sleep

[keninfo]

Thanks. I will try that.