NET连接MySQL数据库的CRUD

CBeann

已于 2022-03-07 17:56:37 修改

阅读量1.5k

点赞数 9

分类专栏：【NET】文章标签： NET NET连接MySQL数据库 NET连接MySQL CRUD

于 2017-10-08 11:13:32 首次发布

本文链接：https://blog.csdn.net/qq_37171353/article/details/78173792

版权

【NET】专栏收录该内容

3 篇文章 5 订阅

订阅专栏

搭建环境

搭建环境详细步骤(超链接)

数据库信息

ADD

//获得Web.config中的配置信息
        string sqlCconnStr = ConfigurationManager.ConnectionStrings["MySqlStr"].ConnectionString;
        MySqlConnection sqlCon = new MySqlConnection(sqlCconnStr);//连接数据库 


        //打开连接
        sqlCon.Open();

        //SQL语句
        string sql = "insert into user (username,password) values ('csdn','csdn')";


        //获得MySsqlCommand
        MySqlCommand cmd = new MySqlCommand(sql, sqlCon);

        //执行SQL
         cmd.ExecuteNonQuery();


        cmd = null;
        sqlCon.Close();
        sqlCon = null;

DELETE

//获得Web.config中的配置信息
        string sqlCconnStr = ConfigurationManager.ConnectionStrings["MySqlStr"].ConnectionString;
        MySqlConnection sqlCon = new MySqlConnection(sqlCconnStr);//连接数据库 


        //打开连接
        sqlCon.Open();

        //SQL语句
        string sql = "delete from user where id = 3";


        //获得MySsqlCommand
        MySqlCommand cmd = new MySqlCommand(sql, sqlCon);

        //执行SQL
         int updateCount=cmd.ExecuteNonQuery();
        if (updateCount > 0)
        {
            Response.Write("删除成功");
        }
        else {
            Response.Write("删除失败");
        }


        cmd = null;
        sqlCon.Close();
        sqlCon = null;

UPDATE

  //获得Web.config中的配置信息
        string sqlCconnStr = ConfigurationManager.ConnectionStrings["MySqlStr"].ConnectionString;
        MySqlConnection sqlCon = new MySqlConnection(sqlCconnStr);//连接数据库 


        //打开连接
        sqlCon.Open();

        //SQL语句
        string sql = "update user set username = 'ndsc' where password = 'csdn'";


        //获得MySsqlCommand
        MySqlCommand cmd = new MySqlCommand(sql, sqlCon);

        //执行SQL
         int updateCount=cmd.ExecuteNonQuery();
        if (updateCount > 0)
        {
            Response.Write("更新成功");
        }
        else {
            Response.Write("更新失败");
        }


        cmd = null;
        sqlCon.Close();
        sqlCon = null;

SELECT

             //获得Web.config中的配置信息
        string sqlCconnStr = ConfigurationManager.ConnectionStrings["MySqlStr"].ConnectionString;
        MySqlConnection sqlCon = new MySqlConnection(sqlCconnStr);//连接数据库 

        //打开连接
        sqlCon.Open();

        //SQL语句
        string sql = "select username from user ";

        //获得MySsqlCommand
        MySqlCommand cmd = new MySqlCommand(sql, sqlCon);

        //执行SQL并且返回查询结果
        MySqlDataReader dataReader = cmd.ExecuteReader();

        //处理返回结果
        while (dataReader.Read())
        {

            //string obj = dataReader.GetString(0);
            string obj = dataReader.GetString("username");
            //Console.WriteLine(obj);
            Label1.Text += obj;
        }

        cmd = null;
        sqlCon.Close();
        sqlCon = null;