示例#1
0
 private void txtSearch_KeyPress(object sender, KeyPressEventArgs e)
 {
     if (e.KeyChar == (char)13)
     {
         if (this.GridView_Index == 1)
         {
             this.search = "select * from User where UserName Like '%" + txtSearch.Text + "%'";
         }
         if (this.GridView_Index == 2)
         {
             this.search = "select * from Link where LinkName Like '%" + txtSearch.Text + "%'";
         }
         if (this.GridView_Index == 3)
         {
             this.search = "select * from Comment where Comment Like '%" + txtSearch.Text + "%'";
         }
         if (this.GridView_Index == 4)
         {
             this.search = "select * from ListGroup where GroupName Like '%" + txtSearch.Text + "%'";
         }
         Function_Settings fnc = new Function_Settings();
         fnc.search_value(this.search);
         fnc.search_item(Main_GridView, this.search);
     }
 }
示例#2
0
        private void btnFilter_Click(object sender, EventArgs e)
        {
            this.search = "SELECT Name, Time, Action,Note FROM Log WHERE Action LIKE '%" + cb1.Text + "%' and Time BETWEEN '" +
                          "" + dateTimePicker1.Value.ToString() + "' AND '" + dateTimePicker2.Value.ToString() + "'AND Name LIKE '%" + cb2.Text + "%'";
            Function_Settings fnc = new Function_Settings();

            fnc.search_value(this.search);
            fnc.search_item(Log_GridView, this.search);
        }