Visual Studio odbc commands

[MARKSHAM]

I'm trying to pull data into a listbox with more than one column. I have successfully connected to the database from vb.net, and I have pulled data (one column) from using an odbc select command into a list box. The problem I'm having now is that I have more than one column of data that I want to display in the list box. I'm using the following command ListBoxName.Items.Add(myReader.GetString(0)) to get the data into my list box. The "0" indicates the column number that gets inserted into the list box. If I change the number to "1", I can get the second column from my select command to appear in the list box, but I want a multiple column list box with both columns to appear in the list box.

MSH

[Duane in Japan]

I really do not know what I am talking about but I just watched a video a little while ago dealing with pulling first names and last names. These two columns of info were concatonated together to fill a full name column. Make a space, not an underscore as my sample??????????? You may not need a literal comma. lastname + "," + _firstname Hope you get some real help from others, I will be watching + learning.

[Craster]

I'd suggest using a listview instead of a listbox. You can create a listviewitem, set the text property (this will fill the first column of the listview), and for each subsequent column, populate the subitems collection of the listviewitem. If that's not too clear, here's a sample: Dim lv As New ListViewItem lv.Text = sqlrdr.GetString(1) lv.SubItems.Add(sqlrdr.GetString(2)) lv.SubItems.Add(sqlrdr.GetString(3)) ListView1.Items.Add(lv)

[MARKSHAM]

Thanks for the ListView suggestion. I'm new to Visual Studio and OOP, and I have never heard of this option. I will give it a try. Thanks again.

MSH