一.说明
这一篇简单的个人总结,方便自己的复制粘贴,软件是Visual Studio 2019,SQLyog
在本系列的第一章讲述了ASP.net 与 Mysql的连接,与简单的操作,本篇来讲述占位符动态增加,其实也是没什么难度的训练,就不多废话了.
二.界面呈现部分
aspx前端界面部分代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm3.aspx.cs" Inherits="MyTest03.WebForm3" %>
<!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>
编号:<asp:TextBox ID="user_id" runat="server"></asp:TextBox>
<br />
姓名:<asp:TextBox ID="user_name" runat="server"></asp:TextBox>
<br />
<%-- 性别:<asp:DropDownList ID="user_sex" runat="server">
<asp:ListItem Value="1">男</asp:ListItem>
<asp:ListItem Value="0">女</asp:ListItem>
</asp:DropDownList>--%>性别:<asp:RadioButton ID="RadioButton1" runat="server" GroupName="user_sex" Text="男" />
<asp:RadioButton ID="RadioButton2" runat="server" GroupName="user_sex" Text="女" />
<br />
<br />
<asp:Button ID="add_btn" runat="server" OnClick="add_btn_Click" Text="添加按钮" />
<asp:Button ID="del_btn" runat="server" Text="删除按钮" />
<asp:Button ID="update_btn" runat="server" OnClick="update_btn_Click" Text="修改按钮" />
<asp:Button ID="select_btn" runat="server" Text="查询按钮" />
</div>
</form>
</body>
</html>
三.逻辑代码部分
cs代码部分:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;//引用Mysql包
namespace MyTest03
{
public partial class WebForm3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void add_btn_Click(object sender, EventArgs e)
{
//添加按钮
int sex = 0;//初始化值
string ids= user_id.Text.Trim();//提取界面控件的值
string name = user_name.Text.Trim();//提取界面控件的值
//判断用户选中的值,并赋值给sex
if (RadioButton1.Checked) {
sex = 1;
}
if (RadioButton2.Checked) {
sex = 0;
}
MySqlConnection conn = new MySqlConnection(MysqlCall.connstr);
conn.Open();//打开数据库控件
string sql = string.Format(@"insert into student values({0},'{1}',{2})", ids, name, sex);//简单的字符串拼接
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
int resules=cmd.ExecuteNonQuery();//执行SQL语句
cmd.Dispose();//各种关闭
conn.Close();//关闭
//由返回值来判断是否添加成功
if (resules > 0)
{
Response.Write("添加成功!");
}
else {
Response.Write("添加失败!");
}
}
}
}
四.结尾
此文是小白在学习张晨光老师的视频教学<<Asp.Net WEB服务器编程技术>>中做的学习笔记,一些知识点也是跟着教程走的,大家也可以去老师的主页去学习,再次谢谢大家.