using MySql.Data.MySqlClient;
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;password=;database=profile;sslMode=none"); MySqlCommand cmd; MySqlDataAdapter da; DataTable dt; string sql;
private void LoadData(string sql,DataGridView dtg) { try { con.Open(); cmd.Connection = con; cmd.CommandText = sql; da.SelectCommand = cmd; da.Fill(dt); dtg.DataSource = dt; } catch(Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); da.Dispose(); } }
private void Form1_Load(object sender, EventArgs e) { sql = "SELECT * FROM `profile`"; LoadData(sql, dataGridView1); }
private void rdoFemale_CheckedChanged(object sender, EventArgs e) { sql = "SELECT * FROM `profile` WHERE `gender`='" + rdoFemale.Text + "'"; LoadData(sql, dataGridView1); } private void rdoMale_CheckedChanged(object sender, EventArgs e) { sql = "SELECT * FROM `profile` WHERE `gender`='" + rdoMale.Text + "'"; LoadData(sql, dataGridView1); }