DataList中嵌入DataGrid

前台代码：

<% @ 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 窗体设计器生成的代码#region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /**//// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {    
            this.DataList1.ItemCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_ItemCommand);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        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)
        {
        
        }
    }
}

转载于:https://www.cnblogs.com/hwj/archive/2004/12/22/80639.html