C#连接、访问MySQL数据库

最新推荐文章于 2023-11-14 17:22:33 发布

唐孝辉

最新推荐文章于 2023-11-14 17:22:33 发布

阅读量195

点赞数 1

分类专栏：网络通信模块

本文链接：https://blog.csdn.net/weixin_33950757/article/details/90520143

版权

网络通信模块专栏收录该内容

5 篇文章 0 订阅

订阅专栏

01:添加mysqlData.dll到C#项目的引用中，就可以编写程序进行数据库的操作了

 class Program
    {
        static void Main(string[] args)
        {

            String mysqlStr = "server=localhost;User Id=root;password=1234;Database=mygame";
            //连接数据库
            MySqlConnection connection=new MySqlConnection(mysqlStr); 
            //打开数据库
            connection.Open();
            //查询数据表
            string commandStr ="select* from server";
            //执行命令语句sql
            MySqlCommand command=new MySqlCommand(commandStr,connection);
            //获取查询结果  
            using (MySqlDataReader reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    int id= reader.GetInt32(0);
                    string name =reader.GetString(1);
                    string ip = reader.GetString(2);
                    Console.WriteLine(id+" "+ name+"  "+ip);
                }
            }

            //关闭数据集  
            connection.Close();
            Console.ReadKey();
        }
    }

在这里插入图片描述
02：插入操作

  string str= "insert into mytable set id = @i, username = @u, password = @p";
            //插入数据
            MySqlCommand command1 = new MySqlCommand(str, connection);
            command1.Parameters.AddWithValue("i", 3);
            command1.Parameters.AddWithValue("u", "小伙子");
            command1.Parameters.AddWithValue("p", "185255");
            command1.ExecuteNonQuery();

删除


            MySqlCommand cmd = new MySqlCommand("delete from user where id = @id", conn);
            cmd.Parameters.AddWithValue("id", 18);

            cmd.ExecuteNonQuery();

更新

 MySqlCommand cmd = new MySqlCommand("update user set password = @pwd where id = 14", conn);
 cmd.Parameters.AddWithValue("pwd", "sikiedu.com");
 cmd.ExecuteNonQuery();