这个练习,也是使用可视化设计,点选的各个配置项,代码是最后的结果。
webform1.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="test9_5.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListView ID="ListView1" runat="server" DataKeyNames="id" DataSourceID="SqlDataSource1">
<AlternatingItemTemplate>
<tr style="background-color:#FFF8DC;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="删除" />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="编辑" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="titleLabel" runat="server" Text='<%# Eval("title") %>' />
</td>
<td>
<asp:Label ID="contentLabel" runat="server" Text='<%# Eval("content") %>' />
</td>
<td>
<asp:Label ID="categoriesLabel" runat="server" Text='<%# Eval("categories") %>' />
</td>
<td>
<asp:Label ID="type1Label" runat="server" Text='<%# Eval("type1") %>' />
</td>
<td>
<asp:Label ID="issueDateLabel" runat="server" Text='<%# Eval("issueDate") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<EditItemTemplate>
<tr style="background-color:#008A8C;color: #FFFFFF;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="更新" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="取消" />
</td>
<td>
<asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:TextBox ID="titleTextBox" runat="server" Text='<%# Bind("title") %>' />
</td>
<td>
<asp:TextBox ID="contentTextBox" runat="server" Text='<%# Bind("content") %>' />
</td>
<td>
<asp:TextBox ID="categoriesTextBox" runat="server" Text='<%# Bind("categories") %>' />
</td>
<td>
<asp:TextBox ID="type1TextBox" runat="server" Text='<%# Bind("type1") %>' />
</td>
<td>
<asp:TextBox ID="issueDateTextBox" runat="server" Text='<%# Bind("issueDate") %>' />
</td>
</tr>
</EditItemTemplate>
<EmptyDataTemplate>
<table runat="server" style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
<tr>
<td>未返回数据。</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="插入" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="清除" />
</td>
<td> </td>
<td>
<asp:TextBox ID="titleTextBox" runat="server" Text='<%# Bind("title") %>' />
</td>
<td>
<asp:TextBox ID="contentTextBox" runat="server" Text='<%# Bind("content") %>' />
</td>
<td>
<asp:TextBox ID="categoriesTextBox" runat="server" Text='<%# Bind("categories") %>' />
</td>
<td>
<asp:TextBox ID="type1TextBox" runat="server" Text='<%# Bind("type1") %>' />
</td>
<td>
<asp:TextBox ID="issueDateTextBox" runat="server" Text='<%# Bind("issueDate") %>' />
</td>
</tr>
</InsertItemTemplate>
<ItemTemplate>
<tr style="background-color:#DCDCDC;color: #000000;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="删除" />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="编辑" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="titleLabel" runat="server" Text='<%# Eval("title") %>' />
</td>
<td>
<asp:Label ID="contentLabel" runat="server" Text='<%# Eval("content") %>' />
</td>
<td>
<asp:Label ID="categoriesLabel" runat="server" Text='<%# Eval("categories") %>' />
</td>
<td>
<asp:Label ID="type1Label" runat="server" Text='<%# Eval("type1") %>' />
</td>
<td>
<asp:Label ID="issueDateLabel" runat="server" Text='<%# Eval("issueDate") %>' />
</td>
</tr>
</ItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table id="itemPlaceholderContainer" runat="server" border="1" style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color:#DCDCDC;color: #000000;">
<th runat="server"></th>
<th runat="server">id</th>
<th runat="server">title</th>
<th runat="server">content</th>
<th runat="server">categories</th>
<th runat="server">type1</th>
<th runat="server">issueDate</th>
</tr>
<tr id="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server" style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
<asp:DataPager ID="DataPager1" runat="server" PageSize="3">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
</Fields>
</asp:DataPager>
</td>
</tr>
</table>
</LayoutTemplate>
<SelectedItemTemplate>
<tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
<td>
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="删除" />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="编辑" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="titleLabel" runat="server" Text='<%# Eval("title") %>' />
</td>
<td>
<asp:Label ID="contentLabel" runat="server" Text='<%# Eval("content") %>' />
</td>
<td>
<asp:Label ID="categoriesLabel" runat="server" Text='<%# Eval("categories") %>' />
</td>
<td>
<asp:Label ID="type1Label" runat="server" Text='<%# Eval("type1") %>' />
</td>
<td>
<asp:Label ID="issueDateLabel" runat="server" Text='<%# Eval("issueDate") %>' />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:db_newsConnectionString %>" DeleteCommand="DELETE FROM [tb_news] WHERE [id] = @id" InsertCommand="INSERT INTO [tb_news] ([title], [content], [categories], [type1], [issueDate]) VALUES (@title, @content, @categories, @type1, @issueDate)" SelectCommand="SELECT * FROM [tb_news]" UpdateCommand="UPDATE [tb_news] SET [title] = @title, [content] = @content, [categories] = @categories, [type1] = @type1, [issueDate] = @issueDate WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="title" Type="String" />
<asp:Parameter Name="content" Type="String" />
<asp:Parameter Name="categories" Type="String" />
<asp:Parameter Name="type1" Type="String" />
<asp:Parameter Name="issueDate" Type="DateTime" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="title" Type="String" />
<asp:Parameter Name="content" Type="String" />
<asp:Parameter Name="categories" Type="String" />
<asp:Parameter Name="type1" Type="String" />
<asp:Parameter Name="issueDate" Type="DateTime" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
webform1.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace test9_5
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
}
sql
CREATE DATABASE db_news
USE db_news
GO
CREATE TABLE dbo.tb_news(
id int identity(1,1) not null primary key,
title varchar(50) not null,
content varchar(2000) not null,
categories varchar(50) not null,
type1 varchar(50) not null,
issueDate datetime not null default getdate())
GO
insert into tb_news(title,content,categories,type1)
values('创业板开板','新浪财经讯10月17日上午消息 中国证监会主席在企业投融资论坛上透露,经国务院批准成立创业板。','环球经济','国内新闻');
web.config
<?xml version="1.0" encoding="utf-8"?>
<!--
有关如何配置 ASP.NET 应用程序的详细信息,请访问
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="db_newsConnectionString" connectionString="Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=db_news;Persist Security Info=True;User ID=sa;Password=123456"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.5" />
<httpRuntime targetFramework="4.5" />
</system.web>
</configuration>