mysql.open()_C#连接mysql出现 conn.Open();有问题

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.Odbc;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingS...

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.Odbc;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySQLDriverCS;

namespace test

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

MySQLConnection conn = null;

conn = new MySQLConnection(new MySQLConnectionString("localhost", "students_courses", "root",

"3306").AsString);

conn.Open();

MySQLCommand commn = new MySQLCommand("set names gb2312", conn);

commn.ExecuteNonQuery();

string sql = "select * from student ";

MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);

DataSet ds = new DataSet();

mda.Fill(ds, "table1");

this.dataGrid1.DataSource = ds.Tables["table1"];

conn.Close();

}

}

}

展开