C#

// where i am calling the function
private void sQLServer2005ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            parentNode = new TreeNode();
            DBTree.Nodes[0].Text = Show_SqlConnection();
            parentNode.Text = "Databases";
            DBTree.Nodes[0].Nodes.Add(parentNode);
            LoadSQL_DB(parentNode); 
        }

// which loads databases and tables

public void LoadSQL_DB(TreeNode DB)
        {
            DataTable table = new DataTable();
            SqlConnection sqlConnection1 = new SqlConnection();
            TreeNode treeNode;
            TreeNode tablesNode;
            int count = 0;            
            SqlCon = new SqlConnection("Data Source= Localhost; Integrated security=True;database='' ");
            SqlCon.Open();
           
            SqlCom = new SqlCommand();
            SqlCom.Connection = SqlCon;
            SqlCom.CommandType = CommandType.StoredProcedure;
            SqlCom.CommandText = "sp_databases";
            SqlCom.Connection = SqlCon;
            SqlDR = SqlCom.ExecuteReader();
            table = ReaderToTable(SqlDR);
           

             //Get the Database Nodes
            foreach (DataRow row in table.Rows)
            {
                treeNode = new TreeNode();
                treeNode.Text = row["DATABASE_NAME"].ToString();
                DB.Nodes.Add(treeNode);                
                DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Tables");
                tablesNode = new TreeNode();
                LoadSQL_Tables(treeNode);
                DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Stored Procedure");
                DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Views");
                DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Roles"); 
 count++;
            }            
            SqlDR.Close();
            SqlCon.Close();

// function which loads tables
 public void LoadSQL_Tables(TreeNode arg_dbNode)
        {
            TreeNode table_node;
            SqlCon = new SqlConnection("Data Source= Localhost; Integrated security=True;database=master");
            SqlCon.Open();
            SqlCom = new SqlCommand();
            SqlCom.Connection = SqlCon;
            SqlCom.CommandType = CommandType.Text;
            SqlCom.CommandText = "select * from sysobjects where type = 's' order by name";
            
            SqlDR = SqlCom.ExecuteReader();
            while (SqlDR.Read())
            {
                table_node = new TreeNode();
                table_node.Text = SqlDR.GetString(0);
                arg_dbNode.Nodes.Add(table_node);            
            }
         

        }

public DataTable ReaderToTable(SqlDataReader reader)
       {
           DataTable newTable = new DataTable();
           DataColumn col;
           DataRow row;
           int i;

           for (i = 0; i < reader.FieldCount; i++)
           {
               col = new DataColumn();
               col.ColumnName = reader.GetName(i);
               col.DataType = reader.GetFieldType(i);

               newTable.Columns.Add(col);
           }

           while (reader.Read())
           {
               row = newTable.NewRow();
               for (i = 0; i < reader.FieldCount; i++)
               {
                   row[i] = reader[i];
               }

               newTable.Rows.Add(row);
           }

           return newTable;
       }

private TreeNode parentNode;
private readonly string connString = "server={0};Integrated Security=true;database={1}";

// where i am calling the function
private void sQLServer2005ToolStripMenuItem_Click(object sender, EventArgs e)
{
    parentNode = new TreeNode();
    DBTree.Nodes.Add(Show_SqlConnection());
    parentNode.Text = "Databases";
    DBTree.Nodes[0].Nodes.Add(parentNode);
    LoadSQL_DB(parentNode);
}

// Method which loads databases and tables
public void LoadSQL_DB(TreeNode DB)
{
    DataTable table;
    TreeNode treeNode;
    TreeNode tempNode;
    int count = 0;

                // Note the use of the 'using' statement. This ensures that the connection gets closed
                // and disposed of when it is finished with.
    //SqlCon = new SqlConnection("Data Source= Localhost; Integrated security=True;database='' ");
    using (SqlConnection SqlCon = GetConnection(@"Localhost", ""))
    {
        SqlCommand SqlCom = new SqlCommand();
        SqlCom.Connection = SqlCon;
        SqlCom.CommandType = CommandType.StoredProcedure;
        SqlCom.CommandText = "sp_databases";

        SqlCon.Open();
        SqlDataReader SqlDR = SqlCom.ExecuteReader();
        table = ReaderToTable(SqlDR);
    }

    //Get the Database Nodes
    foreach (DataRow row in table.Rows)
    {
        treeNode = new TreeNode();
        treeNode.Text = row["DATABASE_NAME"].ToString();
        tempNode = treeNode.Nodes.Add("Tables");
        tempNode.Nodes.Add(""); // All that this does, is add a dummy node
        tempNode = treeNode.Nodes.Add("Stored Procedure");
        tempNode.Nodes.Add(""); // adding a dummy node ensures that the '+' icon appears
        tempNode = treeNode.Nodes.Add("Views");
        tempNode.Nodes.Add("");
        tempNode = treeNode.Nodes.Add("Roles");
        tempNode.Nodes.Add("");
        count++;

        DB.Nodes.Add(treeNode);
    }
}

// function which loads tables
public void LoadSQL_Tables(TreeNode arg_dbNode, string database)
{
    DataTable table;

    using (SqlConnection SqlCon = GetConnection("Localhost", database))
    {
        SqlCommand tablesCommand = new SqlCommand();
        tablesCommand.CommandType = CommandType.StoredProcedure;
        tablesCommand.CommandText = "sp_tables";
        tablesCommand.Parameters.Add("@table_qualifier", SqlDbType.NVarChar, 384).Value = database;
        string paramString = "'TABLE'";  // The inner single quotes are required
        tablesCommand.Parameters.Add("@table_type", SqlDbType.VarChar, 32).Value = paramString;
        tablesCommand.Connection = SqlCon;

        SqlCon.Open();
        SqlDataReader SqlDR = tablesCommand.ExecuteReader();
        table = ReaderToTable(SqlDR);
    }

    foreach (DataRow row in table.Rows)
    {
        arg_dbNode.Nodes.Add(row["TABLE_NAME"].ToString());
    }

    // get rid of the dummy node. If we have found any tables we don't need it
                // and if there are no tables we don't need to show the '+' icon.
    arg_dbNode.Nodes.RemoveAt(0);
}

private SqlConnection GetConnection(string server, string database)
{
    return new SqlConnection(string.Format(this.connString, server, database));
}

public DataTable ReaderToTable(SqlDataReader reader)
{
    DataTable newTable = new DataTable();
    DataColumn col;
    DataRow row;
    int i;

    for (i = 0; i < reader.FieldCount; i++)
    {
        col = new DataColumn();
        col.ColumnName = reader.GetName(i);
        col.DataType = reader.GetFieldType(i);

        newTable.Columns.Add(col);
    }

    while (reader.Read())
    {
        row = newTable.NewRow();
        for (i = 0; i < reader.FieldCount; i++)
        {
            row[i] = reader[i];
        }

        newTable.Rows.Add(row);
    }

    return newTable;
}

        // Dont forget to add this to the BeforeExpand event of your TreeView
private void DBTree_BeforeExpand(object sender, TreeViewCancelEventArgs e)
{
    if ((e.Node.Nodes.Count == 1) && (e.Node.Nodes[0].Text == ""))
    {
        // You will have to add a case for any other types
        // that you want to get data for.
        // I have put an example in and commented it out
        switch (e.Node.Text)
        {
            case "Tables":
                LoadSQL_Tables(e.Node, e.Node.Parent.Text);
                break;
            //case "Views":
            //    LoadSQL_Views(e.Node, e.Node.Parent.Text);
            //    break;
        }
    }
}

public void LoadSQL_DB(TreeNode DB)
       {
           DataTable table = new DataTable();
           SqlConnection sqlConnection1 = new SqlConnection();
           TreeNode treeNode;


           int count = 0;
           SqlCon = new SqlConnection("Data Source= Localhost; Integrated security=True;database=master ");
           SqlCon.Open();

           SqlCom = new SqlCommand();
           SqlCom.Connection = SqlCon;
           SqlCom.CommandType = CommandType.StoredProcedure;
           SqlCom.CommandText = "sp_databases";
           SqlCom.Connection = SqlCon;
           SqlDR = SqlCom.ExecuteReader();
           table = ReaderToTable(SqlDR);


            //Get the Database Nodes
           foreach (DataRow row in table.Rows)
           {
               treeNode = new TreeNode();
               treeNode.Text = row["DATABASE_NAME"].ToString();
               DB.Nodes.Add(treeNode);
               DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Tables");



               DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Stored Procedure");
               DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Views");
               DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes.Add("Roles");

               if (DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count].Text == "Tables")
               {
                   LoadSQL_Tables(DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count], treeNode.Text);

                   if (DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count+1].Text == "Stored Procedure")
                       LoadSQL_StoedProcedures(DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count + 1], treeNode.Text);
                   if (DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count + 2].Text == "Views")
                       LoadSQL_Views(DB.Nodes[DB.Nodes.IndexOf(treeNode)].Nodes[count + 2], treeNode.Text);
               }

           }


           SqlDR.Close();
           SqlCon.Close();




       }// End of LoadSQL_DB....

Eddy Vluggen wrote:

You want to embed some UserID-marker in your excutable/class library, before it gets downloaded and installed?

Eddy Vluggen wrote:

approach would be to compile a personalized version, build and create a setup, prior to downloading.

Eddy Vluggen wrote:

When you start your executable;
- Check if your classlibrary is in place, if not:
- Start the download of the class-library (from code, or manual)
- The WebApp gets requested to download a file, compiles the classlib with the embedded string and push the generated file.

Eddy Vluggen wrote:

I'll try to build a small prototype to do this thing, might take a while

Eddy Vluggen wrote:

compiles the classlib with the embedded string and push the generated file.