protected void btnSearch_Click(object sender, EventArgs e) { EmployeeInfo em = (EmployeeInfo)Session["Employee"]; string SheetNum = txtSheetNum.Text.ToString(); if (SheetNum != "" && ddlProject.SelectedValue == "") { DataTable dt = OfferPriceInfo.getSheetNumOfPrice1(SheetNum, em.EmployeeName.ToString()); DataView view = dt.DefaultView; string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"]; view.Sort = sort; if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); UI.BindCtrl(view, gvPrice, AspNetPager1); gvPrice.Rows[0].Visible = false; } else { UI.BindCtrl(view, gvPrice, AspNetPager1); } } else if (ddlProject.SelectedValue != "" && SheetNum == "") { DataTable dt = OfferPriceInfo.getProjectOfPrice1(ddlProject.SelectedItem.Text, em.EmployeeName.ToString()); DataView view = dt.DefaultView; string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"]; view.Sort = sort; if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); UI.BindCtrl(view, gvPrice, AspNetPager1); gvPrice.Rows[0].Visible = false; } else { UI.BindCtrl(view, gvPrice, AspNetPager1); } } else if (ddlProject.SelectedValue != "" && SheetNum != "") { DataTable dt = OfferPriceInfo.getBothNameOfPrice1(txtSheetNum.Text.ToString(), ddlProject.SelectedItem.Text.ToString(), em.EmployeeName.ToString()); DataView view = dt.DefaultView; string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"]; view.Sort = sort; if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); UI.BindCtrl(view, gvPrice, AspNetPager1); gvPrice.Rows[0].Visible = false; } else { UI.BindCtrl(view, gvPrice, AspNetPager1); } } else { gvDataBind(); } }