利用DataGrid编辑、修改、删除记录

来源：互联网发布：java死锁怎么解决编辑：程序博客网时间：2024/05/16 00:56

下面的这个例子提供了利用DataGrid编辑、修改、删除记录的方法，数据库字段名称和类型如下。

数据库aa中表 people：People.sql

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[People]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[People]GOCREATE TABLE [dbo].[People] ([pkID] [int] IDENTITY (1, 1) NOT NULL ,[FirstName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,[LastName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO

EditDataGridCS.aspx

<%@ Page Language="c#" debug="true"%><%@ Import Namespace="System.Data"%><%@ Import Namespace="System.Data.SqlClient" %><font face="arial" size="3"><b>Edit People</b></font><br><form runat="server"><HeaderStyle BorderColor="White" BackColor="black" ForeColor="White" Font-Bold="True" Font-Name="Arial" Font-Size="9" HorizontalAlign="Center"/><ItemStyle BorderColor="" BackColor="#FFFFF0" ForeColor="Black" Font-Name="Arial" Font-Size="8" Font-Bold="False" HorizontalAlign="Center"/><EditItemStyle BorderColor="" BackColor="#FFFFF0" ForeColor="Black" Font-Name="Arial" Font-Size="7" Font-Bold="False" HorizontalAlign="Center"/><PagerStyle Mode="NumericPages" Font-Size="8"/><Columns><HeaderTemplate><b> First Name </b></HeaderTemplate><ItemTemplate>'runat="server"/></ItemTemplate><EditItemTemplate>' runat="server" Width="100%"/></EditItemTemplate></asp:TemplateColumn><HeaderTemplate><b> Last Name </b></HeaderTemplate><ItemTemplate>' runat="server"/></ItemTemplate><EditItemTemplate><%# DataBinder.Eval(Container.DataItem, "LastName").ToString().Trim() %>' runat="server" Width="100%"/></EditItemTemplate></asp:TemplateColumn></asp:ButtonColumn> </Columns></asp:DataGrid></form>