c 读取mysql中表中数据_c#读取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;

//引入MySQL

using MySql.Data.MySqlClient;

using System.Data.SqlClient;

using System.Data.OleDb;

namespace c_01_连接查询MySQL数据库

{

public partial class frmQuery : Form

{

public frmQuery()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

MySqlConnection sqlCnn = new MySqlConnection();

sqlCnn.ConnectionString = "server = '127.0.0.1'; uid = 'root'; pwd = 'root'; database = 'ajax_stydy';";//连接字符串

MySqlCommand sqlCmd = new MySqlCommand();