public DataTable showPros() { //SELECT[page_title],[page_description],[meta_title],[meta_keywords],[meta_description],[Active] from tbl_Pages ORDER BY Id DESC; string query = string.Format("SELECT proName FROM product ORDER BY Id DESC"); try { return(db.runQery(query)); } catch { return(new DataTable()); } }
public DataTable userSearch(string filed, string vlau) { string query = string.Format("select * from Category where {0} like '%{1}%'", filed, vlau); try { return(db.runQery(query)); } catch { return(new DataTable()); } }