private void BindGrid() { DateTime dtBegin = DateTime.Parse(tbx_begin.Text); DateTime dtEnd = DateTime.Parse(tbx_end.Text).AddDays(1); DataTable dt = EWF_Task_JobBLL.GetJobHasDecision(int.Parse(Session["UserID"].ToString()), dtBegin, dtEnd); string condition = " 1 = 1 "; if (ddl_App.SelectedValue != "0") { condition += " AND App = '" + ddl_App.SelectedValue + "'"; } if (tbx_MessageSubject.Text != "") { condition += " AND (Title like '%" + tbx_MessageSubject.Text + "%' OR MessageSubject like '%" + tbx_MessageSubject.Text + "%')"; } if (ddl_DecisionResult.SelectedValue != "0") { condition += " AND (DecisionResultName='" + ddl_DecisionResult.SelectedItem.Text + "')"; } dt.DefaultView.RowFilter = condition; dt.DefaultView.Sort = " TaskID desc "; gv_List.DataSource = dt.DefaultView; gv_List.TotalRecordCount = dt.DefaultView.Count; gv_List.PageIndex = (int)ViewState["PageIndex"]; gv_List.DataBind(); }