Combo Box

[sajid salim khan]

:rose::rose:How to Fill Combo Box From SQL2000 Tables :rose:SAS

[laddie 0]

SqlCommand cmd = new SqlCommand("SELECT [field] FROM table",connection); SqlDataReader dataReader = cmd.ExecuteDataReader(); while(dataReader.Read()) { comboBox1.Items.Add(new llistItem(dataRead[0],dataRead[0]); } dataRead.Close(); Hope this helps

[rohitsrivastava]

hi this is the coding to fill the combo strselect="select fieldname from tablename " objsqlconn=new sqlconnection("userid=sa;password=;data source=servername") objsqlconn.open() objdataset=new dataset objsqlcmd=new sqlcommand(strselect,objsqlconn) objsqldataadapter=new sqldataadapter(objsqlcmd) objsqldataadapter.fill(objdataset,"Tablename") cmbname.datasourc=objdataset.table("Tablename") cmbname.displaymember="Fieldname" cmbname.displayvalue="fieldname" this is how to fill the combo have a nice day