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
{
}
}