<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>未命名页面</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align: center">
<strong><span style="color: #3333ff">GridView+FormView 示范数据 新增/修改/删除<br />
</span></strong>
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
CellPadding="4" DataKeyNames="EmployeeID" DataSourceID="SqlDataSource1" EmptyDataText="没有数据录可显示。"
ForeColor="#333333" GridLines="None" PageSize="5">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField ShowHeader="False">
<HeaderTemplate>
<asp:Button ID="btnInsert" runat="server" CausesValidation="False" CommandName="Insert"
Text="新增"></asp:Button>
</HeaderTemplate>
<ItemTemplate>
<asp:Button ID="btnEdit" runat="server" CausesValidation="False" CommandName="Edit"
Text="编辑"></asp:Button>
<asp:Button ID="btnDelete" runat="server" CausesValidation="False" CommandName="Delete"
Text="删除"></asp:Button>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" InsertVisible="False"
ReadOnly="True" SortExpression="EmployeeID" />
<asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
</Columns>
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:FormView ID="FormView1" runat="server" CellPadding="4" DataKeyNames="EmployeeID"
DataSourceID="SqlDataSource1" DefaultMode="Edit" ForeColor="#333333" Visible="False">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<EditItemTemplate>
<table style="width: 400px">
<tr>
<td style="width: 100px; text-align: left">
EmployeeID</td>
<td style="width: 392px; text-align: left">
<asp:Label ID="EmployeeIDLabel1" runat="server" Text='<%# Eval("EmployeeID") %>'></asp:Label>
<asp:TextBox ID="txtEmployeeID" runat="server" Text='<%# Bind("EmployeeID") %>'></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px; text-align: left">
LastName</td>
<td style="width: 392px; text-align: left">
<asp:TextBox ID="txtLastName" runat="server" Text='<%# Bind("LastName") %>'></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px; text-align: left">
FirstName</td>
<td style="width: 392px; text-align: left">
<asp:TextBox ID="txtFirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px; text-align: left">
Title</td>
<td style="width: 392px; text-align: left">
<asp:TextBox ID="txtTitle" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox></td>
</tr>
</table>
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="False" CommandName="Insert"
Text="新增"></asp:LinkButton>
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="更新"></asp:LinkButton>
<asp:LinkButton ID="CancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="取消"></asp:LinkButton>
</EditItemTemplate>
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString1 %>"
DeleteCommand="DELETE FROM [Employees] WHERE [EmployeeID] = @original_EmployeeID" InsertCommand="INSERT INTO [Employees] ([LastName], [FirstName], [Title]) VALUES (@LastName, @FirstName, @Title)"
ProviderName="<%$ ConnectionStrings:NorthwindConnectionString1.ProviderName %>"
SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [Title] FROM [Employees]"
UpdateCommand="UPDATE [Employees] SET [LastName] = @LastName, [FirstName] = @FirstName, [Title] = @Title WHERE [EmployeeID] = @original_EmployeeID" OldValuesParameterFormatString="original_{0}">
<DeleteParameters>
<asp:Parameter Name="original_EmployeeID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Title" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="original_EmployeeID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
</div>
</form>
</body>
</html>
Protected Sub GridView1_RowDataBound()Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
Dim oButton As Button
If e.Row.RowType = DataControlRowType.DataRow Then
'设定编辑钮的 CommandArgument
oButton = CType(e.Row.Cells(0).FindControl("btnEdit"), Button)
oButton.CommandArgument = e.Row.RowIndex.ToString
End If
End Sub
Protected Sub GridView1_RowCommand()Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
Dim iEditIndex As Integer
Select Case e.CommandName.ToUpper
Case "Edit".ToUpper '编辑模式
iEditIndex = GetEditIndex(CType(sender, GridView), CInt(e.CommandArgument))
FormView1.PageIndex = iEditIndex
FormView1.ChangeMode(FormViewMode.Edit) 'FormView 切换为编辑模式
FormView1.Visible = True 'FormView 显示
GridView1.Visible = False 'GridView 隐藏
Case "Insert".ToUpper '新增模式
'因为只有使用 EditItemTemplate，故将 InsertItemTemplate 设为 EditItemTemplate
FormView1.InsertItemTemplate = FormView1.EditItemTemplate
FormView1.ChangeMode(FormViewMode.Insert) 'FormView 切换为新增模式
FormView1.Visible = True 'FormView 显示
GridView1.Visible = False 'GridView 隐藏
End Select
End Sub
/**/''' <summary>
''' 取得编辑列索引。
''' </summary>
''' <param name="GridView">GridView 控件。</param>
''' <param name="RowIndex">GridView 的数据列索引。</param>
Private Function GetEditIndex()Function GetEditIndex(ByVal GridView As GridView, ByVal RowIndex As Integer) As Integer
Dim iEditIndex As Integer
If GridView.AllowPaging Then
'GridView 有分页时，要把考虑目前的页数及每页笔数
iEditIndex = (GridView.PageIndex) * GridView.PageSize + RowIndex
Else
'GridView 无分页时，直接使用 e.NewSelectedIndex
iEditIndex = RowIndex
End If
Return iEditIndex
End Function
Protected Sub FormView1_PreRender()Sub FormView1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.PreRender
Dim oFormView As FormView
Dim oLinkButton As LinkButton
Dim oTextBox As TextBox
oFormView = CType(sender, FormView)
If Not oFormView.Visible Then Exit Sub
Select Case oFormView.CurrentMode
Case FormViewMode.Edit '编辑模式
'隐藏新增钮
oLinkButton = oFormView.FindControl("InsertButton")
oLinkButton.Visible = False
'显示更新钮
oLinkButton = oFormView.FindControl("UpdateButton")
oLinkButton.Visible = True
'显示 EmployeeID 的 TextBox
oTextBox = oFormView.FindControl("txtEmployeeID")
oTextBox.Visible = False
Case FormViewMode.Insert
'显示新增钮
oLinkButton = oFormView.FindControl("InsertButton")
oLinkButton.Visible = True
'隐藏更新钮
oLinkButton = oFormView.FindControl("UpdateButton")
oLinkButton.Visible = False
'显示 EmployeeID 的 TextBox
oTextBox = oFormView.FindControl("txtEmployeeID")
oTextBox.Visible = True
End Select
End Sub
