新微赢技术网

标题: datagrid编辑、修改、删除、翻页例子 [打印本页]

作者: 卐孬孬卐 时间: 2009-3-16 13:51
标题: datagrid编辑、修改、删除、翻页例子
现在数据库中建立test表，字段分别为ID、Code、Name；
数据库的链接这里就不具体写了，数据库的链接和操作请求我写在了AreaInfo.cs中，代码中会用到，这里声明一下
<%@ Page language="c#" Codebehind="Update.aspx.cs" AutoEventWireup="false" Inherits="Client.Page.AreaInfo.Update" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
 <title>test</title>
 <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
 <meta name="CODE_LANGUAGE" Content="C#">
 <meta name="vs_defaultClientScript" content="JavaScript">
 <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout" bgcolor="ivory">
 
 
 
 <form runat="server" ID="Form1">
<TABLE id="Table1" cellSpacing="0" bgcolor="#6699cc" cellPadding="1" width="300" border="1">
<TR>
 <TD>test
 </TD>
</TR>
 <TD>

 <asp:DataGrid id="DG1" runat="server" BorderColor="green" Width="640" PageSize="5" AllowPaging="true"
 OnPageIndexChanged="Page_Grid" BorderWidth="1" CellPadding="3" AutoGenerateColumns="false"
 ShowHeader="true" Visible="true" OnEditCommand="People_Edit" OnCancelCommand="People_Cancel"
 OnUpdateCommand="People_Update" OnDeleteCommand="People_Delete">
 <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>
 <asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="ID" />
 <asp:TemplateColumn>
 <HeaderTemplate>
 代码
 </HeaderTemplate>
 <ItemTemplate>
 <asp:Label Text='<%# DataBinder.Eval(Container.DataItem, "Code").ToString().Trim() %>' runat="server" ID="Label1" NAME="Label1"/>
 </ItemTemplate>
 <EditItemTemplate>
 <asp:TextBox id="Code" Text='<%# DataBinder.Eval(Container.DataItem, "Code").ToString().Trim() %>' runat="server" Width="100%"/>
 </EditItemTemplate>
 </asp:TemplateColumn>
 <asp:TemplateColumn>
 <HeaderTemplate>
 名称
 </HeaderTemplate>
 <ItemTemplate>
 <asp:Label Width="200" Text='<%# DataBinder.Eval(Container.DataItem, "Name").ToString().Trim() %>' runat="server" ID="Label2" NAME="Label2"/>

作者: huangbo88 时间: 2009-12-9 09:05
顶顶更健康，越顶吃的越香。

欢迎光临新微赢技术网 (http://bbs.weiying.cn/)