i am using visula studio 2005 and database is sql server 2000. i have one table "Designation_Master" with two columns "DesigID" with datatype "smallint" and another "Designation" with datatype "Char(10)". i want to display both column in one row in combobox. i know concate the column. but i don't want to concate two columns. i need seprate two columns in combobox like datagrid or excel. please send a code in "vb" script language not in "c" or "C++"