Winform中TreeView的绑定
来源:互联网 发布:mac能打dota2吗 编辑:程序博客网 时间:2024/05/21 06:47
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindDrpClass();
}
}
/// <summary>
/// 绑定顶级分类
/// </summary>
private void BindDrpClass()
{
DataTable dt = GetClassList("").Tables[0];
ddlClass.Items.Clear();
ddlClass.Items.Add(new ListItem("添加根栏目", "0"));
DataRow[] drs = dt.Select("ParentID= " + 0);
foreach (DataRow dr in drs)
{
string classid = dr["ClassID"].ToString();
string classname = dr["ClassName"].ToString();
//顶级分类显示形式
classname = "╋" + classname;
ddlClass.Items.Add(new ListItem(classname, classid));
int sonparentid = int.Parse(classid);
string blank = "├";
//递归子分类方法
BindDrpNode(sonparentid, dt, blank);
}
ddlClass.DataBind();
}
/// <summary>
/// 绑定子分类
/// </summary>
/// <param name="parentid"></param>
/// <param name="dt"></param>
/// <param name="blank"></param>
private void BindDrpNode(int parentid, DataTable dt, string blank)
{
DataRow[] drs = dt.Select("ParentID= " + parentid);
foreach (DataRow dr in drs)
{
string classid = dr["ClassID"].ToString();
string classname = dr["ClassName"].ToString();
classname = blank + classname;
ddlClass.Items.Add(new ListItem(classname, classid));
int sonparentid = int.Parse(classid);
string blank2 = blank + "─";
BindDrpNode(sonparentid, dt, blank2);
}
}
/// <summary>
/// 数据访问
/// </summary>
/// <param name="strWhere">SQL条件</param>
/// <returns></returns>
public DataSet GetClassList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tb_Class ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return DAL.SqlHelper.ExecuteDataset(DAL.SqlHelper.ConnString, CommandType.Text, strSql.ToString());
}
{
if (!Page.IsPostBack)
{
BindDrpClass();
}
}
/// <summary>
/// 绑定顶级分类
/// </summary>
private void BindDrpClass()
{
DataTable dt = GetClassList("").Tables[0];
ddlClass.Items.Clear();
ddlClass.Items.Add(new ListItem("添加根栏目", "0"));
DataRow[] drs = dt.Select("ParentID= " + 0);
foreach (DataRow dr in drs)
{
string classid = dr["ClassID"].ToString();
string classname = dr["ClassName"].ToString();
//顶级分类显示形式
classname = "╋" + classname;
ddlClass.Items.Add(new ListItem(classname, classid));
int sonparentid = int.Parse(classid);
string blank = "├";
//递归子分类方法
BindDrpNode(sonparentid, dt, blank);
}
ddlClass.DataBind();
}
/// <summary>
/// 绑定子分类
/// </summary>
/// <param name="parentid"></param>
/// <param name="dt"></param>
/// <param name="blank"></param>
private void BindDrpNode(int parentid, DataTable dt, string blank)
{
DataRow[] drs = dt.Select("ParentID= " + parentid);
foreach (DataRow dr in drs)
{
string classid = dr["ClassID"].ToString();
string classname = dr["ClassName"].ToString();
classname = blank + classname;
ddlClass.Items.Add(new ListItem(classname, classid));
int sonparentid = int.Parse(classid);
string blank2 = blank + "─";
BindDrpNode(sonparentid, dt, blank2);
}
}
/// <summary>
/// 数据访问
/// </summary>
/// <param name="strWhere">SQL条件</param>
/// <returns></returns>
public DataSet GetClassList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tb_Class ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return DAL.SqlHelper.ExecuteDataset(DAL.SqlHelper.ConnString, CommandType.Text, strSql.ToString());
}
- Winform中TreeView的绑定
- winform中treeview绑定数据库的数
- TreeView的数据绑定(winForm)
- WinForm中动态绑定TreeView数据
- 一、WinForm中TreeView数据绑定
- c# winform treeview的绑定和遍历
- WinForm递归绑定TreeView
- WinForm递归绑定TreeView
- winform treeView 数据绑定
- C#之Winform中treeview控件绑定数据库
- VB.Net,WinForm中层次数据绑定TreeView的实现
- WinForm TreeView的应用 递归绑定区域树
- WinForm之TreeView的应用—绑定区域树
- winform中treeview的一些使用心得
- winForm中应用带CheckBox的TreeView
- C#中关于TreeView的WinForm编程
- winform中treeView的简单使用
- WinForm 中TreeView 控件的使用实例
- constraint用法总结 II
- 初识 UNIX
- define和typedef的一个小例子
- sqlserver2008 文件流
- C语言结构体传参分析
- Winform中TreeView的绑定
- 学习所得
- jquery随记(DOM操作)----插入元素
- 不同OS下调用参数的不同
- 一个强大的父类:BaseDao
- FileUpload1文件上传
- eclipse中的快捷键
- MyISAM InnoDB 区别
- 自定义QT按钮