public void FillingDropDownListBox(string strProc, ListBox objDrp, ParameterCollection parCollection, string initialmsg = "--Please Select--") { try { cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = strProc; cmd.CommandTimeout = 0; List <Entity.FillDropDownList> fdl = new List <Entity.FillDropDownList>(); //loop through all properties of the ParameterCollection and add parameters for each properties into procedure if (parCollection != null) { foreach (Parameter par in parCollection) { cmd.Parameters.AddWithValue(par.Name, par.DefaultValue); } } SqlDataReader dr = this.ExecuteDataReader(cmd); while (dr.Read()) { Entity.FillDropDownList objCity = new Entity.FillDropDownList(); fdl.Add(objCity); this.FillEntityDRP(dr, objCity, 0); } base.ForceCloseConnection(cmd); objDrp.Items.Clear(); objDrp.DataSource = fdl; objDrp.DataTextField = "ParameterText"; objDrp.DataValueField = "ParameterValue"; objDrp.DataBind(); // objDrp.SelectedIndex = 0; //objDrp.Items.Insert(0, new ListItem("-Please Select-", "0")); } catch (Exception ex) { throw new Exception(ex.Message); } finally { } }
public void FillEntityDRP(IDataReader dr, Entity.FillDropDownList ObjCity, int Type) { ObjCity.ParameterText = GetField(dr, "ParameterText"); ObjCity.ParameterValue = GetField(dr, "ParameterValue"); }