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(); } }