public void SearchListViewByEmail() { emailKeyword = keywordbox.Text; CsFilteredCustomerList nfcustomerlist = new CsFilteredCustomerList(nameKeyword, emailKeyword, CustomerTable); try { ConnectionClass.SearchCustomerByEmail(nfcustomerlist); cListBoard.DataSource = nfcustomerlist.fCustomerList; cListBoard.DataBind(); //keywordbox.Text = string.Empty; } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('error');</script>"); } finally { } }
public static void SearchCustomerByEmail(CsFilteredCustomerList fCustomerlist) { string hQuery = string.Format(@"SELECT customerID AS NO,(fName + ' '+ lName ) AS NAME, email AS 'E-MAIL',city AS 'CITY',Province AS 'PROVINCE', convert(varchar, RegisterDate,106) AS 'REGISTER DATE' FROM tblCustomer WHERE lOWER(Email) LIKE LOWER('%{0}%');", fCustomerlist.kWordEmail); cmdString = new SqlCommand(hQuery, cntString); try { cntString.Open(); SqlDataAdapter da = new SqlDataAdapter(cmdString); //DataTable dt = new DataTable(); DataSet ds = new DataSet(); da.Fill(ds); //ds.Tables.Add(dt); fCustomerlist.fCustomerList = ds.Tables[0]; } catch { } finally { cntString.Close(); } }
public void SearchListView() { nameKeyword = Session["SearchName"].ToString(); CsFilteredCustomerList nfcustomerlist = new CsFilteredCustomerList(nameKeyword, emailKeyword, CustomerTable); try { ConnectionClass.SearchCustomerByName(nfcustomerlist); CustomerList.DataSource = nfcustomerlist.fCustomerList; CustomerList.DataBind(); } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('error');</script>"); } finally { } }