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();
}
