list.ascx.cs

vs2005 C# sqlserver2000 制作完成

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using EShop.BusinessLogicLayer;


public partial class control_List_List : System.Web.UI.UserControl
{
    private int RowNum = 2;
    protected void Page_Load(object sender, EventArgs e)
    {
        //if (!IsPostBack)
        //{
            List list = new List();
            SqlDataReader sdrList = list.getParentReader();

            while (sdrList.Read())
            {
                int i = 0;
                TableRow trhead = new TableRow();
                TableCell tchead = new TableCell();
                HyperLink hylhead = new HyperLink();
                hylhead.Text = sdrList["ParentName"].ToString();
                hylhead.NavigateUrl = "~/Show.aspx?Name=" +Server.UrlEncode( hylhead.Text.ToString().Trim());
                list.ParentID = int.Parse(sdrList["ParentID"].ToString());
                tchead.ColumnSpan = 2;

                tchead.CssClass = "tcheadList";
                tchead.Controls.Add(hylhead);
                trhead.Controls.Add(tchead);
                this.TableList.Rows.Add(trhead);



                SqlDataReader sdr1 = list.getChildReader(list.ParentID);
                TableRow tr = new TableRow();
                while (sdr1.Read())
                {
                    i++;

                    TableCell tc = new TableCell();
                    HyperLink hyltr = new HyperLink();
                    hyltr.Text = sdr1["ChildName"].ToString();
                    hyltr.NavigateUrl = "~/Show.aspx?Name=" + Server.UrlEncode(hyltr.Text.ToString().Trim());
                    tc.CssClass = "tdList";
                    tc.Controls.Add(hyltr);
                    tr.Controls.Add(tc);
                    if (i % RowNum == 0)
                    {
                        this.TableList.Rows.Add(tr);
                        tr = new TableRow();
                    }

                }
                if (i % RowNum != 0)
                {
                    this.TableList.Rows.Add(tr);
                }

                this.TableList.CssClass = "TableList";
            }
        //}
    }
}