using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
string Database = "testar";
string UserID = "root";
string password = "tupptupp";
MySqlConnection connection = new MySqlConnection("server=localhost;database=" + Database + ";uid=" + UserID + ";password=" + password + "");

connection.Open();

MySqlConnection conn =
new MySqlConnection(connection.ConnectionString);

MySqlCommand cmd = connection.CreateCommand();

// Here goes the code needed to perform operations on the
cmd.CommandText = "SELECT * from kunder";
cmd.CommandType = CommandType.Text;
MySqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
string alio = reader["fornamn"].ToString();
string efternamn = reader["efternamn"].ToString();
ListViewItem lvi = new ListViewItem(alio);
listView1.Items.Add(lvi);
lvi.SubItems.Add(efternamn);
}

reader.Close();
connection.Close();
}

private void button1_Click(object sender, EventArgs e)
{
string namn = textFornamn.Text;
string efternamn = textEfternamn.Text;
string adress = textAdress.Text;
string post = textPost.Text;
string persnr = textPersnr.Text;

string Database = "testar";
string UserID = "root";
string password = "tupptupp";
MySqlConnection connection = new MySqlConnection("server=localhost;database=" + Database + ";uid=" + UserID + ";password=" + password + "");

MySqlConnection conn = new MySqlConnection(connection.ConnectionString);
MySqlCommand cmd = connection.CreateCommand();

cmd.CommandText = "INSERT INTO kunder (fornamn, efternamn, adress, ort, persnr) values(@namn,@efternamn,@adress,@post,@persnr)";
cmd.Parameters.AddWithValue("@namn", namn);
cmd.Parameters.AddWithValue("@efternamn", efternamn);
cmd.Parameters.AddWithValue("@adress", adress);
cmd.Parameters.AddWithValue("@post", post);
cmd.Parameters.AddWithValue("@persnr", persnr);

connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{

}
}
}