예제 #1
0
 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();
 }
예제 #2
0
        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();
        }