c#连接数据库进行增删改查操作（详细篇）

c#连接数据库进行增删改查操作（详细篇）

1：这里先链接数据库，没有链接的参考上一篇的博文：
链接：https://blog.csdn.net/Tang_AHMET/article/details/105020004

2：这里对数据的增删改查操作

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);
            //}
            //reader.Close();
            #endregion

            #region 插入            
            //string username = "siki";
            //string password = "siki";
            创建语句
            MySqlCommand cmd = new MySqlCommand("insert into user set username='" + username + "'" + ",password='"+password+"'",conn);

            创建语句
            //MySqlCommand cmd = new MySqlCommand("insert into user set username=@un , password=@pwd", conn);
            //cmd.Parameters.AddWithValue("un", username);//添加值
            //cmd.Parameters.AddWithValue("pwd", password);
            执行语句
            //cmd.ExecuteNonQuery();
            #endregion

            #region 删除
            //MySqlCommand cmd = new MySqlCommand("delete from user where id=@id", conn);
            //cmd.Parameters.AddWithValue("id", 2);
            //cmd.ExecuteNonQuery();
            #endregion

            #region 更新
            //MySqlCommand cmd = new MySqlCommand("update user set password=@pwd where id =6", conn);
            //cmd.Parameters.AddWithValue("pwd", "sikiedu");
            //cmd.ExecuteNonQuery();
            #endregion

            conn.Close();
            Console.ReadKey();//程序暂停
           

        }
    }
}