C#连接MySql
- MySQL5.7.17(旧)下载安装
- 双向配置
- 基本操作
<一> 双向配置
1> MySql安装connector/Net(MySql安装可选项)
官网下载:https://dev.mysql.com/downloads/connector/net
2> 安装MySql.Net类库(VS):
<二> 基本操作
using System;
using MySql.Data.MySqlClient;
namespace MySQL_01
{
class Program
{
static Print.Print print = Console.Write;
static Print.Print println = Console.WriteLine;
static void Main(string[] args)
{
var conn_str = @"user=root;
pwd=123456;
server =localhost;
database =day1015;";
var conn = new MySqlConnection(conn_str);
try
{
conn.Open();
print("数据库 [day1015] 连接成功!");
//获取行数与列数
var command = new MySqlCommand("select count(*) from aaa", conn);
var reader = command.ExecuteReader();
var columns_number = reader.FieldCount;
var rows_number = 0;
if (reader.Read())
{
rows_number = Convert.ToUInt16(reader[0]);
}
println($"{ rows_number }行");
println($"{ columns_number }列");
reader.Close();
//输出数据库中所有数据
command = new MySqlCommand("select * from aaa", conn);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
for(int i = 0; i < columns_number; i++)
{
print(reader[0]+" ");
}
println("");
}
}
else
{
print("数据库为空!");
}
reader.Close();
}
catch(Exception e){
println(e.Message);
}
finally
{
conn.Close();
}
}
}
}