private void bindTree()
{
DataTable dt = this.GetTreeData();
this.FillNode(dt, null);
}
private void FillNode(DataTable dt, TreeNode node)
{
DataView dv = new DataView(dt);
if (node == null)
{
dv.RowFilter = "parentid='0'";
}
else
{
dv.RowFilter = "parentid'" + node.Value + "'";
}
}
private DataTable GetTreeData()
{
string strcnn=ConfigurationManager.ConnectionStrings["sqlconm"].ConnectionString;
using(SqlConnection sqlcn=new SqlConnection(strcnn))
{
SqlCommand sqlcm=sqlcn.CreateCommand();
sqlcm.CommandText="select * from MenuTree order by parentid,menuorder";
SqlDataAdapter da=new SqlDataAdapter(sqlcm);
DataSet ds=new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
}