protected void ButtonSearchPF_Click(object sender, EventArgs e) { if (txt_search.Text != null) { int id = int.Parse(txt_search.Text); viewPF.RowFilter = "EMPLOYEE_ID = " + id; } GridViewProfit.DataSource = viewPF; GridViewProfit.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { conn = new DataConnection(1); string query = "select EMPLOYEE_ID, CURRENT_FIRST_NAME, CURRENT_LAST_NAME, PERCENTAGE_COPAY, DEDUCTABLE " + "from BENEFIT_PLANS bp, PERSONAL p " + "where bp.BENEFIT_PLANS_ID = p.BENEFIT_PLAN_ID"; tablePF = conn.getTable(query); viewPF = new DataView(tablePF); GridViewProfit.DataSource = tablePF; GridViewProfit.DataBind(); }