spieleprogrammierer.de - Forum und Wiki zur Spieleprogrammierung und Spieleentwicklung

Quellcode

namespace ListViewSample
{
  using System;
  using System.Drawing;
  using System.Collections;
  using System.ComponentModel;
  using System.Windows.Forms;
  using System.Data;
  using System.IO;
  using MySql.Data.MySqlClient;

  public class Form1 : System.Windows.Forms.Form
  {
    private System.ComponentModel.Container components;
    private MenuStrip menuStrip1;
    private ToolStripMenuItem programmToolStripMenuItem;
    private System.Windows.Forms.ListView listView1;

    public Form1()
    {
    InitializeComponent();
    InitializeListView();
    }
    protected override void Dispose( bool disposing )
    {
    if( disposing )
    {
        if (components != null) 
        {
        components.Dispose();
        }
    }
    base.Dispose( disposing );
    }

    private void InitializeComponent()
    {
        this.listView1 = new System.Windows.Forms.ListView();
        this.menuStrip1 = new System.Windows.Forms.MenuStrip();
        this.programmToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
        this.menuStrip1.SuspendLayout();
        this.SuspendLayout();
        // 
        // listView1
        // 
        this.listView1.ForeColor = System.Drawing.SystemColors.WindowText;
        this.listView1.FullRowSelect = true;
        this.listView1.GridLines = true;
        this.listView1.Location = new System.Drawing.Point(12, 61);
        this.listView1.Name = "listView1";
        this.listView1.Size = new System.Drawing.Size(804, 168);
        this.listView1.TabIndex = 0;
        this.listView1.UseCompatibleStateImageBehavior = false;
        this.listView1.View = System.Windows.Forms.View.Details;
        // 
        // menuStrip1
        // 
        this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.programmToolStripMenuItem});
        this.menuStrip1.Location = new System.Drawing.Point(0, 0);
        this.menuStrip1.Name = "menuStrip1";
        this.menuStrip1.Size = new System.Drawing.Size(831, 24);
        this.menuStrip1.TabIndex = 1;
        this.menuStrip1.Text = "menuStrip1";
        // 
        // programmToolStripMenuItem
        // 
        this.programmToolStripMenuItem.Name = "programmToolStripMenuItem";
        this.programmToolStripMenuItem.Size = new System.Drawing.Size(67, 20);
        this.programmToolStripMenuItem.Text = "Programm";
        // 
        // Form1
        // 
        this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
        this.ClientSize = new System.Drawing.Size(831, 297);
        this.Controls.Add(this.listView1);
        this.Controls.Add(this.menuStrip1);
        this.KeyPreview = true;
        this.MainMenuStrip = this.menuStrip1;
        this.Name = "Form1";
        this.Text = "Bewerber";
        this.Load += new System.EventHandler(this.Form1_Load);
        this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Form1_KeyDown);
        this.menuStrip1.ResumeLayout(false);
        this.menuStrip1.PerformLayout();
        this.ResumeLayout(false);
        this.PerformLayout();

    }

    protected void Form1_KeyDown (object sender, System.Windows.Forms.KeyEventArgs e)
    {
    if (e.KeyCode == Keys.Delete)
    {
        for (int i = listView1.SelectedItems.Count - 1; i >= 0; i--)
        {
        ListViewItem li = listView1.SelectedItems[i];
        listView1.Items.Remove(li);
        }
    }
    }


   

    public void InitializeListView()
    {
        ColumnHeader header1 = this.listView1.Columns.Add("Name", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header2 = this.listView1.Columns.Add("Nachname", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header3 = this.listView1.Columns.Add("Geburtstag", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header4 = this.listView1.Columns.Add("Name im Forum", 20 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header5 = this.listView1.Columns.Add("Team", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header6 = this.listView1.Columns.Add("Position", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header7 = this.listView1.Columns.Add("ICQ Nummer", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header8 = this.listView1.Columns.Add("E-Mail", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
        ColumnHeader header9 = this.listView1.Columns.Add("Datum", 10 * Convert.ToInt32(listView1.Font.SizeInPoints), HorizontalAlignment.Center);
    }

    public static void Main(string[] args) 
    {
    Application.Run(new Form1());
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        MySqlConnection connection = new MySqlConnection(Globals.ConnectionString);
        MySqlCommand command = connection.CreateCommand();
        command.CommandText = "SELECT * FROM Daten";

        MySqlDataReader Reader;
        connection.Open();
        Reader = command.ExecuteReader();

        while (Reader.Read())
        {
            string[] Items = new String[]{  Reader.GetValue(1).ToString(),
                                        Reader.GetValue(2).ToString(),
                                        Reader.GetValue(3).ToString(),
                                        Reader.GetValue(4).ToString(),
                                        Reader.GetValue(6).ToString(),
                                        Reader.GetValue(7).ToString(),
                                        Reader.GetValue(9).ToString(),
                                        Reader.GetValue(10).ToString(),
                                        Reader.GetValue(12).ToString()};                    
        }
        connection.Close();
    }

  }
}