MySql简单.net增删改查

最新推荐文章于 2024-09-13 09:00:00 发布

C我要做程序员

最新推荐文章于 2024-09-13 09:00:00 发布

阅读量214

点赞数

分类专栏： asp.net MVC知识收集文章标签： mysql 数据库 sql

本文链接：https://blog.youkuaiyun.com/C136C136/article/details/120481421

版权

这篇博客详细介绍了如何在.NET环境下进行MySQL数据库的基本操作，包括创建数据库、数据的增删改查，以及查询单条记录的方法，是.NET开发者进行MySQL数据库交互的实用教程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

创建数据库

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.7.26 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `winycg` (
	`id` int (10),
	`name` varchar (300)
); 
insert into `winycg` (`id`, `name`) values('1','XXX你来做什么');
insert into `winycg` (`id`, `name`) values('2','程序员');
insert into `winycg` (`id`, `name`) values('3','程序员2');
insert into `winycg` (`id`, `name`) values('4','有人吗');
insert into `winycg` (`id`, `name`) values('10','name');
insert into `winycg` (`id`, `name`) values('6','香港人');
insert into `winycg` (`id`, `name`) values('7','Java');
insert into `winycg` (`id`, `name`) values('8','name');
insert into `winycg` (`id`, `name`) values('9','235');
insert into `winycg` (`id`, `name`) values('11','345');
insert into `winycg` (`id`, `name`) values('12','XX人');
insert into `winycg` (`id`, `name`) values('13','张三');
insert into `winycg` (`id`, `name`) values('14','张三');
insert into `winycg` (`id`, `name`) values('15','张三');
insert into `winycg` (`id`, `name`) values('16','张三');
insert into `winycg` (`id`, `name`) values('17','张三');
insert into `winycg` (`id`, `name`) values('18','张三');
insert into `winycg` (`id`, `name`) values('19','Java');
insert into `winycg` (`id`, `name`) values('20','Java');
insert into `winycg` (`id`, `name`) values('21','123');
insert into `winycg` (`id`, `name`) values('22','12');
insert into `winycg` (`id`, `name`) values('23','修改了');
insert into `winycg` (`id`, `name`) values('25','12');
insert into `winycg` (`id`, `name`) values('26','12');

在这里插入图片描述

mysql.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="mysql.aspx.cs" Inherits="ado.net打代码.mysql" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
        </div>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" />
        <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="新增" />
        <asp:Button ID="Button3" runat="server" OnClick

最低0.47元/天解锁文章