一个绑定的radiobuttomlist 为什么显示的时候会比数据库少一项?该如何解决

一个绑定的radiobuttomlist 为什么显示的时候会比数据库少一项?
很奇怪,还有就是怎么让它第一项默认被选中?

[解决办法]
string sql= "select * from vote order by id ";

string conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data source= " + Server.MapPath( "vote.mdb ");

OleDbConnection oleconn = new OleDbConnection(conn);

oleconn.Open();

OleDbCommand cmd = new OleDbCommand(sql, oleconn);
OleDbDataReader dr = cmd.ExecuteReader();

rdl.DataSource = dr;
rdl.DataTextField = "name ";
rdl.DataValueField = "name ";
rdl.DataBind();

oleconn.Close();

[解决办法]
不能 while(dr.Read())后再绑定，这时候一条数据已经被Read掉了，你上面的代码中不需要用while来判断，直接用
rdl.DataSource = dr;
rdl.DataTextField = "name ";
rdl.DataValueField = "name ";
rdl.DataBind();
就可以了