vs2015 dynamicweb8-10 gridview CommandField 删除的使用

最新推荐文章于 2022-11-10 21:28:11 发布

虾米大王

最新推荐文章于 2022-11-10 21:28:11 发布

阅读量217

点赞数

分类专栏： c# asp.net 文章标签： c#

本文链接：https://blog.csdn.net/modern358/article/details/115393890

版权

c# 同时被 2 个专栏收录

284 篇文章 0 订阅

订阅专栏

asp.net

258 篇文章 2 订阅

订阅专栏

webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_10.WebForm1" %>

<!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">
    <center><h3>学生信息管理</h3></center>
    <div style="width:100%;height:200px;overflow:scroll;">
        <asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="stu_id" DataSourceID="SqlDataSource1" PageSize="5" OnRowCreated="GridView1_RowCreated">
            <Columns>
                <asp:BoundField DataField="stu_id" HeaderText="学号" ReadOnly="True" SortExpression="stu_id" />
                <asp:BoundField DataField="stu_name" HeaderText="姓名" SortExpression="stu_name" />
                <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
                <asp:BoundField DataField="birth_date" HeaderText="生日" SortExpression="birth_date" />
                <asp:BoundField DataField="major" HeaderText="专业" SortExpression="major" />
                <asp:CheckBoxField DataField="isCPC" HeaderText="是否入党" SortExpression="isCPC" />
                <asp:BoundField DataField="email" HeaderText="电子邮件" SortExpression="email" />
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:studentMISConnectionString %>" DeleteCommand="DELETE FROM [student] WHERE [stu_id] = @stu_id" InsertCommand="INSERT INTO [student] ([stu_id], [stu_name], [sex], [birth_date], [major], [isCPC], [email]) VALUES (@stu_id, @stu_name, @sex, @birth_date, @major, @isCPC, @email)" SelectCommand="SELECT * FROM [student]" UpdateCommand="UPDATE [student] SET [stu_name] = @stu_name, [sex] = @sex, [birth_date] = @birth_date, [major] = @major, [isCPC] = @isCPC, [email] = @email WHERE [stu_id] = @stu_id">
            <DeleteParameters>
                <asp:Parameter Name="stu_id" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="stu_id" Type="String" />
                <asp:Parameter Name="stu_name" Type="String" />
                <asp:Parameter Name="sex" Type="String" />
                <asp:Parameter Name="birth_date" Type="DateTime" />
                <asp:Parameter Name="major" Type="String" />
                <asp:Parameter Name="isCPC" Type="Boolean" />
                <asp:Parameter Name="email" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="stu_name" Type="String" />
                <asp:Parameter Name="sex" Type="String" />
                <asp:Parameter Name="birth_date" Type="DateTime" />
                <asp:Parameter Name="major" Type="String" />
                <asp:Parameter Name="isCPC" Type="Boolean" />
                <asp:Parameter Name="email" Type="String" />
                <asp:Parameter Name="stu_id" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

webform1.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace dynamicweb8_10
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        //删除
        protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                LinkButton lnkDel = (LinkButton)e.Row.Cells[7].Controls[2];
                if (lnkDel.Text == "删除")
                {
                    lnkDel.Attributes["onclick"] = "return confirm('确定要删除这条记录吗？')";
                }
            }
        }
    }
}

web.config

<?xml version="1.0" encoding="utf-8"?>

<!--
  有关如何配置 ASP.NET 应用程序的详细信息，请访问
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
    <connectionStrings>
        <add name="studentMISConnectionString" connectionString="Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=studentMIS;Persist Security Info=True;User ID=sa;Password=123456"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
      <compilation debug="true" targetFramework="4.5" />
      <httpRuntime targetFramework="4.5" />
    </system.web>

</configuration>

sql

--学生管理系统库
create database studentMIS;


use studentMIS;

--学生表
create table student(
	stu_id nvarchar(8) not null,
	stu_name nvarchar(8) not null,
	sex nvarchar(2) not null,
	birth_date datetime,
	major nvarchar(50) not null,
	isCPC bit,
	email nvarchar(20),
	primary key(stu_id)
);


--课程表
create table course(
	course_id smallint identity(1,1) not null,
	course_name nvarchar(50) not null
);


--成绩表
create table result(
	stu_id nvarchar(8) not null,
	course_id smallint not null,
	mark decimal(6,0) not null,
	primary key(stu_id,course_id)
);


insert into student values('20160101','王霞','女','1998-10-23','计算机信息管理','true','wx@163.com');
insert into student values('20160102','张大力','男','1998-07-02','计算机信息管理','false','zdf@163.com');
insert into student values('20160103','李长军','男','1998-5-14','计算机信息管理','false','lcj@163.com');
insert into student values('20160104','韩华东','男','1998-12-07','计算机信息管理','false','8562478@qq.com');
insert into student values('20160105','万芳','女','1998-01-27','软件技术','false','5478518@qq.com');
insert into student values('20160106','赵中千','男','1998-08-12','软件技术','true','5582178@qq.com');
insert into student values('20160107','吴空俊','男','1998-05-21','软件技术','false','4845512@qq.com');
insert into student values('20160108','方文其','男','1998-06-05','软件技术','false','8412563@qq.com');
insert into student values('20160109','唐汉','男','1998-04-18','计算机应用','false','1546315@qq.com');
insert into student values('20160110','刘含斌','男','1998-10-07','计算机应用','false','741526@qq.com');

insert into course values('高等数学');
insert into course values('大学英语');
insert into course values('邓小平理论概述');
insert into course values('毛泽东思想概述');
insert into course values('C语言程序设计');
insert into course values('数据结构');

insert into result values('20160101',1,'71');
insert into result values('20160101',2,'72');
insert into result values('20160101',3,'73');
insert into result values('20160101',4,'74');
insert into result values('20160101',5,'75');
insert into result values('20160101',6,'76');
insert into result values('20160102',1,'60');
insert into result values('20160102',2,'61');
insert into result values('20160102',3,'60');
insert into result values('20160102',4,'62');
insert into result values('20160102',5,'60');
insert into result values('20160102',6,'59');

虾米大王

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
vs2015 dynamicweb8-10 gridview CommandField 删除的使用

webform1.aspx<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_10.WebForm1" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"><meta http-equi
复制链接

扫一扫