public static DataSet GetMatchedAttributes(int birthNumber, string fortune, int nameNumber) { string query = "SELECT attribute.attribute as attribute " + "FROM attribute INNER JOIN [attribute-birthnumber] ON attribute.Id = [attribute-birthnumber].IDattribute " + "WHERE ((([attribute-birthnumber].birthNumber)={0})) " + "UNION ALL " + "SELECT attribute.attribute as attribute " + "FROM fortune INNER JOIN (attribute INNER JOIN [attribute-fortune] ON attribute.Id = [attribute-fortune].IDattribute) ON fortune.Id = [attribute-fortune].IDfortune " + "WHERE (((fortune.fortune)='{1}')) " + "UNION ALL " + "SELECT attribute.attribute as attribute " + "FROM attribute INNER JOIN [attribute-namenumber] ON attribute.Id = [attribute-namenumber].IDattribute " + "WHERE ((([attribute-namenumber].nameNumber)={2}))"; DataSet vDataset = null; vDataset = MicrosoftAccessConnector.Recuperar_Consulta(string.Format(query, birthNumber, fortune, nameNumber)); return(vDataset); }
public static string GetFAQContent() { string query = "SELECT content FROM cms WHERE Id=4"; DataSet vDataset = null; vDataset = MicrosoftAccessConnector.Recuperar_Consulta(query); DataTable tbl = vDataset.Tables[0]; string content = tbl.Rows[0]["content"].ToString(); return(content); }