Exemple #1
0
        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();
        }
Exemple #2
0
        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");
        }