ddl binding

[brettokumar]

hi i am binding values from database to ddl through sqldatareader records are binding in my dripdownlist but my first record is dosen't bind i.e if i have 4 records in my table. ddl is binding only three records from 2 to 4 only dosen't bind 1st record. shall i know what is the problem please help me...

with regards, bretto

[Bardy85]

Please could you paste your code. Are you sure are reading all the records. How are you binding the data?

[Sandeep Akhare]

First thing is Debug the application And see what you are getting from database.

Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... " Check My Blog

[SomeGuyThatIsMe]

dont call sqlReader.Read() just set the datasource for the dropdown, the DataTextField, and the DataValueField, to whatever column you want them to be(the text field is what is displayed) and call the DataBind function on the drop down.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[musclebai]

the person above has given the exact answer....this is what msdn has to say about the Reader.Read()----Advances the reader to the next block of data in cases where the reader contains more than one block.So the first call gets u past the first record i believe.

[neelaveni k]

objDDL.fillDDL(ddlState, "codstate", "", False, Constants._DDL_Default_Select) objDDL.fillDDL(ddlDistrict, "CODDistrict", "", False, Constants._DDL_Default_Select) objDDL.fillDDL(ddlCity, "CODcity", "", False, Constants._DDL_Default_Select) using ddlstate,district,city tables