TreeStructure of Database


Database Connection:
In class1.cs

public DataTable GetDataSource(string Query)
        {

            SqlConnection con = new SqlConnection();
            DataTable dt = new DataTable();
            con.ConnectionString = WebConfigurationManager.ConnectionStrings["company"].ConnectionString;
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(Query, con);
            da.Fill(dt);
            con.Close();
            return dt;

        }

In Default.aspx.cs

namespace treeview
{
    public partial class _Default : System.Web.UI.Page
    {

        Class1 connect = new Class1();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                RootLevel(Treeview1);// Treeview1 is the tree created in Default.aspx
            }
        }



        public void RootLevel(Control ctl)
        {

            string SQlQuery = "select table_Name from information_schema.tables where table_type='BASE TABLE'";//table name reterived
     


            DataTable dt = new DataTable();
            dt = connect.GetDataSource(SQlQuery);
            DataRow[] myrows;
            myrows = dt.Select();//index of table


            TreeView t1 = new TreeView();

            t1 = (TreeView)ctl;
            t1.Nodes.Clear();


            for (int p = 0; p < myrows.Length; p++)
            {// Create Parent Node

                TreeNode parentNode = new TreeNode();

                parentNode.Text = (string)myrows[p]["table_Name"];
                t1.Nodes.Add(parentNode);

             // Get Child Node

                string SQlQuery1 = "select *  from "+ parentNode.Text;

                DataTable dt1 = new DataTable();
                dt1 = connect.GetDataSource(SQlQuery1);
                DataRow[] cmyrows;
                cmyrows = dt1.Select();


                for (int c = 0; c < cmyrows.Length; c++)
                {
                    TreeNode childNode = new TreeNode();
                    TreeNode childNode1 = new TreeNode();
       
                    childNode.Text = (string)cmyrows[c][0];
                    childNode1.Text = (string)cmyrows[c][1];
                 
                    parentNode.ChildNodes.Add(childNode);
                    childNode.ChildNodes.Add(childNode1);
                 
                }
            }

       }
    }
}


Comments

Post a Comment

Popular posts from this blog

How to retain the data annotations or class during modify a table in the database

Image
In database-first approach since there is an existing database., The entity classes are automatically created by edmx model.: If we use [MetadataType(typeof(ConceptMetadataSource))] to attach a MetadataSource file which contains all the data annotations like [HiddenInput(DisplayValue = false)] or [Display(Name = "Title")]. The data annotations will be wiped out each time the entity classes are regenerated as the code will be regenerated once we modify a table in the database Solution: All you have to do is create another partial class and use Metadatatype attribute Create a metadata class in models as below…   Create a Partial class for the metadata in models as below… The new partial class can be created in a different folder
Read more

Interview Questions

Difference between GET and POST. Which one is more secure? GET and POST methods are used for the data transfer between the web pages. GET mainly used for small data which is not secure because in case of GET method, the data which we are passing will be visible in the url so we can't keep the secure data which will be visible in the url. There is also limited data which can be passed in case of GET method (max 255 character). POST is used for transferring the huge data between the pages where we can keep the secure data and can transfer it. In case of using the POST method, the data which is transferring between the pages will not be visible so it is more secure than the GET method. Also there is no limit for POST method to post the data to the next page. POST is more secure What are Razor engines? How is it diff from ASP Engines? A. RAZOR engine is the new concept in the MVC 3 which is mainly used to create the views in the MVC applications. It created the cshtml pages for...
Read more

AJAX CONTROL

Image
1.        Goto  web confiq add following controls        < controls >   < add tagPrefix = " ccl " namespace = " AjaxContolToolkit " assembly   = " AjaxContolToolkit " />      </ controls > 2.        Go to  bin folder  ->  include project -> add ajax.dll file from AjaxControl Toolkit 3.        Add  toolsciptmanager  to default.aspx            < asp : ToolkitScriptManager ID ="ToolkitScriptManager1" runat ="server">         </ asp : ToolkitScriptManager > 4.        Create a function < script type = "text/javascript" >     function panelclick()     {    alert( "click" );  ...
Read more