private void FillRegions(DropDownList ddl)
{
try {
ddl.Items.Clear();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCSecurity.SecurityRegionGetAll(conn)) {
while (dr.Read())
{
int regionID = dr.GetInt32(dr.GetOrdinal("rgn_region_id"));
ListItem item = new ListItem(dr.GetString(dr.GetOrdinal("rgn_name")),
regionID.ToString());
ddl.Items.Add(item);
}
}
}
ddl.SelectedIndex = -1;
}
catch (Exception ex) {
Common.CException wex = new Common.CException("Security.FillRegions", ex);
throw (wex);
}
}
