Вот код С# windows form
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using MySql.Data.MySqlClient; namespace BD2 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void insertData() { string conStr = "server=127.0.0.1;user=mysql;" + "database=Test;password=mysql;sslMode=none;"; using (MySqlConnection con = new MySqlConnection(conStr)) { try { string sql = "INSERT INTO friends (name, lastname, age)" + "VALUES ('Misha', 'Ivanov', 26)"; MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Данные добавлены!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } private void button1_Click(object sender, EventArgs e) { insertData(); } private DataTable GetComments() { DataTable dt = new DataTable(); MySqlConnectionStringBuilder mysqlCSB; mysqlCSB = new MySqlConnectionStringBuilder(); mysqlCSB.Server = "127.0.0.1"; mysqlCSB.Database = "Test"; mysqlCSB.UserID = "mysql"; mysqlCSB.Password = "mysql"; mysqlCSB.SslMode = MySqlSslMode.None; string queryString = @"SELECT id, name, lastname, age FROM friends WHERE name >= CURDATE()"; using (MySqlConnection con = new MySqlConnection()) { con.ConnectionString = mysqlCSB.ConnectionString; MySqlCommand com = new MySqlCommand(queryString, con); try { con.Open(); using (MySqlDataReader dr = com.ExecuteReader()) { if (dr.HasRows) { dt.Load(dr); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } return dt; } private void button2_Click(object sender, EventArgs e) { dataGridView1.DataSource = GetComments(); } } }