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.