前台代码:
<%@ 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>
后台代码:
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)
        
{
        
        }

    }

}