<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
<%#Eval("列1") %>
<%#Eval("列2") %>
</ItemTemplate>
</asp:Repeater>
<!--Repeater控件完全由模版驱动,必须创建一个ItemTemplate, <%#Eval("列1") %>为绑定数据-->
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" RepeatColumns="3">
<ItemTemplate>
<%#Eval("列1") %>
<%#Eval("列2") %>
</ItemTemplate>
</asp:DataList>
<!--同Repeater控件差不多,默认输出表格形式,RepeatColumns显示多少列-->
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1">
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
<asp:DataPager runat="server" PageSize="3">
<Fields>
<asp:NextPreviousPagerField ShowFirstPageButton="true"
ShowLastPageButton="true" ShowNextPageButton="true"
ShowPreviousPageButton="true"/>
<asp:NumericPagerField />
</Fields>
</asp:DataPager>
</LayoutTemplate>
<ItemTemplate>
<%#Eval("列1") %>
</ItemTemplate>
<AlternatingItemTemplate>
<div style ="background-color:red">
<%#Eval("列1") %>
</div>
</AlternatingItemTemplate>
</asp:ListView>
<!--LayoutTemplate包含一个id为itemPlaceholder的PlaceHolder的控件,他不显示,会被ItemTemplate所代替
AlternatingItemTemplate是交替行的不同的css 利用DataPager控件进行分页,里面的意思各为
第一页,上一页。下一页和最后一页,还有一个为页数NumericPagerField-->
<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" DataSourceID="SqlDataSource2"
AutoGenerateRows="false" AutoGenerateDeleteButton="true" AutoGenerateEditButton="true"
AutoGenerateInsertButton="true" DataKeyNames="编号">
<Fields>
<asp:BoundField DataField="列1" HeaderText="比如动画:" />
<asp:BoundField DataField="列2" HeaderText="比如名字:" />
</Fields>
</asp:DetailsView>
<!--在表格中显示一条记录,DataField绑定数据,HeaderText标题,实现删除等等-->
<asp:SqlDataSource ID="SqlDataSource2" runat="server"SelectCommand="select 列1,列2 from 练习表"
InsertCommand="insert 练习表 (列1,列2) values(@列1,@列2)" DeleteCommand="delete 练习表 where 编号=@编号"
UpdateCommand="update 练习表 set 列1=@列1,列2=@列2 where 编号=@编号"
></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="select 列1,列2 from 练习表"
ConnectionString="<%ConnectionString:练习表 %>"></asp:SqlDataSource>
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource2" DataKeyNames="编号">
<ItemTemplate>
<%#Eval("列1") %><asp:Button ID="Button1" runat="server" Text="编辑" CommandName="Edit" />
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="Label1" runat="server" Text="列1"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" Text='<%#Bind("列1") %>'></asp:TextBox>
<asp:Button ID="Button2" runat="server" Text="更新" CommandName="Update" />
<asp:Button ID="Button3" runat="server" Text="取消更新" CommandName="Cancel" />
</EditItemTemplate>
<!--此控件完全由模版驱动,这个为实现更新功能,当点击编辑时出现,bind为双向绑定-->
</asp:FormView>
<ItemTemplate>
<%#Eval("列1") %>
<%#Eval("列2") %>
</ItemTemplate>
</asp:Repeater>
<!--Repeater控件完全由模版驱动,必须创建一个ItemTemplate, <%#Eval("列1") %>为绑定数据-->
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" RepeatColumns="3">
<ItemTemplate>
<%#Eval("列1") %>
<%#Eval("列2") %>
</ItemTemplate>
</asp:DataList>
<!--同Repeater控件差不多,默认输出表格形式,RepeatColumns显示多少列-->
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1">
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
<asp:DataPager runat="server" PageSize="3">
<Fields>
<asp:NextPreviousPagerField ShowFirstPageButton="true"
ShowLastPageButton="true" ShowNextPageButton="true"
ShowPreviousPageButton="true"/>
<asp:NumericPagerField />
</Fields>
</asp:DataPager>
</LayoutTemplate>
<ItemTemplate>
<%#Eval("列1") %>
</ItemTemplate>
<AlternatingItemTemplate>
<div style ="background-color:red">
<%#Eval("列1") %>
</div>
</AlternatingItemTemplate>
</asp:ListView>
<!--LayoutTemplate包含一个id为itemPlaceholder的PlaceHolder的控件,他不显示,会被ItemTemplate所代替
AlternatingItemTemplate是交替行的不同的css 利用DataPager控件进行分页,里面的意思各为
第一页,上一页。下一页和最后一页,还有一个为页数NumericPagerField-->
<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" DataSourceID="SqlDataSource2"
AutoGenerateRows="false" AutoGenerateDeleteButton="true" AutoGenerateEditButton="true"
AutoGenerateInsertButton="true" DataKeyNames="编号">
<Fields>
<asp:BoundField DataField="列1" HeaderText="比如动画:" />
<asp:BoundField DataField="列2" HeaderText="比如名字:" />
</Fields>
</asp:DetailsView>
<!--在表格中显示一条记录,DataField绑定数据,HeaderText标题,实现删除等等-->
<asp:SqlDataSource ID="SqlDataSource2" runat="server"SelectCommand="select 列1,列2 from 练习表"
InsertCommand="insert 练习表 (列1,列2) values(@列1,@列2)" DeleteCommand="delete 练习表 where 编号=@编号"
UpdateCommand="update 练习表 set 列1=@列1,列2=@列2 where 编号=@编号"
></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="select 列1,列2 from 练习表"
ConnectionString="<%ConnectionString:练习表 %>"></asp:SqlDataSource>
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource2" DataKeyNames="编号">
<ItemTemplate>
<%#Eval("列1") %><asp:Button ID="Button1" runat="server" Text="编辑" CommandName="Edit" />
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="Label1" runat="server" Text="列1"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" Text='<%#Bind("列1") %>'></asp:TextBox>
<asp:Button ID="Button2" runat="server" Text="更新" CommandName="Update" />
<asp:Button ID="Button3" runat="server" Text="取消更新" CommandName="Cancel" />
</EditItemTemplate>
<!--此控件完全由模版驱动,这个为实现更新功能,当点击编辑时出现,bind为双向绑定-->
</asp:FormView>