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:

tr = myConn.BeginTransaction(IsolationLevel.ReadCommitted);

            com = new MySqlCommand("SELECT Von, Was from t_vertrag where name_id = ?id", myConn, tr);

            id = com.Parameters.Add("?id", MySqlDbType.Int32, 4);
            id.Value = n_id;

            com.Prepare();

            try
            {
                dr = com.ExecuteReader();

                while (dr.Read())
                {
                    ListViewItem temp = new ListViewItem(dr.GetString(0));
                    temp.SubItems.Add("Anfang des Vertrages: " + dr.GetString(1));
                    listViewDatenAnzeigen.Items.Add(temp);
                }

                dr.Close();
                tr.Commit();

            }
            catch (MySqlException err)
            {
                MessageBox.Show(err.ToString());
                tr.Rollback();
            }