C#

private void GetDatabaseSps(TreeView tree, TreeNode spsNode, string sqlServerInctance)
        {
            // create a list of strings to hold name of sps
            List<string> sps = new List<string>();

            // get database name from parent node (database node is parent node of tablesNode)
            string database = spsNode.Parent.Text;

            // create a server object to interact with sql server inctance
            Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(sqlServerInctance);

            // iterate through each sp that exist in database object
            foreach (Microsoft.SqlServer.Management.Smo.StoredProcedure sp in server.Databases[database].StoredProcedures)
            {
                if (sp.IsSystemObject)
                {
                }
                else
                {
                    sps.Add(sp.Name);
                }
            }

            // clear current nodes
            spsNode.Nodes.Clear();

            // iterate through list object and add each item (table name) to treeView
            foreach (string str in sps)
            {
                // create a node to hold table name (child node or level 1)
                TreeNode spNode = new TreeNode(str);

                // add tableNode to tablesNode
                spsNode.Nodes.Add(spNode);
            }
        }

Admin887 wrote:

DO you have any link that shows to me how to do it?