mysql网络读写_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 | |

+-------+-------------+------+-----+---------+----------------+