C#连接MySQL数据库

最新推荐文章于 2022-05-27 23:34:14 发布

寒冰最强

最新推荐文章于 2022-05-27 23:34:14 发布

阅读量890

点赞数

CC 4.0 BY-SA版权

分类专栏： C# 文章标签： c# mysql C#连接MySQL C#连接数据库 C#mysql

本文链接：https://blog.youkuaiyun.com/adc_god/article/details/50446036

C# 专栏收录该内容

27 篇文章

订阅专栏

腾讯云ip 地址上海 115.159.180.185

效果查看

在winform框架下，添加using

using MySql.Data.MySqlClient;

主要代码

static string MyconnecString = "Server=115.159.180.185;Database=han;Uid=root;Pwd=123";

控件定义

private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.Button btn_lj;
private System.Windows.Forms.Button btn_dq;
private System.Windows.Forms.DataGridView dataGridView1;

private void btn_lj_Click(object sender, EventArgs e)
        {
            textBox1.Text = MyconnecString;
            MySqlConnection con = new MySqlConnection(MyconnecString);
            MySqlCommand cmd = new MySqlCommand();
            con.Open();
            cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "INSERT INTO stu VALUES (NULL,'Abcdd','Xuanwumen 10',122,'Abcdd','Xuanwumen 10')";
            cmd.ExecuteNonQuery();
            con.Close();

            btn_lj.Text = "连接完成";
        }

        private void btn_dq_Click(object sender, EventArgs e)
        {

            textBox2.Text = MyconnecString;
            MySqlConnection con = new MySqlConnection(MyconnecString);
            MySqlCommand cmd = new MySqlCommand();
            con.Open();
            cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            //SELECT * FROM mz;
            cmd.CommandText = "SELECT * FROM stu";
            MySqlDataAdapter adap = new MySqlDataAdapter(cmd);

            DataSet ds = new DataSet();
            adap.Fill(ds);
            //dataGridView1.DataSource = ds.Tables[1].DefaultView;
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
            ds.Dispose();

            btn_dq.Text = "读取完成";

        }