to bind the dropdown list from table value using sqldatareader

See more:

ASP.NET

SQL-Server

int brand = int.Parse(dr[8].ToString());
               string b_id = (brand - 1).ToString();
               ddbrandname.Items.FindByValue(b_id).Selected = true;

this is my code,i am getting 'id' from table through sqldatareader ,in my drop down list the "select" as 0.
Text |value
select - 0
chennai - 1
trichy - 2
Madurai - 3

if , 3 as my reader value and i m binding by the above code,it shows error,
but if i decrease 1 value from 3 like (3-1) =2 .

if it is 2 ,its working pakka,if its 3 its shows error,