DetailsView 的用法(与GridView 一起使用)

最新推荐文章于 2019-07-09 22:00:01 发布

mndn_nana

最新推荐文章于 2019-07-09 22:00:01 发布

阅读量2.8k

点赞数

文章标签： asp textbox string server html div

特点: 一次只显示一条,而且分页也是跳到下一条数据.显示数据的格式与GridView 差不多,表格显示,很规范,很难任意布局
FormView 与 DataList 差不多,可以任意布局, 可以说随心所欲吧.^_^

DetailsView 主要是显示某一条记录的时候,显示详细数据.
下面有几个它的知识点:
1: 它的分页, 其实不是一页内多条记录的分页,而是一页内显示的就一条记录的相关字段,
    确切的说是指由同一个查询条件所得的一些记录,比如:这里的查询条件是: state ,要将
    GridView 的 DataKeyNames 设置为state, 这里它的默认值为: au_id

2: 在一列中按照需要组合显示多个数据字段

  实现方法是: 先转换为模板列,数据模板中添加一个Label,再绑定数据,编辑模板中也要添加一个TextBox,然后绑定数据,不用写处理代码,它自动可以更新的.

===================

前台页面 DetailsView.aspx 注意:这个事例没有写后台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DetailsView.aspx.cs" Inherits="DetailsView" %>
2

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4

<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

</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

mndn_nana

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫