C#连接MySQL
C#连接MySQL
程序代码:
--------------------------------------------------------------------------------
using MySQLDriverCS;
// 建立数据库连接
MySQLConnection DBConn;
DBConn = new MySQLConnection(new MySQLConnectionString("localhost","mysql","root","",3306).AsString);
DBConn.Open();
// 执行查询语句
MySQLCommand DBComm;
DBComm = new MySQLCommand("select Host,User from user",DBConn);
// 读取数据
MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
// 显示数据
try
{
while (DBReader.Read())
{
Console.WriteLine("Host = {0} and User = {1}", DBReader.GetString(0),DBReader.GetString(1));
}
}
finally
{
DBReader.Close();
DBConn.Close();
}
//关闭数据库连接
DBConn.Close();
下载 ByteFX.MySqlClient.dll
驱动
<%@ Page Language="C#" contentType="text/html;encoding=gb2312" debug="true"%>
<%@ Import Namespace="System"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="ByteFX.Data.MySqlClient"%>
<html>
<head>
<title>TestDb</title>
<script runat=server>
IDbConnection conn;
string connectionString;
void Page_Load(object sender,EventArgs e)
{
connectionString = "Data Source=localhost;"
+ "database=test;"
+ "user id=;password=;";
conn = new MySqlConnection(connectionString);
}
void InsertIntoDb(object sender,EventArgs e)
{
//Insert into mysql's database test 's table testmysql 80000 records
conn.Open();
IDbCommand cmd = conn.CreateCommand();
string sql;
for (int i = 0; i < 100000; i++)
{
sql = "Insert Into T (t_content,t_datetime) "
+ "values('测试记录:"+i.ToString()+"| Test Recorder:"+i.ToString()+"','"+DateTime.Now+"')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
cmd.Dispose();
conn.Close();
lInsert.Text = "Insert OK!";
}
</script>
</head>
<body>
<form runat=server>
<input type="button" value="Insert Records" onServerClick=InsertIntoDb runat=server />
<hr />
<asp:Label id=lInsert Text="" runat=server/>
</form>
</body>
</html>
string connstr=Setting.Instance().GetConnectionString("MySql");
MySqlConnection conn =new MySqlConnection(connstr);
conn.Open();
string query = "insert into myfirst(Id,Name) values(?Id,?Name)";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlParameter para1=new MySqlParameter("?Id",DbType.Int32); //这里要注意必须要用?号
MySqlParameter para2=new MySqlParameter("?Name",DbType.String);//这里要注意必须要用?号
para1.Value=5;
para2.Value="ddd";
cmd.Parameters.Add(para1);
cmd.Parameters.Add(para2);
cmd.ExecuteNonQuery();
浙公网安备 33010602011771号