最近手头上有个小东西要做,其中需要涉及到MySQL数据库。以前从没做过基于MySQL的东西,上网一搜,原来有好多解决方案。下面提供其中的一种方法。剩下的有兴趣的自己去研究了。首先需要安装MySQL Connector/Net,这是一个MySQL的ADO.NET驱动。安装完后就可以很方便地操作MySQL数据库了。
连接代码很简单
VB.NET
'引入MySQL
Imports MySql.Data.MySqlClient
Private Sub connectBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles connectBtn.Click
Dim connStr As String
Dim conn As MySqlConnection
If Not conn Is Nothing Then conn.Close()
connStr = String.Format("server={0};user id={1}; password={2}; database=mysql; pooling=false", _
server.Text, userid.Text, password.Text)
Try
conn = New MySqlConnection(connStr)
conn.Open()
GetDatabases()
Catch ex As MySqlException
MessageBox.Show("Error connecting to the server: " + ex.Message)
End Try
End Sub
C#
using MySql.Data.MySqlClient;
private
void
connectBtn_Click(
object
sender, EventArgs e)
{
string connStr = " server=localhost;user id=root; password=mick; database=mysql; pooling=false " ;
MySqlConnection myconn = new MySqlConnection(connStr);
try
{
myconn.Open();
MySqlDataAdapter da = new MySqlDataAdapter( " select * from help_category " , myconn);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
catch (MySqlException exc)
{
MessageBox.Show(exc.Message);
}
finally
{
myconn.Close();
}
}
{
string connStr = " server=localhost;user id=root; password=mick; database=mysql; pooling=false " ;
MySqlConnection myconn = new MySqlConnection(connStr);
try
{
myconn.Open();
MySqlDataAdapter da = new MySqlDataAdapter( " select * from help_category " , myconn);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
catch (MySqlException exc)
{
MessageBox.Show(exc.Message);
}
finally
{
myconn.Close();
}
}