C#连接MySQL操作详细教程

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;//引用命名空间

namespace MySQL数据库操作
{
 class Program
 {
  static void Main(string[] args)
  {
   string connStr = "Database=test007;Data Source=127.0.0.1;port=3306;User Id=root;Password=124638;";
   // string connStr = "Database=test007;datasource=127.0.0.1;port=3306;user=root;pwd=124638;";
   MySqlConnection conn = new MySqlConnection(connStr);

   //打开链接
   conn.Open();


   #region 查询
   ////创建命令
   //MySqlCommand cmd = new MySqlCommand("select * from user ", conn);

   ////执行命令--读取数据
   //MySqlDataReader reader= cmd.ExecuteReader();

   ////读取数据
   //while(reader.Read())//判断是否有数据--//读取一行记录
   //{

   // string username= reader.GetString("username");
   // string password = reader.GetString("password");
   // Console.WriteLine(username + ":" + password);
   /