效果:
表现层:
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多个表的方法.
有没有人能告诉我方便快捷的方法呢?
表现层:
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
>
<%
@ 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; }
有没有人能告诉我方便快捷的方法呢?
