computerstreber
asked on
Database Sorting Error
I have developed the following code to fill a TreeView control:
private void FillServerList()
{
//MySelectCommand.CommandT ext = "nsp_get_server_name";
MySelectCommand.CommandTex t = "uspGetStatus";
dreader = MySelectCommand.ExecuteRea der();
tvwServDB.Nodes.Clear();
while (dreader.Read())
{
//WorkNode = tvwServDB.Nodes.Add(dreade r["server_ name"].ToS tring());
WorkNode = tvwServDB.Nodes.Add(dreade r["Status_ Desc"].ToS tring());
//WorkNode.ForeColor = SetStatusColor(dreader["st atus_desc" ].ToString ());
}
dreader.Close();
}
The code itself works perfectly. However, the result set is ordered differently than the SQL statement output. For example, the stored procedure that is executed above results in the following:
P
O
D
C
This is how I want to have it show up. Unfortunately, my treeview shows the same data like this:
C
D
O
P
How can I keep Visual Studio from sorting this?
private void FillServerList()
{
//MySelectCommand.CommandT
MySelectCommand.CommandTex
dreader = MySelectCommand.ExecuteRea
tvwServDB.Nodes.Clear();
while (dreader.Read())
{
//WorkNode = tvwServDB.Nodes.Add(dreade
WorkNode = tvwServDB.Nodes.Add(dreade
//WorkNode.ForeColor = SetStatusColor(dreader["st
}
dreader.Close();
}
The code itself works perfectly. However, the result set is ordered differently than the SQL statement output. For example, the stored procedure that is executed above results in the following:
P
O
D
C
This is how I want to have it show up. Unfortunately, my treeview shows the same data like this:
C
D
O
P
How can I keep Visual Studio from sorting this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.