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.