TreeView

   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];
        }
    }