public Acronym CreateAcronym(Acronym ac) { string sql = "INSERT INTO AcronymTable (Acronym, Acronym_Meaning, Description) Values ('" + ac._abb + "', '" + ac._me + "', '" + ac._de + "');"; using (SQLiteConnection myConnection = new SQLiteConnection(GlobalConnections.CnnString("AlgotecAcronymGuide"))) { using (SQLiteCommand cmd = new SQLiteCommand(myConnection)) { myConnection.Open(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); //cmd.CommandText = "SELECT * FROM AcronymTable;"; //using (SQLiteDataReader reader = cmd.ExecuteReader()) //{ // while (reader.Read()) // { // Console.WriteLine("Acronym - {0}, Meaning - {1}, Description - {2}", reader["Acronym"], reader["Acronym_Meaning"], reader["Description"]); // } //} } } return(null); }
public List <String> findAcronym(string abb) { List <String> matchingAcronyms = new List <String> (); using (SQLiteConnection myConnection = new SQLiteConnection(GlobalConnections.CnnString("AlgotecAcronymGuide"))) { using (SQLiteCommand cmd = new SQLiteCommand(myConnection)) { myConnection.Open(); string sql = "SELECT * FROM AcronymTable WHERE Acronym LIKE '%" + abb + "%';"; cmd.CommandText = sql; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { String str = (String.Format("{0} \t {1} \t\t{2}", reader["Acronym"], reader["Acronym_Meaning"], reader["Description"])); //matchingAcronyms.Add(String.Format("{0} \t {1} \t{2}", reader["Acronym"], reader["Acronym_Meaning"], reader["Description"])); matchingAcronyms.Add(str); } } } } return(matchingAcronyms); }