vb.net - combobox displays System.Data.DataRowView when trying to select the data from sql database -
i got system.data.datarowview when tried select data sql database. these code: ...... mycommand = new sqlcommand("select firstname +' '+ lastname tblvisitor", myconnection) myadapter = new sqldataadapter(mycommand) myadapter.fill(mydataset, "tblvisitor") cboname.datasource = mydataset.tables(0) cboname.displaymember = "firstname" cboname.displaymember = "lastname" cboname.valuemember = "firstname" cboname.valuemember = "lastname" .............. and got above error. please help. your selectcommand neither return column lastname nor firstname . returning 1 column(a concatenation of both columns). so should work: mycommand = new sqlcommand("select visitorid, lastname, firstname, (firstname +' '+ lastname)as fullname tblvisitor", myconnection) myadapter = new sqldataadapter(mycommand) myadapter.fill(mydataset, "tblvisitor") cboname.datasource = mydataset.tables(0) cboname....