RadDropDownList Data being altered before bind?

0 Answers 55 Views
DropDownList
Mike
Top achievements
Rank 1
Mike asked on 03 Nov 2022, 06:02 PM

i'm lost on this.  I have a rad dropdown list that if I run through debugger and step through, it binds correctly showing years 2017-2022 from a SQL Query.  This is the weird part... If I build and run it on the dev server, somehow the years are being bound -1, displaying 2016-2021.  I have done a find for every reference to the dropdown and it is only accessed on two occasions - page load and on change,  what. in. the. world. is going on with this thing?

i've tried clearing the DDL, creating a new instance of DataSet, iterated through the returned dataset and bound each row individually, and everything else just short of clapping 3 times & doing the hokey pokey.

 

                DDLyear.Items.Clear();
                string yrSQL = "select year4 as TEXT, year4 as VALUE  from " + INSERT_TABLE_NAME_HERE + " group by year4 ORDER BY YEAR4 DESC";
                DataSet ds = new DataSet();
                ds = GetDataSet(yrSQL);
                DDLyear.DataSource = ds;
                DDLyear.DataBind();

 

Attached screenshots show the results running in debug and on dev server. 

Mike
Top achievements
Rank 1
commented on 03 Nov 2022, 06:42 PM

After posting this - it appears to be some sort of IIS environment issue on our dev box.  Published to IIS on a different machine and it works fine.  
Rumen
Telerik team
commented on 08 Nov 2022, 08:53 AM

Thank you for sharing the solution! I am glad that the problem was sorted out!

No answers yet. Maybe you can help?

Tags
DropDownList
Asked by
Mike
Top achievements
Rank 1
Share this question
or