public void UpdateElement(sqliteBase sb, sqliteBase seletcter, string tableName) { string request = "UPDATE " + tableName + " SET " + sb.valueName + " = " + "@param" + " WHERE " + seletcter.valueName + " = " + seletcter.baseValue; SQLiteCommand Command = new SQLiteCommand(request, M_dbConnection); Command.Parameters.AddWithValue("@param", sb.baseValue); int updated = Command.ExecuteNonQuery(); }
public void UpdateCalendarObject(sqliteBase sb, int objectID, string tableName) { string request = "UPDATE " + tableName + " SET " + sb.valueName + " = " + "@param" + " WHERE " + elementID + " = " + objectID; SQLiteCommand Command = new SQLiteCommand(request, Core.AppCore.dCore.M_dbConnection); Command.Parameters.AddWithValue("@param", sb.baseValue); int updated = Command.ExecuteNonQuery(); Console.WriteLine(updated + "row upadted"); }