public DataTable Search(string Query) { try { return(c.RunSelect(Query)); } catch { return(new DataTable()); } }
public bool Login(string Email, string Password) { string Query = String.Format("Select * From Member Where EmailAddress='{0}' and Password='******'", Email, Password); if (c.RunSelect(Query).Rows.Count == 1) { return(true); } else { return(false); } }
public int ProCount() { DataTable tbl = c.RunSelect("SELECT Count(*) FROM [Product]"); return(Convert.ToInt16(tbl.Rows[0][0].ToString())); }