protected override void CreateChildControls()
        {
            
            base.CreateChildControls();
            EnsurePanelFix();
            UpdatePanel refreshPanel = new UpdatePanel();
            ScriptManager scriptHandler = new ScriptManager();
            
            scriptHandler.ID = "scriptHandler";
            refreshPanel.ID = "refreshPanel";
            refreshPanel.UpdateMode = UpdatePanelUpdateMode.Conditional;
            refreshPanel.ChildrenAsTriggers = true;


            TreeView tree = new TreeView();
            tree.ID = "tree";
            tree.ShowLines = true;
            string q = "строка подключения";
            sqlConn = new SqlConnection(q);
            sqlConn.Open();
            string root = "select * from tree where id_par=0";
            using (SqlCommand sqlCommand = new SqlCommand(root,sqlConn))
            using (SqlDataReader reader = sqlCommand.ExecuteReader())
            {
                while (reader.Read())
                {
                    TreeNode rootNode = new TreeNode();
                    rootNode.Text = reader.GetString(2);
                    rootNode.Value = reader.GetInt64(0).ToString();
                    tree.Nodes.Add(rootNode);
                    treeBuild(rootNode);
                }
            }
            sqlConn.Close();
            refreshPanel.ContentTemplateContainer.Controls.Add(tree);
            this.Controls.Add(scriptHandler);
            this.Controls.Add(refreshPanel);
        }
        private void EnsurePanelFix()
        {
            if (this.Page.Form != null)
            {
                            String fixupScript = @"
                 _spBodyOnLoadFunctionNames.push(""_initFormActionAjax"");
                 function _initFormActionAjax()
                 {
                   if (_spEscapedFormAction == document.forms[0].action)
                   {
                     document.forms[0]._initialAction = 
                     document.forms[0].action;
                   }
                 }
                 var RestoreToOriginalFormActionCore = 
                   RestoreToOriginalFormAction;
                 RestoreToOriginalFormAction = function()
                 {
                   if (_spOriginalFormAction != null)
                   {
                     RestoreToOriginalFormActionCore();
                     document.forms[0]._initialAction = 
                     document.forms[0].action;
                   }
                 }";
                            ScriptManager.RegisterStartupScript(this,
                              typeof(objectsTree), "UpdatePanelFixup",
                              fixupScript, true);
            }
        }