.net 如何连接mysql

序言：之前一直做JAVA的，没有尝试过做.net。但是由于需要，尝试用.net去连mysql;    

第一步安装驱动： 

    驱动地址：http://download.csdn.net/detail/zhengyong15984285623/5596241

mysql-connector-net-6.6.5.msi

  该为mysql与,net的驱动；（安装后进行下一步操作）

第二步:新建一个网站。选择 “网站”--> “添加引用”--> .NET”-->MySql.Data

使用：

1. 在网页的.cs文件中引用using MySql.Data.MySqlClient;文件头

2.在web.config.xml中配置数据源

 <connectionStrings>
    <add name="MySqlStr" connectionString="server = localhost; user id = root; password = root; database =vote"/>
  </connectionStrings>

3. 程序中获取数据源操控数据库：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //创建connnetction
        MySqlConnection myConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlStr"].ConnectionString);
        myConnection.Open();
        string insert = "insert into tuser(id,username,password) values('001','admin','123456')"; 
        MySqlCommand myCommand = new MySqlCommand(insert, myConnection);
        myCommand.ExecuteNonQuery();             
        string query = "select * from tuser";       
        myCommand = new MySqlCommand(query, myConnection);     
        MySqlDataReader myDataReader = myCommand.ExecuteReader();       
        string user = "";         
        while (myDataReader.Read() == true)        
        {              
            user += myDataReader["username"];          
            user += myDataReader["password"];         
        }            
        myDataReader.Close();     
        myConnection.Close();
        Label1.Text = user;
    }
}