ASP.NET

public partial class _Default : System.Web.UI.Page
{
    public static SqlConnection sqlConn = new SqlConnection();
    public static SqlCommand sqlCmmd = new SqlCommand();
    public static SqlDataAdapter sqlDAptr = new SqlDataAdapter();
    //public DataSet busDataSet
    //{
    //    get
    //    {
    //        return DS;
    //    }
    //    set
    //    {
    //        DS = value;
    //    }
    //}
    
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            //GetTables();
            PassQuery();
            //abc();
        }
        catch (Exception)
        {
            throw;
        }
    }


    public void PassQuery()
    {
        this.TreeView1.Nodes.Clear();

        DataSet myFirstTable = new DataSet();

        string Query = "select name from sys.tables";
        myFirstTable = Retun_Table_BasedOn_Query(Query);
        DataSet[] mySecondTable = new DataSet[myFirstTable.Tables[0].Rows.Count];

        for (int i = 0; i < myFirstTable.Tables["Table"].Rows.Count; i++)
        {
            string str1 = myFirstTable.Tables["Table"].Rows[i][0].ToString();

            string Query2 = "SELECT  sysobjects.name As Names, syscolumns.name AS FieldName " +
                           "FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id " +
                           "WHERE (sysobjects.name = '" + str1 + "')";
            mySecondTable[i] = Retun_Table_BasedOn_Query(Query2);
            
            TreeNode tnParent;
            TreeNode tnChild;

            for (int a = 0; a < 1; a++)
            {
                tnParent = new TreeNode();
                tnParent.Text = str1.ToString();
                TreeView1.Nodes.Add(tnParent);

                foreach (DataRow rowChild in mySecondTable[i].Tables["Table"].Rows)
                {
                    tnChild = new TreeNode();
                    tnChild.Text  = rowChild["FieldName"].ToString();
                    tnParent.ChildNodes.Add(tnChild);
                }
            }
        }
    }

    public void Open_Connection()
    {
        string Conn_Str = "Data Source=dev-test;Initial Catalog=Malik;Persist Security Info=True;User ID=interns;Password=intern123";
        sqlConn = new SqlConnection(Conn_Str);
        if (sqlConn.State != ConnectionState.Open)
        {
            sqlConn.Open();
        }
    }

    public DataSet Retun_Table_BasedOn_Query(String Query)
    {
        Open_Connection();
        DataSet mydataSet = new DataSet();
        sqlCmmd = new SqlCommand(Query, sqlConn);
        sqlDAptr = new SqlDataAdapter(sqlCmmd);
        sqlDAptr.Fill(mydataSet);
        return mydataSet;
    }
}

T_Teef wrote:

Open_Connection();
DataSet mydataSet = new DataSet();
sqlCmmd = new SqlCommand(Query, sqlConn);
sqlDAptr = new SqlDataAdapter(sqlCmmd);
sqlDAptr.Fill(mydataSet);
return mydataSet;

public static class SessionItems
 {
     public static YourObjectType YourObject
     {
         get
         {
             Object result = HttpContext.Current.Session["YourObject"];
             if (result == null)
                 return null;
             else
                 return (YourObjectType)result;
         }
         set { HttpContext.Current.Session["YourObject"] = value; }
     }
  }