Hi!
I'm going mad trying to develope a little more the bugbase...
I want to assign a bug to a user (that exists in the aspnet_user file).

In the addeditbug.vb and .aspx I added a dropdownlist to select the user, also I've added I new field called reportmemberId in the Bug table...

I can save the Bug correctly, with the reprtmemberid included, but when I edit the bug I don't know
the way to recover and, after, find the value Id (guid) for this user, and show it
like the feature (for example).

 If lstFeature.Items.FindByValue(myBug.Feature.Value.T oString()) IsNot Nothing Then
                    lstFeature.Items.FindByValue(myBug.Feature.Value.T oString()).Selected = True
                End If

this is my example:

                    If lstReportUser.Items.FindByValue(myTask.ReportMembe rId.ToString) IsNot Nothing Then
                        lstReportUser.Items.FindByValue(myTask.ReportMembe rId.ToString()).Selected = True

reportmemberId is a guid filed, so it can't be converted to string to find and display it in the dropdownlist

Maybe I am wrong in the way to do it... May You help me with any indication, please? Thanks a lot.

Hi mrco,

How does the drop down for the list of users look like? Do you store the ID of the user as the DataValueField (that is, the value option in the HTML option element) and the user's name as the DataTextField? If that's the case, your code should work.

However, if you use the name for both the text and the value, your code won't work as FindByValue will never be able to find a guid in the list of users.

If this doesn't help, can you post the code to bind the user drop down?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks! but I think this is what I did..
that's the code I think you asked for..:
[u]the dropdownlist</u>
  <td style="height: 24px; width: 282px;"><asp:DropDownList ID="lstReportUser" runat="server" AppendDataBoundItems="True" DataSourceID="odsReportUser" DataTextField="UserName" DataValueField="UserId" Width="180px">
      <asp:ListItem>Please make a selection</asp:ListItem>
  </asp:DropDownList><asp:Label ID="lblReportUser" runat="server" Visible="False" /></td>

[u]the source</u>

<asp:ObjectDataSource ID="odsReportUser" runat="server" SelectMethod="GetUserItems"
    TypeName="ListManager"></asp:ObjectDataSource>


Is it correct?
thanks!

Yeah, that looks fine. However, whether this code works depends on what GetUserItems returns. Since this is not part of the original BugBase application, it's hard for me to see what it returns.

Can you post the code for the method as well?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Sure! That's the code:

[u]Public Class ListManager</u>

Public Shared Function GetUserItems() As DataSet
        Return GetListItems(ListType.aspnet_Users)
    End Function


[u]Public Enum ListType</u>
...
    aspnet_Users
...



[u]Public Shared Function GetListItems</u>(ByVal theListType As ListType) As DataSet
    Dim dataSet As DataSet = New DataSet
    Dim sql As String = ""
    Select Case theListType
...
Case ListType.aspnet_Users
                sql = "sprocUserSelectList"
...

[u]Procedure</u>
ALTER procedure [dbo].[sprocUserSelectList]
AS

SELECT DISTINCT
  UserId,
  UserName
FROM
  aspnet_users
ORDER BY
  UserName

Thanks a lot!! :)

Hmmmm, that all looks as it should.

Are you sure the Users dropdown is databound before you try to set its selected item?

Try setting a break point on the line " If lstReportUser.Items.FindByValue(myTask...." and the put a watch on lstReportUser. Does it have any items at that stage?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

That's the info. The debugg doesn't stop at line 2. So it doesn't find the user, does it?

[u]debugg stop</u>
1.If lstReportUser.Items.FindByValue(myTask.ReportMembe rId.ToString) IsNot Nothing Then
2. lstReportUser.Items.FindByValue(myTask.ReportMembe rId.ToString()).Selected = True
3. End If


[u]string value</u>
myTask.ReportMemberId.ToString "f833b7b7-bd45-41fa-8cd4-1796a0e06d11" String

[u]aspnet_user file</u>
88d9d34b-8c81-4bba-87a5-cdac69277f30 f833b7b7-bd45-41fa-8cd4-1796a0e06d11 SuperUser superuser NULL False 26/01/2007 11:09:08

[u]
Watch</u>- Items {System.Web.UI.WebControls.ListItemCollection} System.Web.UI.WebControls.ListItemCollection
        Capacity 4 Integer
        Count 1 Integer
        IsReadOnly False Boolean
        IsSynchronized False Boolean
        Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Web.UI.WebControls.ListItem
+ SyncRoot {System.Web.UI.WebControls.ListItemCollection} Object


I don't know how to see the lstReportUser items in the watch... sorry...

Thanks!

You can watch an item by typing it directly in the Watch window. You could, for example enter:

lstReportUser.Items(0) to watch the first item in the list.

However, this is more worrying:

Count 1 Integer

A count of 1 seems to indicate the list hasn't been databound yet. I think the single item in the list is your hard coded "Please select an item" option.

Try calling databind before you try to set the selected item:

lstReportUser.DataBind()If lstReportUser.Items.FindByValue(myTask.ReportMembe rId.ToString) IsNot Nothing Then
  lstReportUser.Items.FindByValue(myTask.ReportMembe rId.ToString()).Selected = True
End If

Does that help?

Imar

Wonderful!!!!
I inserted the code:

lstReportUser.DataBind()

and now It works!!!

Thanks a lot!!!!! :):)

You're welcome.

Have fun with it....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.