Database Sorting Error

I have developed the following code to fill a TreeView control:

private void FillServerList()
            {
                  //MySelectCommand.CommandText =  "nsp_get_server_name";
            MySelectCommand.CommandText = "uspGetStatus";
                  dreader = MySelectCommand.ExecuteReader();
                  tvwServDB.Nodes.Clear();
                  while (dreader.Read())
                  {
                        //WorkNode = tvwServDB.Nodes.Add(dreader["server_name"].ToString());
                WorkNode = tvwServDB.Nodes.Add(dreader["Status_Desc"].ToString());
                        //WorkNode.ForeColor = SetStatusColor(dreader["status_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?
LVL 3
computerstreberAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
LordOfPortsConnect With a Mentor Commented:
The TreeView object has a boolean property named Sorted http://msdn.microsoft.com/en-us/library/system.windows.forms.treeview.sorted.aspx that you can set to false, e.g.:

tvwServDB.Sorted = false;
0
All Courses

From novice to tech pro — start learning today.