private void fillSearchCategory() { try { DataSet DS = new DataSet(); ECategory Ecategory = new ECategory(); DS = Ecategory.GETALLCATEGORY(Ecategory); DataRow dr = DS.Tables[0].NewRow(); dr["CategoryName"] = "Select"; dr["CategoryID"] = "%"; DS.Tables[0].Rows.InsertAt(dr, 0); // search category box filling SrchcmbCategory.DataSource = DS.Tables[0]; SrchcmbCategory.DisplayMember = "CategoryName"; SrchcmbCategory.ValueMember = "CategoryID"; } catch (Exception ex) { } }
private void fillCategory() { DataSet DS = new DataSet(); ECategory Ecategory = new ECategory(); DS = Ecategory.GETALLCATEGORY(Ecategory); if (DS.Tables.Count > 0) { if (DS.Tables[0].Rows.Count > 0) { DataRow dr = DS.Tables[0].NewRow(); dr["CategoryName"] = "All"; dr["CategoryID"] = 0; DS.Tables[0].Rows.InsertAt(dr, 0); // add Category Filling ddlcatname.DataSource = DS.Tables[0]; ddlcatname.DisplayMember = "CategoryName"; ddlcatname.ValueMember = "CategoryID"; } } }