protected void btnSearch_Click(object sender, EventArgs e) { if (RbnRelieve.Checked == true) { //RbnTerminate.Checked = false; string searchstr = TxtSearch.Text; string likstr = searchstr + "%"; var search = (from a in db.M_TblAttritions where SqlMethods.Like(a.EmployeeID, likstr) || SqlMethods.Like(a.EmployeeName, likstr) || SqlMethods.Like(a.Designation, likstr) || SqlMethods.Like(a.ApprovedBy, likstr) || SqlMethods.Like(a.NoticePeriod,likstr)||SqlMethods.Like(a.RelievingDate,likstr)select a); if (search != null) { GridView1.DataSource = search; GridView1.DataBind(); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)