FormView 与 DataList 差不多,可以任意布局, 可以说随心所欲吧.^_^
DetailsView 主要是显示某一条记录的时候,显示详细数据.
下面有几个它的知识点:
1: 它的分页, 其实不是一页内多条记录的分页,而是一页内显示的就一条记录的相关字段,
确切的说是指 由同一个查询条件所得的 一些记录,比如:这里的查询条件是: state ,要将
GridView 的 DataKeyNames 设置为state, 这里它的默认值为: au_id
2: 在一列中按照需要组合显示多个数据字段
实现方法是: 先转换为模板列,数据模板中添加一个Label,再绑定数据,编辑模板中也要添加一个TextBox,然 后绑定数据,不用写处理代码,它自动可以更新的.
===================
前台页面 DetailsView.aspx 注意:这个事例没有写后台代码
1
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="DetailsView.aspx.cs" Inherits="DetailsView" %>2
3
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">4
5
<html xmlns="http://www.w3.org/1999/xhtml" >6
<head runat="server">7
<title>无标题页</title>8
</head>9
<body>10
<form id="form1" runat="server">11
<div>12
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>"13
SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [city], [state] FROM [authors]">14
</asp:SqlDataSource>15
16
</div>17
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"18
BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px"19
CellPadding="4" DataKeyNames="state" DataSourceID="SqlDataSource1" PageSize="5">20
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />21
<Columns>22
<asp:CommandField ShowSelectButton="True" />23
<asp:BoundField DataField="au_id" HeaderText="au_id" ReadOnly="True" SortExpression="au_id" />24
<asp:BoundField DataField="au_lname" HeaderText="au_lname" SortExpression="au_lname" />25
<asp:BoundField DataField="au_fname" HeaderText="au_fname" SortExpression="au_fname" />26
<asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" />27
<asp:BoundField DataField="city" HeaderText="city" SortExpression="city" />28
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />29
</Columns>30
<RowStyle BackColor="White" ForeColor="#330099" />31
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />32
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />33
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />34
</asp:GridView>35
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>"36
DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @au_id" InsertCommand="INSERT INTO [authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (@au_id, @au_lname, @au_fname, @phone, @address, @city, @state, @zip, @contract)"37
SelectCommand="SELECT * FROM [authors] WHERE ([state] = @state)" UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [contract] = @contract WHERE [au_id] = @au_id">38
<DeleteParameters>39
<asp:Parameter Name="au_id" Type="String" />40
</DeleteParameters>41
<UpdateParameters>42
<asp:Parameter Name="au_lname" Type="String" />43
<asp:Parameter Name="au_fname" Type="String" />44
<asp:Parameter Name="phone" Type="String" />45
<asp:Parameter Name="address" Type="String" />46
<asp:Parameter Name="city" Type="String" />47
<asp:Parameter Name="state" Type="String" />48
<asp:Parameter Name="zip" Type="String" />49
<asp:Parameter Name="contract" Type="Boolean" />50
<asp:Parameter Name="au_id" Type="String" />51
</UpdateParameters>52
<SelectParameters>53
<asp:ControlParameter ControlID="GridView1" Name="state" PropertyName="SelectedValue"54
Type="String" />55
</SelectParameters>56
<InsertParameters>57
<asp:Parameter Name="au_id" Type="String" />58
<asp:Parameter Name="au_lname" Type="String" />59
<asp:Parameter Name="au_fname" Type="String" />60
<asp:Parameter Name="phone" Type="String" />61
<asp:Parameter Name="address" Type="String" />62
<asp:Parameter Name="city" Type="String" />63
<asp:Parameter Name="state" Type="String" />64
<asp:Parameter Name="zip" Type="String" />65
<asp:Parameter Name="contract" Type="Boolean" />66
</InsertParameters>67
</asp:SqlDataSource>68
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"69
BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px"70
CellPadding="3" DataKeyNames="au_id" DataSourceID="SqlDataSource2" ForeColor="Black"71
GridLines="Vertical" Height="50px" Width="314px">72
<FooterStyle BackColor="#CCCCCC" />73
<EditRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />74
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />75
<Fields>76
<asp:BoundField DataField="au_id" HeaderText="ID" ReadOnly="True" SortExpression="au_id" />77
<asp:TemplateField HeaderText="姓名" SortExpression="au_lname">78
<EditItemTemplate>79
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("au_lname") %>' Width="69px"></asp:TextBox>80
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("au_fname") %>' Width="86px"></asp:TextBox>81
</EditItemTemplate>82
<InsertItemTemplate>83
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("au_lname") %>'></asp:TextBox>84
</InsertItemTemplate>85
<ItemTemplate>86
<asp:Label ID="Label1" runat="server" Text='<%# Bind("au_lname") %>'></asp:Label>87
<asp:Label ID="Label2" runat="server" Text='<%# Eval("au_fname") %>'></asp:Label>88
</ItemTemplate>89
</asp:TemplateField>90
<asp:BoundField DataField="phone" HeaderText="电话" SortExpression="phone" />91
<asp:BoundField DataField="address" HeaderText="地址" SortExpression="address" />92
<asp:BoundField DataField="city" HeaderText="city" SortExpression="city" />93
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />94
<asp:BoundField DataField="zip" HeaderText="zip" SortExpression="zip" />95
<asp:CheckBoxField DataField="contract" HeaderText="contract" SortExpression="contract" />96
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />97
</Fields>98
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />99
<AlternatingRowStyle BackColor="#CCCCCC" />100
</asp:DetailsView>101
</form>102
</body>103
</html>104