protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["login_id"] == null)
{
Response.Redirect("Login.aspx");
return;
}
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
using (conn)
{
SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM snacks WHERE item_status = 1", conn);
ad.Fill(dt);
ad = new SqlDataAdapter("SELECT category FROM snacks WHERE item_status = 1 GROUP BY category", conn);
ad.Fill(dt2);
}
SnackList.DataSource = dt;
SnackList.DataBind();
ddlCategory.DataSource = dt2;
ddlCategory.DataBind();
}
}
protected void btnShowAll_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
using (conn)
{
SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM snacks WHERE item_status = 1", conn);
ad.Fill(dt);
}
SnackList.DataSource = dt;
SnackList.DataBind();
}
protected void btnFilter_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
using (conn)
{
SqlDataAdapter ad = new SqlDataAdapter(string.Format("SELECT * FROM snacks WHERE item_status = 1 AND category LIKE '{0}'", ddlCategory.SelectedItem.Value.ToString()), conn);
ad.Fill(dt);
}
SnackList.DataSource = dt;
SnackList.DataBind();
}
