前台代码:
后台代码:
<%@ Page language="c#" Codebehind="WebForm2.aspx.cs" AutoEventWireup="false" Inherits="program4.WebForm2" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm2</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:DataList id="DataList1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server">
<ItemTemplate>
<TABLE cellSpacing="1" cellPadding="1" width="300" border="1">
<TR>
<TD>
<asp:Label id=lbl Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"分类名称")%>'>
</asp:Label></TD>
</TR>
<TR>
<TD>
<asp:DataGrid id=DataGrid1 runat="server" AutoGenerateColumns="False" Width="100%" DataSource='<%# CreateTable((DataBinder.Eval(Container.DataItem,"图书分类_id")).ToString()) %>' OnItemCommand="dg_ItemCommand">
<Columns>
<asp:BoundColumn Visible="False" DataField="图书信息_id" HeaderText="图书信息_id"></asp:BoundColumn>
<asp:BoundColumn DataField="图书名称" HeaderText="图书名称"></asp:BoundColumn>
<asp:BoundColumn DataField="作者" HeaderText="作者"></asp:BoundColumn>
<asp:ButtonColumn Text="删除" CommandName="Delete"></asp:ButtonColumn>
</Columns>
</asp:DataGrid></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:DataList></FONT>
</form>
</body>
</HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm2</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:DataList id="DataList1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server">
<ItemTemplate>
<TABLE cellSpacing="1" cellPadding="1" width="300" border="1">
<TR>
<TD>
<asp:Label id=lbl Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"分类名称")%>'>
</asp:Label></TD>
</TR>
<TR>
<TD>
<asp:DataGrid id=DataGrid1 runat="server" AutoGenerateColumns="False" Width="100%" DataSource='<%# CreateTable((DataBinder.Eval(Container.DataItem,"图书分类_id")).ToString()) %>' OnItemCommand="dg_ItemCommand">
<Columns>
<asp:BoundColumn Visible="False" DataField="图书信息_id" HeaderText="图书信息_id"></asp:BoundColumn>
<asp:BoundColumn DataField="图书名称" HeaderText="图书名称"></asp:BoundColumn>
<asp:BoundColumn DataField="作者" HeaderText="作者"></asp:BoundColumn>
<asp:ButtonColumn Text="删除" CommandName="Delete"></asp:ButtonColumn>
</Columns>
</asp:DataGrid></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:DataList></FONT>
</form>
</body>
</HTML>
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace program4
{
/// <summary>
/// WebForm2 的摘要说明。
/// </summary>
public class WebForm2 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList DataList1;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
Data_Bind();
}
}
public void Data_Bind()
{
SqlConnection Cnn=new SqlConnection("server=.;database=bookhome;uid=sa");
Cnn.Open();
SqlDataAdapter myAdapter=new SqlDataAdapter("select * from 图书分类",Cnn);
DataSet ds=new DataSet();
myAdapter.Fill(ds);
DataList1.DataSource=ds.Tables[0].DefaultView;
DataList1.DataBind();
}
public DataView CreateTable(string id)
{
SqlConnection Cnn=new SqlConnection("server=.;database=bookhome;uid=sa");
Cnn.Open();
SqlDataAdapter myAdapter=new SqlDataAdapter("select * from 图书信息 where 图书分类_id="+id,Cnn);
DataSet ds=new DataSet();
myAdapter.Fill(ds);
return ds.Tables[0].DefaultView;
}
Web 窗体设计器生成的代码
private void DataList1_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
}
public void dg_ItemCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName=="Delete")
{
SqlConnection Cnn=new SqlConnection("Server=.;database=bookhome;uid=sa");
Cnn.Open();
SqlCommand Cmm=new SqlCommand("delete from 图书信息 where 图书信息_id="+e.Item.Cells[0].Text,Cnn);
Cmm.ExecuteNonQuery();
Data_Bind();
}
}
private void DataGrid2_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
}
}
}
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace program4
{
/// <summary>
/// WebForm2 的摘要说明。
/// </summary>
public class WebForm2 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList DataList1;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
Data_Bind();
}
}
public void Data_Bind()
{
SqlConnection Cnn=new SqlConnection("server=.;database=bookhome;uid=sa");
Cnn.Open();
SqlDataAdapter myAdapter=new SqlDataAdapter("select * from 图书分类",Cnn);
DataSet ds=new DataSet();
myAdapter.Fill(ds);
DataList1.DataSource=ds.Tables[0].DefaultView;
DataList1.DataBind();
}
public DataView CreateTable(string id)
{
SqlConnection Cnn=new SqlConnection("server=.;database=bookhome;uid=sa");
Cnn.Open();
SqlDataAdapter myAdapter=new SqlDataAdapter("select * from 图书信息 where 图书分类_id="+id,Cnn);
DataSet ds=new DataSet();
myAdapter.Fill(ds);
return ds.Tables[0].DefaultView;
}
Web 窗体设计器生成的代码
private void DataList1_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
}
public void dg_ItemCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName=="Delete")
{
SqlConnection Cnn=new SqlConnection("Server=.;database=bookhome;uid=sa");
Cnn.Open();
SqlCommand Cmm=new SqlCommand("delete from 图书信息 where 图书信息_id="+e.Item.Cells[0].Text,Cnn);
Cmm.ExecuteNonQuery();
Data_Bind();
}
}
private void DataGrid2_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
}
}
}