private void PopulateCategoryDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); List <Category> data = controller.ListAllCategories(); CategoryDropDown.DataSource = data; CategoryDropDown.DataTextField = "CategoryName"; CategoryDropDown.DataValueField = "CategoryID"; CategoryDropDown.DataBind(); CategoryDropDown.Items.Insert(0, "[select a Category]"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Bind Categories list to CategoriesDropDown and set the initial selected value List <string> categoriesList = ToDoItemData.GetCategories(); categoriesList.Add("ALL"); CategoryDropDown.DataSource = categoriesList; CategoryDropDown.DataBind(); int currentCategoryIndex = categoriesList.IndexOf(CategoryFilter); CategoryDropDown.SelectedIndex = currentCategoryIndex; } }
private void PopulateCategoryDropDown() { var controller = new CategoryController(); var data = controller.ListCategories(); CategoryDropDown.DataSource = data; CategoryDropDown.DataTextField = nameof(Category.CategoryName); CategoryDropDown.DataValueField = nameof(Category.CategoryID); CategoryDropDown.DataBind(); // Let's insert a couple of options at the top of the drop-down CategoryDropDown.Items.Insert(0, new ListItem("[select a category]")); CategoryDropDown.Items.Insert(1, new ListItem("[no category]", string.Empty)); // The second inserted item is to accommodate a NULL value for the Product.CategoryID }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Panel3.Visible = false; Panel2.Visible = false; Panel1.Visible = true; string CS = ConfigurationManager.ConnectionStrings["EnrollInJob"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { /**creating SqlCommand for Category DropDown list to sotre category name from database */ SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "Select CategoryId, CategoryName from JobCategory"; cmd1.Connection = con; con.Open();//open connection for all SqlDataReader rdr1 = cmd1.ExecuteReader(); CategoryDropDown.DataTextField = "CategoryName"; CategoryDropDown.DataValueField = "CategoryId"; CategoryDropDown.DataSource = rdr1; CategoryDropDown.DataBind(); ListItem l1 = new ListItem("Select Category", "-1"); CategoryDropDown.Items.Insert(0, l1); rdr1.Close();//close rdr1 SqlDataReader to write another new Query /*******************************************************/ /** creating SqlCommand for Location dropdown to store city name from database */ SqlCommand cmd2 = new SqlCommand(); cmd2.CommandText = "Select PinCode,CityName from cities"; cmd2.Connection = con; SqlDataReader rdr2 = cmd2.ExecuteReader(); LocationDropDownList.DataTextField = "CityName"; LocationDropDownList.DataValueField = "PinCode"; LocationDropDownList.DataSource = rdr2; LocationDropDownList.DataBind(); ListItem selectLocation = new ListItem("Select Location", "-1"); LocationDropDownList.Items.Insert(0, selectLocation); rdr2.Close(); /***************************************************************/ } } }
//Database connection for Category information to bind it to the Category Dropdownlist protected void CategoryBind() { using (var conn = new MySqlConnection(strcon)) { conn.Open(); string Query = "SELECT * FROM Category"; using (var cmd = new MySqlCommand(Query, conn)) { using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { CategoryDropDown.DataSource = reader; CategoryDropDown.DataValueField = "CatId"; CategoryDropDown.DataTextField = "CName"; CategoryDropDown.DataBind(); } } } } }
protected void InitializeCategoryTree() { if (!_DisplayCategorySearch) { ListItemCollection items = new ListItemCollection(); int st = 1; IList <CategoryLevelNode> categories = CategoryParentDataSource.GetCategoryLevels(0); foreach (CategoryLevelNode node in categories) { string prefix = string.Empty; for (int i = st; i <= node.CategoryLevel; i++) { prefix += " . . "; } items.Add(new ListItem(prefix + node.Name, node.CategoryId.ToString())); } CategoriesList.DataSource = items; CategoriesList.DataBind(); CategoryDropDown.DataSource = items; CategoryDropDown.DataBind(); } }