title: Binding data to treeView c#
body: <p>I wish my program worked like this:
  1.It takes data form MS SQL
  2.Makes tree based on this data(data rows)
  3.I have few textBoxex and I want to fill them with data based on clicked node.
  I`ve made class for SQL connection:</p>
  
  <pre><code> class Baza
  {
      private SqlConnection connection;
      string dbdir = "Data Source=CS24\\SQLEXPRESS;user id=sa;password=alamakota;database=SHARP;connection timeout=3";
      public Baza()
      {
        connection = new SqlConnection();
        connection.ConnectionString = dbdir;
        connection.Open();
      }
      public DataTable get_data(string q) 
      {
          DataTable dt = new DataTable(); 
          SqlDataReader dr ; 
          SqlCommand sqlc = new SqlCommand(q);
          sqlc.Connection = this.connection;
          dr = sqlc.ExecuteReader();
          dt.Load(dr);
          return dt;
      }
  }
  </code></pre>
  
  <p>And treeView creator:</p>
  
  <pre><code>  private void Form1_Load(object sender, EventArgs e)
      {
          Baza baza = new Baza();
          DataTable dt = new DataTable();
          dt = baza.get_data("Select * from Users order by Id asc");
          foreach (DataRow dr in dt.Rows) 
          {
              TreeNode node = new TreeNode(dr["Name"].ToString() + " " + dr["Surname"].ToString());
              treeView1.Nodes.Add(node);
          }
      }
  </code></pre>
  
  <p>I thought that node should have ID which I can use to make data filling but I dont really know how to do it. Can you help me with that?</p>