public void BindDropdown() { category.DataSource = _objRecipe.getCategory(); SubmittedBy.Items.Insert(0, new ListItem("--Select--", "NA")); Ingredients.Items.Insert(0, new ListItem("--Select--", "NA")); DataTable obj = _objRecipe.getRecipies(); DataTable distinctSubmittedBy = obj.DefaultView.ToTable(true, "SUBMITTEDBY"); for (int j = 0; j < distinctSubmittedBy.Rows.Count - 1; j++) { SubmittedBy.Items.Add(new ListItem { Text = distinctSubmittedBy.Rows[j]["SUBMITTEDBY"].ToString(), Value = j.ToString() }); } DataTable obj1 = _objRecipe.getIngredients(); DataTable distinct = obj1.DefaultView.ToTable(true, "Name"); for (int j = 0; j < distinct.Rows.Count - 1; j++) { Ingredients.Items.Add(new ListItem { Text = distinct.Rows[j]["NAME"].ToString(), Value = j.ToString() }); } Ingredients.DataBind(); category.DataBind(); SubmittedBy.DataBind(); }
public void BindDropdown() { int i = 0; DataTable obj = _objRecipe.getRecipies(); for (int j = 0; j < obj.Rows.Count; j++) { Name.Items.Add(new ListItem { Text = obj.Rows[j]["Name"].ToString(), Value = i.ToString() }); SubmittedBy.Items.Add(new ListItem { Text = obj.Rows[j]["SUBMITTEDBY"].ToString(), Value = i.ToString() }); } Name.DataBind(); SubmittedBy.DataBind(); DataTable obj1 = _objRecipe.getIngredients(); for (int j = 0; j < obj1.Rows.Count; j++) { Ingredients.Items.Add(new ListItem { Text = obj1.Rows[j]["NAME"].ToString(), Value = i.ToString() }); } Ingredients.DataBind(); }