Sort Project Drop Down List RSS

• • Reply
  

  Je_fait_le_l...

  Member

  25 Points

  79 Posts

  Sort Project Drop Down List

  Sep 16, 2010 04:32 PM|LINK

  How can I sort the ProjectList Drop Down list?

  
  

  
  

  this code is in the TimeEntry Page_Load Event
  

  
  

  
  

  if (!Page.IsPostBack) {
        if ((Page.User.IsInRole("ProjectAdministrator") || Page.User.IsInRole("ProjectManager"))) {
          UserList.DataSourceID = "ProjectMembers";
  
  
          if (Page.User.IsInRole("ProjectAdministrator")) {
            ProjectData.SortParameterName = "sortParameter";
            ProjectData.SelectMethod = "GetAllProjects";
          }
          else if (Page.User.IsInRole("ProjectManager")) {
  
  
            ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name));
            ProjectData.SortParameterName = "sortParameter";
            ProjectData.SelectMethod = "GetProjectsByManagerUserName";
          }
  
  
        }
        else {
          ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name));
          ProjectData.SelectMethod = "GetProjectsByUserName";
  
  
          UserList.Items.Add(Page.User.Identity.Name);
        }
        ProjectList.DataBind();
        UserList.DataBind();

  
  

• • Reply
  

  Je_fait_le_l...

  Member

  25 Points

  79 Posts

  Re: Sort Project Drop Down List

  Sep 16, 2010 06:42 PM|LINK

   I commented out the lines //ProjectData.SortParameterName = "sortParameter" and that made the sort ascending alpha which is what the stored procs do in the db   
  

  • Marked as answer by Je_fait_le_logiciel on Sep 16, 2010 06:42 PM