protected void btnbindrpt_Click(object sender, ImageClickEventArgs e) { if (ddlOption.SelectedIndex != 0) { string condition = string.Empty; if (ddlOption.SelectedIndex == 1) { condition = "convert(" + ddlFieldName.SelectedValue + ",System.String)='" + txtValue.Text + "'"; } else if (ddlOption.SelectedIndex == 2) { condition = "convert(" + ddlFieldName.SelectedValue + ",System.String) like '%" + txtValue.Text + "%'"; } else { condition = "convert(" + ddlFieldName.SelectedValue + ",System.String) Like '" + txtValue.Text + "%'"; } DataTable dtPrjecttask = (DataTable)Session["dtProjecttask"]; DataView view = new DataView(dtPrjecttask, condition, "", DataViewRowState.CurrentRows); GvrProjecttask.DataSource = view.ToTable(); Session["dtFilter"] = view.ToTable(); lblTotalRecords.Text = Resources.Attendance.Total_Records + " : " + view.ToTable().Rows.Count + ""; GvrProjecttask.DataBind(); AllPageCode(); } }
protected void GvrProjecttask_Sorting(object sender, GridViewSortEventArgs e) { DataTable dt = (DataTable)Session["dtFilter"]; string sortdir = "DESC"; if (ViewState["SortDir"] != null) { sortdir = ViewState["SortDir"].ToString(); if (sortdir == "ASC") { e.SortDirection = SortDirection.Descending; ViewState["SortDir"] = "DESC"; } else { e.SortDirection = SortDirection.Ascending; ViewState["SortDir"] = "ASC"; } } else { ViewState["SortDir"] = "DESC"; } dt = (new DataView(dt, "", e.SortExpression + " " + ViewState["SortDir"].ToString(), DataViewRowState.CurrentRows)).ToTable(); Session["dtFilter"] = dt; GvrProjecttask.DataSource = dt; GvrProjecttask.DataBind(); AllPageCode(); }
protected void GvrProjecttask_PageIndexChanging(object sender, GridViewPageEventArgs e) { GvrProjecttask.PageIndex = e.NewPageIndex; DataTable dt = (DataTable)Session["dtFilter"]; GvrProjecttask.DataSource = dt; GvrProjecttask.DataBind(); AllPageCode(); }
public void gridbind() { DataTable dtProjecttask = new DataTable(); dtProjecttask = objProjectTask.GetAllRecord(); if (dtProjecttask.Rows.Count > 0) { GvrProjecttask.DataSource = dtProjecttask; GvrProjecttask.DataBind(); Session["dtFilter"] = dtProjecttask; Session["dtProjecttask"] = dtProjecttask; } else { DataTable Dtclear = new DataTable(); GvrProjecttask.DataSource = Dtclear; GvrProjecttask.DataBind(); } lblTotalRecords.Text = Resources.Attendance.Total_Records + ": " + dtProjecttask.Rows.Count + ""; AllPageCode(); }