以下是我这个初学者做的二级分类
using System.Data.OleDb;--------------------------
abcd OK = new abcd();
--------------------------
private string biaodx;--------------------------
public string Service()
{//服务项目一级分类
DataSet ds = OK.GetDataSet("SELECT top 7 * FROM [Service_lm] ORDER BY [quanzhong] DESC", "biaoa");
DataRow[] row = ds.Tables["biaoa"].Select();
string iddx;
int ttfw = 0;//弄个计数器,防止权重都是相同情况下top不起作用,ACCESS就是这样奇怪
foreach (DataRow rss in row)
{
{
iddx = rss["id"].ToString();//编号
biaodx = rss["lanmu"].ToString();//栏目
if (ttfw < 7)//0开始计数
{
//读取一级分类
Response.Write("<div style='width: 190px; height: 25px;'><img src='imalh/jt02.jpg' width='13' height='14' border='0' /><a href='web/Case.aspx?id=" + iddx + "' target='_top'>" + biaodx + "</a></div>");
Service2();//读取二级分类 }
ttfw++;
}
}
return null;
}
private void Service2()
{//服务项目二级分类
DataSet ds = OK.GetDataSet("SELECT * FROM [Service_lm2] where lanmu='" + biaodx + "' ORDER BY [quanzhong_hy] DESC", "biao2");
DataRow[] row = ds.Tables["biao2"].Select();
string iddx2, biaodx2; foreach (DataRow rss in row)
{
{
iddx2 = rss["id"].ToString();//编号
biaodx2 = rss["lanmu2"].ToString();//栏目 Response.Write("<div style='width: 190px; height: 25px;'><a href='web/CaseRead.aspx?id=" + iddx2 + "' target='_top'>" + biaodx2 + "</a></div>"); }
}
}
这个二级分类好菜。好菜。想请教大家怎么用存储过程写二级三级无限极分类??
声明我不懂存储过程,请高手指点思路。(因为不懂存储过程,所以才恳切指点思路)
using System.Data.OleDb;--------------------------
abcd OK = new abcd();
--------------------------
private string biaodx;--------------------------
public string Service()
{//服务项目一级分类
DataSet ds = OK.GetDataSet("SELECT top 7 * FROM [Service_lm] ORDER BY [quanzhong] DESC", "biaoa");
DataRow[] row = ds.Tables["biaoa"].Select();
string iddx;
int ttfw = 0;//弄个计数器,防止权重都是相同情况下top不起作用,ACCESS就是这样奇怪
foreach (DataRow rss in row)
{
{
iddx = rss["id"].ToString();//编号
biaodx = rss["lanmu"].ToString();//栏目
if (ttfw < 7)//0开始计数
{
//读取一级分类
Response.Write("<div style='width: 190px; height: 25px;'><img src='imalh/jt02.jpg' width='13' height='14' border='0' /><a href='web/Case.aspx?id=" + iddx + "' target='_top'>" + biaodx + "</a></div>");
Service2();//读取二级分类 }
ttfw++;
}
}
return null;
}
private void Service2()
{//服务项目二级分类
DataSet ds = OK.GetDataSet("SELECT * FROM [Service_lm2] where lanmu='" + biaodx + "' ORDER BY [quanzhong_hy] DESC", "biao2");
DataRow[] row = ds.Tables["biao2"].Select();
string iddx2, biaodx2; foreach (DataRow rss in row)
{
{
iddx2 = rss["id"].ToString();//编号
biaodx2 = rss["lanmu2"].ToString();//栏目 Response.Write("<div style='width: 190px; height: 25px;'><a href='web/CaseRead.aspx?id=" + iddx2 + "' target='_top'>" + biaodx2 + "</a></div>"); }
}
}
这个二级分类好菜。好菜。想请教大家怎么用存储过程写二级三级无限极分类??
声明我不懂存储过程,请高手指点思路。(因为不懂存储过程,所以才恳切指点思路)
(
@变量1 类型 输入/输出, ---->用来 与 外部变量操作 ,传出或传进外部变量
@..
)
as
declare @程序变量1 类型 ---->用来 与 内部变量操作
set @程序变量1=值 ----->TSQL 语句