为什么读不出前一条数据
#region 绑定下拉列表
private void get_dropListCategroy()
{
string strSQL = "select CID,CategoryName from Category where ParentId=0 ";
string connstring = ConfigurationManager.AppSettings["connectionString"].ToString();
SqlConnection conn = new SqlConnection(connstring);
SqlCommand cmd = new SqlCommand(strSQL, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
this.CategoryDownList.DataSource = dr;
this.CategoryDownList.DataValueField = "CID";
this.CategoryDownList.DataTextField= "CategoryName";
this.CategoryDownList.DataBind();
}
dr.Close();
cmd.Clone();
conn.Close();
}
#endregion
数据库里有
CID CategroyName parentsID
1 球类 0
2 音乐 0
3 手机 0
只绑定了 2 3?为什么绑定不出1 ?