private void Medlem_Load(object sender, EventArgs e)
{
String ConnectionString = "data source = localhost;DATABASE=gym;UID=Lasse;Password=Kagge; integrated security = True";
MySqlConnection conn = new MySqlConnection(ConnectionString);
conn.Open();
string sqlsats = $"select * from medlemmar";
MySqlCommand cmd = new MySqlCommand(sqlsats, conn);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
List <string> kolumner = new List <string>();
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (!dataReader.IsDBNull(i))
{
kolumner.Add(dataReader.GetString(i));
}
else
{
kolumner.Add("NULL");
}
}
Medlemmar md = new Medlemmar(int.Parse(kolumner[0]), kolumner[1], kolumner[2], kolumner[3], kolumner[4], int.Parse(kolumner[5]), kolumner[6], kolumner[7], kolumner[8], kolumner[9]);
minamedlemmar.Add(md);
}
conn.Close();
dataGridView1.DataSource = minamedlemmar;
}
private void button_radera_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Detta kommer att ändra i systemet. Vill du fortsätta?", "Delete data", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int id = int.Parse(txt_ID.Text);
String ConnectionString = "data source = localhost;DATABASE=gym;UID=Lasse;Password=Kagge; integrated security = True";
MySqlConnection conn = new MySqlConnection(ConnectionString);
conn.Open();
Medlemmar valdmedlem = (Medlemmar)dataGridView1.CurrentRow.DataBoundItem;
string sqlsats = $"delete from medlemmar where MID = {id}";
MySqlCommand cmd = new MySqlCommand(sqlsats, conn);
MySqlDataReader dataReader = cmd.ExecuteReader();
minamedlemmar.Remove(valdmedlem);
//nollställer listan
dataGridView1.DataSource = null;
dataGridView1.DataSource = minamedlemmar;
conn.Close();
}
}