protected void txtsearch_TextChanged(object sender, EventArgs e)
{
DataTable ds1 = new DataTable();
ds1 = (DataTable)Session["QuotListDS"];
string strFilter = "";
strFilter = strFilter + " Code LIKE '%" + txtsearch.Text + "%' OR " +
" CustomerName LIKE '%" + txtsearch.Text + "%' OR " +
"ContactPerson LIKE '%" + txtsearch.Text + "%' OR " +
"QDate 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;
GvQuotaion.DataSource = DV.Table;
GvQuotaion.DataBind();
}
public void bindQuotation()
{
List <ParaList> para = new List <ParaList>()
{
new ParaList {
Key = "@i_CompId", Value = CurrentUser.CompId.ToString()
},
// new ParaList { Key = "@i_UserId", Value =CurrentUser.UserId },
};
ds = crmclient.list(para, "Quotation");
Session["QuotListDS"] = ds.Tables[0];
if (ds.Tables[0].Rows.Count > 0)
{
GvQuotaion.DataSource = ds.Tables[0];
GvQuotaion.DataBind();
}
}
