ASP.NET生成樹(shù)形顯示的GridView實(shí)現(xiàn)思路
更新時(shí)間：2013年02月06日 17:58:23 作者：
生成樹(shù)形結(jié)構(gòu)的表格數(shù)據(jù)（EasyUI也有TreeGrid，此處只是提供一個(gè)思路），可以擴(kuò)展單擊展開(kāi)/收縮節(jié)點(diǎn),喜歡的朋友可以了解下啊，或許本文對(duì)你學(xué)習(xí)GridView有所幫助
目的：生成樹(shù)形結(jié)構(gòu)的表格數(shù)據(jù)（EasyUI也有TreeGrid，此處只是提供一個(gè)思路），可以擴(kuò)展單擊展開(kāi)/收縮節(jié)點(diǎn)
圖例：
類(lèi)代碼：
using System;
using System.Data;
/// <summary>
///GridViewHelper 的摘要說(shuō)明
/// </summary>
public class GridViewHelper
{
private string gridline; //連接線
private DataTable dt; //傳入的DataTable
private DataTable dtOut; //輸出的DataTable
private DataRow row; //用于從DataView取數(shù)據(jù)并增加到dtOut
public GridViewHelper()
{
//
//TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
/// <summary>
/// 生成樹(shù)形結(jié)構(gòu)的DataTable
/// </summary>
/// <param name="datatable">原始數(shù)據(jù)表</param>
/// <param name="parentField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param>
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="textField">顯示的文本字段</param>
/// <param name="sortString">排序字符串</param>
/// <returns>處理后的DataTable</returns>
public DataTable GetGridViewTreeData(DataTable datatable, string parentField, string parentValue, string keyField, string textField, string sortString)
{
datatable.Columns.Add("level", Type.GetType("System.Int32"));
dt = datatable;
dtOut = datatable.Clone();
resetTextField(parentField, parentValue, keyField, textField, sortString, 0);
return dtOut;
}
/// <summary>
/// 遞歸生成新的節(jié)點(diǎn)名稱(chēng)(帶連接線)
/// </summary>
/// <param name="parentValueField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param>
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="textField">顯示出來(lái)的文本字段</param>
/// <param name="sortString">排序字符串</param>
/// <param name="level">樹(shù)深度</param>
/// <returns></returns>
private void resetTextField(string parentValueField, string parentValue, string keyField, string textField, string sortString,int level)
{
DataView dv = new DataView(dt, parentValueField + "='" + parentValue + "'", sortString, DataViewRowState.CurrentRows);
int a = dv.Count;
if (dv.Count == 0)
{
return;
}
for (int i = 0; i < a; i++)
{
gridline = "";
dv.RowFilter = parentValueField + "='" + parentValue + "'";
dv.Sort = sortString;
getTreeLine(parentValueField, dv[i][parentValueField].ToString(), keyField, dv[i][keyField].ToString(), sortString);
dv.RowFilter = parentValueField + "='" + parentValue + "'";
dv.Sort = sortString;
row = dtOut.NewRow();
for (int c = 0; c < dv[i].Row.ItemArray.Length; c++)
{
row[c] = dv[i][c];
}
dtOut.Rows.Add(row);
dtOut.Rows[dtOut.Rows.Count - 1][textField] = gridline + (i == a - 1 ? "┗" : "┣") + dv[i][textField].ToString();
dtOut.Rows[dtOut.Rows.Count - 1]["level"] = level;
resetTextField(parentValueField, dv[i][keyField].ToString(), keyField, textField, sortString,level+1);
}
dv.Dispose();
}
/// <summary>
/// 回溯生成樹(shù)的連接線
/// </summary>
/// <param name="parentValueField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param>
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="nodeKey">本節(jié)點(diǎn)值</param>
/// <param name="sortString">排序字符串</param>
/// <returns></returns>
private void getTreeLine(string parentValueField, string parentValue, string keyField, string nodeKey, string sortString)
{
//選擇父層節(jié)點(diǎn)
DataView dv = new DataView(dt, keyField + "='" + parentValue + "'", sortString, DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
//選擇父節(jié)點(diǎn)同級(jí)節(jié)點(diǎn)
dv.RowFilter = parentValueField + "='" + dv[0][parentValueField].ToString() + "'";
dv.Sort = sortString;
for (int j = 0; j < dv.Count; j++)
{
if (dv[j][keyField].ToString() == parentValue)
{
if (j == dv.Count - 1)
{
gridline = " " + gridline;
}
else
{
gridline = "┃" + gridline;
}
}
}
getTreeLine(parentValueField, dv[0][parentValueField].ToString(), keyField, dv[0][keyField].ToString(), sortString);
}
dv.Dispose();
}
}
HTML示例代碼：
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewTree.aspx.cs" Inherits="GridViewTree" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>生成樹(shù)形顯示的GridView</title>
<style type="text/css">
body
{
line-height: 16px;
font-size: 14px;
}
td
{
padding: 0 2px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td valign="top">
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
</td>
<td>
<asp:GridView ID="GridView1" runat="server" BorderWidth="1px" CellPadding="3" GridLines="Vertical"
AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None">
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:BoundField DataField="ConText" HeaderText="文本" />
<asp:BoundField DataField="id" HeaderText="ID">
<ItemStyle HorizontalAlign="Right" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="ParentID" HeaderText="父ID">
<ItemStyle HorizontalAlign="Right" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="level" HeaderText="Level">
<ItemStyle HorizontalAlign="Right" Width="80px" />
</asp:BoundField>
</Columns>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<SortedAscendingCellStyle BackColor="#F4F4FD" />
<SortedAscendingHeaderStyle BackColor="#5A4C9D" />
<SortedDescendingCellStyle BackColor="#D8D8F0" />
<SortedDescendingHeaderStyle BackColor="#3E3277" />
</asp:GridView>
</td>
</tr>
</table>
</form>
</body>
</html>
后臺(tái)代碼：
DataTable dt = gvHelper.GetGridViewTreeData(datatable, "ParentID", "1", "ID", "ConText", "ConText asc");
GridView1.DataSource = dt;
GridView1.DataBind();
DropDownList1.Items.Add("");
DropDownList1.AppendDataBoundItems = true;
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "ConText";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
圖例：
類(lèi)代碼：
復(fù)制代碼 代碼如下:
using System;
using System.Data;
/// <summary>
///GridViewHelper 的摘要說(shuō)明
/// </summary>
public class GridViewHelper
{
private string gridline; //連接線
private DataTable dt; //傳入的DataTable
private DataTable dtOut; //輸出的DataTable
private DataRow row; //用于從DataView取數(shù)據(jù)并增加到dtOut
public GridViewHelper()
{
//
//TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
/// <summary>
/// 生成樹(shù)形結(jié)構(gòu)的DataTable
/// </summary>
/// <param name="datatable">原始數(shù)據(jù)表</param>
/// <param name="parentField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param>
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="textField">顯示的文本字段</param>
/// <param name="sortString">排序字符串</param>
/// <returns>處理后的DataTable</returns>
public DataTable GetGridViewTreeData(DataTable datatable, string parentField, string parentValue, string keyField, string textField, string sortString)
{
datatable.Columns.Add("level", Type.GetType("System.Int32"));
dt = datatable;
dtOut = datatable.Clone();
resetTextField(parentField, parentValue, keyField, textField, sortString, 0);
return dtOut;
}
/// <summary>
/// 遞歸生成新的節(jié)點(diǎn)名稱(chēng)(帶連接線)
/// </summary>
/// <param name="parentValueField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param>
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="textField">顯示出來(lái)的文本字段</param>
/// <param name="sortString">排序字符串</param>
/// <param name="level">樹(shù)深度</param>
/// <returns></returns>
private void resetTextField(string parentValueField, string parentValue, string keyField, string textField, string sortString,int level)
{
DataView dv = new DataView(dt, parentValueField + "='" + parentValue + "'", sortString, DataViewRowState.CurrentRows);
int a = dv.Count;
if (dv.Count == 0)
{
return;
}
for (int i = 0; i < a; i++)
{
gridline = "";
dv.RowFilter = parentValueField + "='" + parentValue + "'";
dv.Sort = sortString;
getTreeLine(parentValueField, dv[i][parentValueField].ToString(), keyField, dv[i][keyField].ToString(), sortString);
dv.RowFilter = parentValueField + "='" + parentValue + "'";
dv.Sort = sortString;
row = dtOut.NewRow();
for (int c = 0; c < dv[i].Row.ItemArray.Length; c++)
{
row[c] = dv[i][c];
}
dtOut.Rows.Add(row);
dtOut.Rows[dtOut.Rows.Count - 1][textField] = gridline + (i == a - 1 ? "┗" : "┣") + dv[i][textField].ToString();
dtOut.Rows[dtOut.Rows.Count - 1]["level"] = level;
resetTextField(parentValueField, dv[i][keyField].ToString(), keyField, textField, sortString,level+1);
}
dv.Dispose();
}
/// <summary>
/// 回溯生成樹(shù)的連接線
/// </summary>
/// <param name="parentValueField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param>
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param>
/// <param name="nodeKey">本節(jié)點(diǎn)值</param>
/// <param name="sortString">排序字符串</param>
/// <returns></returns>
private void getTreeLine(string parentValueField, string parentValue, string keyField, string nodeKey, string sortString)
{
//選擇父層節(jié)點(diǎn)
DataView dv = new DataView(dt, keyField + "='" + parentValue + "'", sortString, DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
//選擇父節(jié)點(diǎn)同級(jí)節(jié)點(diǎn)
dv.RowFilter = parentValueField + "='" + dv[0][parentValueField].ToString() + "'";
dv.Sort = sortString;
for (int j = 0; j < dv.Count; j++)
{
if (dv[j][keyField].ToString() == parentValue)
{
if (j == dv.Count - 1)
{
gridline = " " + gridline;
}
else
{
gridline = "┃" + gridline;
}
}
}
getTreeLine(parentValueField, dv[0][parentValueField].ToString(), keyField, dv[0][keyField].ToString(), sortString);
}
dv.Dispose();
}
}
HTML示例代碼：
復(fù)制代碼 代碼如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewTree.aspx.cs" Inherits="GridViewTree" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>生成樹(shù)形顯示的GridView</title>
<style type="text/css">
body
{
line-height: 16px;
font-size: 14px;
}
td
{
padding: 0 2px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td valign="top">
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
</td>
<td>
<asp:GridView ID="GridView1" runat="server" BorderWidth="1px" CellPadding="3" GridLines="Vertical"
AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None">
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:BoundField DataField="ConText" HeaderText="文本" />
<asp:BoundField DataField="id" HeaderText="ID">
<ItemStyle HorizontalAlign="Right" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="ParentID" HeaderText="父ID">
<ItemStyle HorizontalAlign="Right" Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="level" HeaderText="Level">
<ItemStyle HorizontalAlign="Right" Width="80px" />
</asp:BoundField>
</Columns>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<SortedAscendingCellStyle BackColor="#F4F4FD" />
<SortedAscendingHeaderStyle BackColor="#5A4C9D" />
<SortedDescendingCellStyle BackColor="#D8D8F0" />
<SortedDescendingHeaderStyle BackColor="#3E3277" />
</asp:GridView>
</td>
</tr>
</table>
</form>
</body>
</html>
后臺(tái)代碼：
復(fù)制代碼 代碼如下:
DataTable dt = gvHelper.GetGridViewTreeData(datatable, "ParentID", "1", "ID", "ConText", "ConText asc");
GridView1.DataSource = dt;
GridView1.DataBind();
DropDownList1.Items.Add("");
DropDownList1.AppendDataBoundItems = true;
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "ConText";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
您可能感興趣的文章:
- Jquery.TreeView結(jié)合ASP.Net和數(shù)據(jù)庫(kù)生成菜單導(dǎo)航條
- 常用的在數(shù)據(jù)庫(kù)中建立無(wú)限級(jí)樹(shù)形菜單的asp.net代碼
- asp.net 獲取指定文件夾下所有子目錄及文件(樹(shù)形)
- asp.net實(shí)現(xiàn)遞歸方法取出菜單并顯示在DropDownList中(分欄形式)
- ASP.NET遞歸法求階乘解決思路
- 遞歸輸出ASP.NET頁(yè)面所有控件的類(lèi)型和ID的代碼
- asp.net實(shí)現(xiàn)DropDownList,TreeView,ListBox的無(wú)限極分類(lèi)目錄樹(shù)
- asp.net TreeView與XML三步生成列表樹(shù)
- Asp.net treeview實(shí)現(xiàn)無(wú)限級(jí)樹(shù)實(shí)現(xiàn)代碼
- asp.net TreeView遞歸循環(huán)子節(jié)點(diǎn)生成樹(shù)形菜單實(shí)例
相關(guān)文章
asp.net字符串處理類(lèi)代碼，需要的朋友可以參考下2012-06-06
.NET Core單文件發(fā)布靜態(tài)編譯AOT CoreRT的方法詳解
這篇文章主要給大家介紹了關(guān)于.NET Core單文件發(fā)布靜態(tài)編譯AOT CoreRT的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2018-07-07
ASP.NET 統(tǒng)計(jì)圖表控件小結(jié)
近來(lái)客戶需要將前段時(shí)間開(kāi)發(fā)的統(tǒng)計(jì)信息用圖表展示出來(lái)，還要多個(gè)圖表類(lèi)型，例如：柱狀圖、餅圖、曲線圖、三維圖等等。在網(wǎng)上google了一下，發(fā)現(xiàn)了三個(gè)（也許更多）可以使用的控件。下面我們一起看看這三個(gè)控件。2009-11-11
擴(kuò)展了Repeater控件的EmptyDataTemplate模板功能
Repeater控件是一個(gè)數(shù)據(jù)顯示控件，該控件允許通過(guò)為列表中顯示的每一項(xiàng)重復(fù)使用指定的模板來(lái)自定義布局2013-01-01
這篇文章主要介紹了asp.net獲取網(wǎng)站目錄物理路徑的方法,需要的朋友可以參考下2014-02-02
ASPX中的用戶控件與ASP中的INCLUDE方法對(duì)比
ASPX中的用戶控件與ASP中的INCLUDE方法對(duì)比...2006-09-09
這篇文章介紹了在Asp.net?core程序中使用微軟的依賴注入框架，文中通過(guò)示例代碼介紹的非常詳細(xì)。對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值，需要的朋友可以參考下2022-07-07
.net簡(jiǎn)單使用Log4net的方法（多個(gè)日志配置文件）
log4net是.net中常用的一個(gè)日志記錄工具，下面這篇文章主要給大家介紹了關(guān)于.net簡(jiǎn)單使用Log4net的方法（多個(gè)日志配置文件），文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面來(lái)一起看看吧2018-11-11
上傳圖片后使用數(shù)據(jù)庫(kù)保存圖片的示例分享
這篇文章主要介紹了上傳圖片后使用數(shù)據(jù)庫(kù)保存圖片的示例,需要的朋友可以參考下2014-03-03
asp.net下Response.ContentType類(lèi)型匯總
asp.net下Response.ContentType類(lèi)型匯總...2007-04-04