dr = cmd.ExecuteReader(); ddlProject.DataSource = dr; ddlProject.DataTextField = "RefNo"; ddlProject.DataValueField = "RefNo"; ddlProject.DataBind();