Hi all,
I am trying to grab data from the database that this application is connecting to and then show entries in a treeview.
| public void dbcall() |
| { |
| SqlConnection sqlconn = new SqlConnection("user id=USERNAME;" + "password=PASSWORD;server=SERVER;" + "database=DBNAME;" + "connection timeout=30"); |
| SqlCommand select = new SqlCommand("SELECT * from MAIN", sqlconn); |
| sqlconn.Open(); |
| SqlDataReader reader = select.ExecuteReader(); |
| DataSet ds = new DataSet(); |
| DataTable dt = new DataTable("MainTable"); |
| ds.Tables.Add(dt); |
| ds.Load(reader, LoadOption.PreserveChanges, ds.Tables[0]); |
| |
| sqlconn.Close(); |
| |
| foreach (DataRow dr in dt.Rows) |
| { |
| |
| //////////// |
| |
| |
| |
| } |
| |
| } |
| |
The data that I am getting out of the database looks like this:
ID Hostname Username Software
1 host1 user1 sw1
2 host1 user1 sw2
3 host1 user1 sw3
4 host1 user1 sw4
5 host5 user5 sw1
6 host5 user5 sw2
7 host5 user5 sw3
8 host5 user5 sw5
9 host9 user9 sw1
10 host10 user10 sw1
I need the data to be displayed in the tree as follows, though nothing that I have done so far has been able to do it:
host1>user1>sw1
sw2
sw3
sw4
host5>user5>sw1
sw2
sw3
sw5
Any help with this would be appreciated. Thanks in advance.