protected void PopulateLabsDropdown() { try { DBOps db = new DBOps(); DataSet ds = db.GetLabs(); DataRow dr = ds.Tables["table"].NewRow(); dr["name"] = "All"; ds.Tables["table"].Rows.InsertAt(dr, 0); ddlLabselect.DataSource = ds; ddlLabselect.DataTextField = "name"; ddlLabselect.DataValueField = "name"; ddlLabselect.DataBind(); ddlInsertLab.DataSource = ds; ddlInsertLab.DataTextField = "name"; ddlInsertLab.DataValueField = "name"; ddlInsertLab.DataBind(); //ddlSearchInventory.DataSource = ds; //ddlSearchInventory.DataTextField = "name"; //ddlSearchInventory.DataValueField = "name"; //ddlSearchInventory.DataBind(); } catch (Exception ex) { throw ex; } }