private void LoadHostingPlansAvailable() { HostingPlansHelper plans = new HostingPlansHelper(); string[] plansTaken = Array.ConvertAll <int, string>( StorehouseHelper.GetHostingPlansTaken(), new Converter <int, string>(Convert.ToString) ); DataSet ds = plans.GetRawHostingPlans(); // check empty dataset if (ds != null && ds.Tables.Count > 0) { // apply filter only if necessary if (plansTaken.Length > 0) { // apply filter for plans already created ds.Tables[0].DefaultView.RowFilter = "PlanID NOT IN (" + String.Join(",", plansTaken) + ")"; } // bind default view ddlHostingPlans.DataSource = ds.Tables[0].DefaultView; ddlHostingPlans.DataBind(); } }