C# 数据库增删改查

    class Program
    {
        static void Main(string[] args)
        {
            string connectStr = "server=localhost;port=3306;database=xxxxdb;user=root;password=xxxxxx;";
            MySqlConnection conn = new MySqlConnection(connectStr);// 建立数据库连接
            conn.Open();   //建立连接，打开数据库

            // 查找数据
            try
            {
                string sql = "select * from tasks where task_id=1";
                Console.WriteLine("打开数据库成功");
                MySqlCommand read = new MySqlCommand(sql, conn);
                //read.ExecuteReader();// 执行查询
                MySqlDataReader reader = read.ExecuteReader();// 定义数据
                
                while (reader.Read())
                {
                    var name = reader["description"].ToString();// 根据用户id查看用户某一个信息
                    Console.WriteLine(name);
                    //Console.WriteLine(reader["task_id"].ToString());// 查找某一列数据的所有内容
                    //Console.WriteLine(reader["subject"].ToString());// 查找某一列数据的所有内容
                    //Console.WriteLine(reader["description"].ToString());// 查找某一列数据的所有内容
                }
                Console.WriteLine("执行成功");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());

            }

            // 增加一条数据
            try
            {
                // 增加一条数据
                string str = "daf";
                string str2 = "dafssf";
                string sql = $"insert into tasks value({4},'{str}','{str2}')";// 插入数据的命令
                Console.WriteLine("打开数据库成功");
                MySqlCommand read = new MySqlCommand(sql, conn);
                read.ExecuteReader(); //执行sql语句
                Console.WriteLine("执行成功");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }

            // 删除数据
            try
            {
                string sql = "delete from tasks where task_id='4' ";
                MySqlCommand read = new MySqlCommand(sql, conn);
                read.ExecuteNonQuery();
                Console.WriteLine("执行成功");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());

            }

            //修改内容
            try
            {
                string sql = "update tasks set subject='我是傻逼' where task_id='5'";
                MySqlCommand read = new MySqlCommand(sql, conn);
                read.ExecuteNonQuery();
                Console.WriteLine("执行成功");

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }

            finally { conn.Close(); }

        }
    }