c# 数据库访问---SqlDataReader对象

string connStr = ConfigurationManager.ConnectionStrings["sqlConnStr"].ConnectionString;
            string sqlStr = string.Format("select * from AreaInfo where AreaPid={0}", ddlProvince.SelectedItem.Value);
            using (SqlConnection conn = new SqlConnection(connStr))
            {

                using (SqlCommand cmd = new SqlCommand(sqlStr, conn))
                {
                    conn.Open();
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                //读取数据
                                //ddlProvince.Items.Add(reader.GetString(1));
                                ddlCity.Items.Add(new ListItem(reader.GetString(1), reader.GetInt32(0).ToString()));

                            }
                        }
                    }

                }
            }