C# MySql 读写数据的示例代码

通过MySql connector net组件操作MYSQL数据库：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;


namespace DatabaseWindowsApp1
{
    public partial class Form1 : Form
    {
        private static string DB_CON_STR = "server=localhost;uid=root;pwd=root;database=test";
        public Form1()
        {
            InitializeComponent();
        }

        private void bindListView()
        {
            listView1.Clear();
            listView1.Columns.Add("ID");
            listView1.Columns.Add("Student");

            MySqlConnection con = new MySqlConnection(DB_CON_STR);
            con.Open();

            MySqlCommand cmd = new MySqlCommand("student");
            cmd.Connection = con;
            cmd.CommandType = CommandType.TableDirect;
            MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default);
            while (dr.Read())
            {
                System.Console.WriteLine(dr.GetInt32(0).ToString() + ": " + dr.GetString(1));

                // Create three items and three sets of subitems for each item.
                ListViewItem item1 = new ListViewItem(dr.GetInt32(0).ToString());
                // Place a check mark next to the item.
                item1.Checked = true;
                item1.SubItems.Add(dr.GetString(1));

                //Add the items to the ListView.
                listView1.Items.Add(item1);
            }

            dr.Close();
            con.Close();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            bindListView();

        }

        private void button1_Click(object sender, EventArgs e)
        {
            MySqlConnection con = new MySqlConnection(DB_CON_STR);
            con.Open();

            MySqlCommand cmd = new MySqlCommand("INSERT INTO student (name) value (@name)");
            cmd.Connection = con;
            cmd.Prepare();
            cmd.Parameters.AddWithValue("@name", textBox1.Text);
            int i = cmd.ExecuteNonQuery();
            if (i > 0)
                MessageBox.Show("插入记录成功");

            bindListView();
        }


    }
}

 

数据库结构：

mysql> describe class;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| sid   | int(11)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(32) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

 

mysql> describe student;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| sid   | int(32)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(32) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+