protected void btnSearch_Click(object sender, EventArgs e) { DataTable ds1 = new DataTable(); ds1 = (DataTable)Session["LeadListDS"]; string strFilter = ""; strFilter = strFilter + " LeadDate LIKE '%" + txtsearch.Text + "%' OR " + " LeadNo LIKE '%" + txtsearch.Text + "%' OR " + " CustomerName LIKE '%" + txtsearch.Text + "%' OR " + "Phone1 LIKE '%" + txtsearch.Text + "%' OR " + "Email LIKE '%" + txtsearch.Text + "%' OR "; //"LeadMobile LIKE '%" + txtsearch.Text + "%' OR " + //"LeadEmail LIKE '%" + txtsearch.Text + "%' OR " + //"FollowupDate1 LIKE '%" + txtsearch.Text + "%' OR " + //"Remark LIKE '%" + txtsearch.Text + "%' OR " + //"Convert(TotalAmount,'System.String') LIKE '" + txtsearch.Text + "%' OR " + //"Convert(NetAmount,'System.String') LIKE '" + txtsearch.Text + "%' OR "; strFilter = strFilter.Substring(0, strFilter.Length - 3); DV = ds1.DefaultView; DV.RowFilter = strFilter; GvLeadList.DataSource = DV.Table; GvLeadList.DataBind(); }
public void bindLeadList() { List <ParaList> para = new List <ParaList>() { new ParaList { Key = "@i_CompId", Value = CurrentUser.CompId }, new ParaList { Key = "@i_UserId", Value = CurrentUser.UserId }, }; ds = crmclient.list(para, "Lead"); Session["LeadListDS"] = ds.Tables[0]; if (ds.Tables[0].Rows.Count > 0) { GvLeadList.DataSource = ds.Tables[0]; GvLeadList.DataBind(); } }