protected void SelectCategories()
 {
     dtCategory = taCategory.SelectAllSectionCategories();
     ddlCategory.DataSourceID = null;
     ddlCategory.DataSource = dtCategory;
     ddlCategory.DataTextField = dtCategory.Columns[1].ToString();
     ddlCategory.DataValueField = dtCategory.Columns[0].ToString();
     ddlCategory.DataBind();
     ddlCategory.Items.Insert(0, new ListItem("Please Select", ""));
 }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lblCategoryId = (Label)e.Row.FindControl("lblCategoryId");
            dtCategory = taCategory.SelectSectionCategorybyCategoryId(Convert.ToInt32(lblCategoryId.Text));
            if (dtCategory.Rows.Count > 0)
                lblCategoryId.Text = dtCategory[0].CategoryName.ToString();
            else
                lblCategoryId.Visible = false;

            LinkButton btnDel = (LinkButton)e.Row.FindControl("lbtnDelete");
            btnDel.Attributes.Add("OnClick", "return confirm('Are you sure to delete this record?');");
        }
    }
 private void BindData()
 {
     dtCategory = taCategory.SelectAllSectionCategories();
     if (dtCategory.Rows.Count > 0)
     {
         GridView1.DataSourceID = null;
         GridView1.DataSource = dtCategory;
         GridView1.DataBind();
     }
     else
     {
         lblMsg.Text = "No record found";
         return;
     }
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
            return;

        if (Request.QueryString["ID"] != null)
        {
            if (Request.QueryString["ID"] == "True")
            {
                lblMsg.Visible = true;
                lblMsg.Text = "Successfully Edited";
            }
        }

        if (Request.QueryString["CategoryId"] != null)
        {
            int CategoryId = Convert.ToInt32(Request.QueryString["CategoryId"]);
            dtCategory = taCategory.SelectSectionCategorybyCategoryId(CategoryId);

            if (dtCategory.Rows.Count > 0)
            {
                DataRow row = dtCategory.Rows[0];
                txtCategory.Text = row["CategoryName"].ToString();
            }
            else
            {
                lblMsg.Text = "No Record Found";
                btnEdit.Visible = false;
                return;
            }
        }
        else
        {
            lblMsg.Text = "No Record Found";
            btnEdit.Visible = false;
            return;
        }
    }