关闭

NET连接MySQL数据库的CRUD

标签: NETNET连接MySQL数据库NET连接MySQLCRUD
42人阅读 评论(0) 收藏 举报
分类:

搭建环境

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


数据库信息


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;






1
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:33776次
    • 积分:734
    • 等级:
    • 排名:千里之外
    • 原创:38篇
    • 转载:0篇
    • 译文:1篇
    • 评论:5条
    文章存档
    最新评论