.net mysql dll下载_c# asp.net MySql.Data.DLL6.2下载,.net连接mysql数据库的第三方插件

解压后只需要把mysql.data.dll引入到项目里就可以用了

代码示例:

C#代码

usingMySql.Data.MySqlClient;

protectedvoidbtn_login_Click(objectsender, EventArgs e)

{

stringmySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString;

MySqlConnection myCon =newMySqlConnection(mySqlCon);

try

{

myCon.Open();

MySqlCommand selSql =newMySqlCommand("Select * From tt.table Where uname=@uname", myCon);

selSql.Parameters.Add("@uname", MySqlDbType.VarChar, 32).Value =this.txt_name.Text.Trim();

MySqlDataReader mydr = selSql.ExecuteReader();

while(mydr.Read())

{

if(mydr.HasRows)

{

Response.Write("");

}

}

myCon.Close();

mydr.Close();

}

catch(Exception ex)

{

Response.Write("");

}

}

//

//  

//using MySql.Data.MySqlClient;

protected void btn_login_Click(object sender, EventArgs e)

{

string mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString;

MySqlConnection myCon = new MySqlConnection(mySqlCon);

try

{

myCon.Open();

MySqlCommand selSql = new MySqlCommand("Select * From tt.table Where uname=@uname", myCon);

selSql.Parameters.Add("@uname", MySqlDbType.VarChar, 32).Value = this.txt_name.Text.Trim();

MySqlDataReader mydr = selSql.ExecuteReader();

while (mydr.Read())

{

if (mydr.HasRows)

{

Response.Write("");

}

}

myCon.Close();

mydr.Close();

}

catch (Exception ex)

{

Response.Write("");

}

}

//

//

//

转载自黑色头发:http://heisetoufa.javaeye.com/