-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathToDoRemove.cs
More file actions
31 lines (28 loc) · 903 Bytes
/
ToDoRemove.cs
File metadata and controls
31 lines (28 loc) · 903 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Windows;
namespace dbCon2
{
class ToDoRemove
{
public ToDoRemove(List<int> itemsToRemove)
{
using (MySqlConnection connection = new MySqlConnection(ConnectionSettings.ConectionVal()))
{
MySqlCommand comand = connection.CreateCommand();
foreach (int IDtoRemove in itemsToRemove)
{
connection.Open();
comand.CommandText = $"DELETE FROM `todo` WHERE ID = { IDtoRemove };";
comand.ExecuteReader();
connection.Close();
}
}
MessageBox.Show("Data has been removed successfully");
}
}
}