TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Nathan
NA
1
0
Treeview From Database
Aug 13 2008 10:57 AM
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.
Reply
Answers (
1
)
Refresh DataGridView in parent window
Starting processing as soon as a form is displayed