C# C#怎么链接mysql数据库?求高手回答。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 去下载个驱动:http://dev.mysql.com/downloads/connector/net/里面有事例,非常简单 The following code shows how to create a connection object. using System;using System.Data;using MySql.Data;using MySql.Data.MySqlClient;public class Tutorial1{ public static void Main() { string connStr = "server=localhost;user=root;database=world;port=3306;password=******;"; MySqlConnection conn = new MySqlConnection(connStr); try { Console.WriteLine("Connecting to MySQL..."); conn.Open(); // Perform databse operations conn.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } Console.WriteLine("Done."); }}using System;using System.Data;using MySql.Data;using MySql.Data.MySqlClient;public class Tutorial2{ public static void Main() { string connStr = "server=localhost;user=root;database=world;port=3306;password=******;"; MySqlConnection conn = new MySqlConnection(connStr); try { Console.WriteLine("Connecting to MySQL..."); conn.Open(); string sql = "SELECT Name, HeadOfState FROM Country WHERE Continent='Oceania'"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Console.WriteLine(rdr[0]+" -- "+rdr[1]); } rdr.Close(); conn.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } Console.WriteLine("Done."); }} 请教MySQL做过同步的朋友 Fedora 12 下运行程序报错:used MySql library isn't thread-safe mysql 查询的效率问题 列转行 mysql存储为一列 用sql语句如何转成一行 请各位高手看看这个存储过程有什么问题 谁知道"msqld已死,subsys被锁"该如何是好 ? mysql不能使用 出现ERROR 2013错误 开发中大型网站是选用sql server2000还是mysql更为合适? 千万级数据avg()查询优化,求助 从数据库导出到excel只显示前三行数据,求解决方法! 寻求mysql双向实时同步方案 关于mysql++的问题
http://dev.mysql.com/downloads/connector/net/里面有事例,非常简单
using System.Data;using MySql.Data;
using MySql.Data.MySqlClient;public class Tutorial1
{
public static void Main()
{
string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";
MySqlConnection conn = new MySqlConnection(connStr);
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
// Perform databse operations
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Console.WriteLine("Done.");
}
}using System;
using System.Data;using MySql.Data;
using MySql.Data.MySqlClient;public class Tutorial2
{
public static void Main()
{
string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";
MySqlConnection conn = new MySqlConnection(connStr);
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open(); string sql = "SELECT Name, HeadOfState FROM Country WHERE Continent='Oceania'";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read())
{
Console.WriteLine(rdr[0]+" -- "+rdr[1]);
} rdr.Close();
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Console.WriteLine("Done.");
}
}