sql - VB.NET ListView is showing all but one of my columns from my dataset -

sql - VB.NET ListView is showing all but one of my columns from my dataset -

i have listview command called lvsearchresults want fill dataset. dataset filled sql query, , reason displays 2 out of 3 columns , shifts them on right one.

it puts pid number in lastly name column , lastly name in first name column. , doesn't display first name @ all. reddish bar censored numbers privacy reasons, displaying pid number there.

here code

try myselectadapter.selectcommand = new idb2command("select eessn,eenaml,eenamf carsprod.empmstr eenaml '" + txtlname.text.toupper.trim + "%' order eenaml asc", myconnection) myselectadapter.fill(dssearchresults) myselectadapter.selectcommand.dispose() grab ex exception msgbox(ex.message, msgboxstyle.critical) end seek lvsearchresults.clear() lvsearchresults.cursor = cursors.waitcursor lvsearchresults.view = view.details lvsearchresults.gridlines = true lvsearchresults.fullrowselect = true lvsearchresults.hideselection = false lvsearchresults.multiselect = false lvsearchresults.columns.add("pid", 55, horizontalalignment.right) lvsearchresults.columns.add("last name", 55, horizontalalignment.left) lvsearchresults.columns.add("first name", 55, horizontalalignment.left) msgbox(lvsearchresults.columns.count.tostring) if dssearchresults.tables(0).rows.count > 0 dim lv listviewitem = 0 dssearchresults.tables(0).rows.count - 1 lv = new listviewitem lv.subitems.add(dssearchresults.tables(0).rows(i)(0)) lv.subitems.add(dssearchresults.tables(0).rows(i)(1)) lv.subitems.add(dssearchresults.tables(0).rows(i)(2)) lvsearchresults.items.add(lv) next

i totally stumped on one. if has ideas appreciate it.

remember listviewitem.text show in col(0), when add together 3 subitems, end adding 1 more needed , not supplying text first column (the lvi "label" itself). should work:

for = 0 dssearchresults.tables(0).rows.count - 1 lv = new listviewitem lv.text = dssearchresults.tables(0).rows(i)(0) lv.subitems.add(dssearchresults.tables(0).rows(i)(1)) lv.subitems.add(dssearchresults.tables(0).rows(i)(2)) lvsearchresults.items.add(lv) next

you need add together 2 subitems because .text of lvi shows in first column. datagridview easier - set datasource.

sql database vb.net listview dataset