1using MySql.Data.MySqlClient;
2
3string connectionstring = "server=localhost;user id=root;password=myPasswort;persist security info=no;database=" +
4 "myDataBase;Port=3306;Allow Zero Datetime=true;"
5
6// get several data from a database
7public virtual Dictionary<string, string> ShowVariables()
8 {
9 Dictionary<string, string> dict = new Dictionary<string, string>();
10 MySqlConnection conn = new MySqlConnection(connectionstring);
11 MySqlDataReader reader;
12 try
13 {
14 conn.Open();
15 MySqlCommand cmd = new MySqlCommand(
16 SqlStatements.showMySqlStatus(), conn);
17 reader = cmd.ExecuteReader();
18 while (reader.Read())
19 {
20 dict.Add(reader.GetString(0), reader.GetString(1));
21 }
22
23 reader.Close();
24 }
25 finally
26 {
27 if (conn.State != ConnectionState.Closed)
28 {
29 conn.Close();
30 }
31 }
32
33 return dict;
34 }
35
36// execute a non query
37private bool DeleteSomeThing(string table, string column, object value)
38 {
39 bool result = false;
40 MySqlConnection conn = new MySqlConnection(connectionstring);
41
42 try
43 {
44 conn.Open();
45 string objectString;
46 if (value.GetType().Equals(typeof(string)))
47 objectString = "'" + value + "'";
48 else
49 objectString = value.ToString();
50 string sql = string.Format(
51 SqlStatements.deleteSomeThing(),
52 table,
53 column,
54 objectString);
55 MySqlCommand cmd = new MySqlCommand(sql, conn);
56 MySqlTransaction transaction = conn.BeginTransaction();
57 cmd.Transaction = transaction;
58 cmd.ExecuteNonQuery();
59 result = true;
60 transaction.Commit();
61 }
62 finally
63 {
64 if (conn.State != ConnectionState.Closed)
65 conn.Close();
66 }
67
68 return result;
69 }
70
71