in my application ,there is a dropdownlist.
after saving data to data base.
i want to add one field to dropdownlist
after the save command i wote
SqlCommand cmd = new SqlCommand("select cname from registration ", con);
SqlDataReader dr1 = cmd.ExecuteReader();
but adding duplicates.
i have added "select a company" to drop downlist as first item;
how to avoid the duplicate value.
suppose if there are 10 records,if i add another record my
drop down list should contains
only 11 records with select a company at top.
K L BAIJU