多表DATASET的显示方法,自己乱搞的.

效果:

表现层:
Classlist.ascx

<% @ Control Language = " C# "  ClassName = " classlist "   Debug = " true "   %>

< script runat = " server " >
   
     protected   void  Page_Load( object  sender, EventArgs e)
     {
        dataclass datacls = (dataclass)Application["data"];

        System.Data.DataSet ds = new System.Data.DataSet();
        ds=datacls.getclasslist();
       
        
      if (ds.Tables[0].Rows.Count > 0)
        {
            for (int i = 0; i <ds.Tables.Count; i++)
            {
                PlaceHolder tt = new PlaceHolder();
                Label title = new Label();
               title.Text = ds.Tables[i].TableName;
                title.Font.Bold = true;
               tt.Controls.Add(title); 
                   
                DataList dl=new DataList();
                dl.ItemTemplate = Page.LoadTemplate("/conterl/classitem.ascx");
                dl.RepeatDirection=(RepeatDirection)0;
                dl.RepeatColumns = 4;
                dl.DataSource = ds.Tables[i];
                dl.DataBind();
                tt.Controls.Add(dl);
                PlaceHolder1.Controls.Add(tt);
            }
          
        }
       
       
    }
</ script >
< div id = " le_biaoti02 "   class = " left_biaoti " >
       < img src = " ../image/bioti_02.gif "  width = " 60 "  height = " 26 "   />     
       </ div >
        < div id = " left_fenlei02 "   class = " left_fenlei "  runat = " server "   >
             < asp:PlaceHolder ID = " PlaceHolder1 "  runat = " server " >
           
             </ asp:PlaceHolder >
        </ div >

/conterl/classitem.ascx

<% @ Control Language = " VB "    %>
  <% # DataBinder.Eval(CType(Container, DataListItem).DataItem,  " error " )  %>
  & nbsp; < a href = " class.aspx?id=<%# DataBinder.Eval(CType(Container, DataListItem).DataItem,  " ID " ) %> " >   <% #DataBinder.Eval(CType(Container, DataListItem).DataItem,  " classname " ) %></ a >< br  />

逻辑层:

/**/ ///<summary>
    /// 取得分类列表
    /// </summary>
    public  DataSet getclasslist() 
    {
        try
        {
            string sqlstr = "";
            sqlstr = "select id,classname from classname where upid=0";
           DataSet dc=new DataSet();
            dc=getds(sqlstr);
            
            if (dc.Tables[0].Rows.Count > 0)
            {
                DataSet dl=new DataSet();

                for(int j=0;j<dc.Tables[0].Rows.Count;j++)
                {
                sqlstr = "select top 3 id,classname from classname where upid=" + (int)dc.Tables[0].Rows[j]["id"];
                
                    dl= getdsname(sqlstr, (string)dc.Tables[0].Rows[j]["classname"],dl);
                
                    dl.Tables[(string)dc.Tables[0].Rows[j]["classname"]].Columns.Add("error");
                    DataRow drow;
                    drow = dl.Tables[(string)dc.Tables[0].Rows[j]["classname"]].NewRow();
                    drow["id"] = (int)dc.Tables[0].Rows[j]["id"];
                    drow["classname"] = "";
                    dl.Tables[(string)dc.Tables[0].Rows[j]["classname"]].Rows.Add(drow);
                    
                }
       
                return dl;
            }
            else
            {                
                throw new Exception("no");
            }
        }
        catch ( Exception ex)
        {
            DataSet temp = new DataSet();
            DataTable dtServer = new DataTable();
            DataColumn dterror = new DataColumn("error");
            dterror.DataType = typeof(string);
            dtServer.Columns.Add(dterror);
            dtServer.Columns.Add("id", typeof(int));
            dtServer.Columns.Add("classname");
            DataRow drowServer;
            drowServer = dtServer.NewRow();
            drowServer["error"] = ex.Message;
            dtServer.Rows.Add(drowServer);
            temp.Tables.Add(dtServer);
            return temp;
        }
   }

数据层:

/**/ ///<summary>
    ///返回Dataset类型的方法
    ///</summary>
     public  DataSet getds( string  sql)
     {
        SqlCommand comm = new SqlCommand(sql, sqlconn);
        SqlDataAdapter da = new SqlDataAdapter(comm);
        DataSet temp = new DataSet();
        int i=da.Fill(temp);
        return temp;
     }
      /**/ ///<summary>
     ///返回Dataset类型的方法,带表名,添加新表
     ///</summary>
      public  DataSet getdsname( string  sql, string  name,DataSet ds)
      {
         SqlCommand comm = new SqlCommand(sql, sqlconn);
         SqlDataAdapter da = new SqlDataAdapter(comm);
         //DataSet temp = new DataSet();
         int i = da.Fill(ds,name);
         return ds;
     }

以前没有做过这方面的东东,C#也是刚刚才开始用.今天用了一上午,终于做出来了,但这并不是真正的显示DATASET多个表的方法.
有没有人能告诉我方便快捷的方法呢?

转载于:https://www.cnblogs.com/aowind/archive/2006/10/18/532355.html