Help Selecting A Value From SQL To Pass To Query

I am trying to do the following.  I am capturing the logged in username from Windows Authentication then stripping the domain name using the following code
Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting
        Dim Bareusername
        e.Command.Parameters("@strusername").Value = My.User.Name
        Bareusername = My.User.Name.Replace("MyDomain", "")
        e.Command.Parameters("@LoginName").Value = Bareusername
    End Sub
I use the derived value as the where clause in a select query Select * from Master Where AccountName = @LoginName.  This allows a user to only see their own information in DetailsView1.  This is working as desired.

I have another column in the Master table named ID.  This ID is the key that I need to reference to allow users to see and edit data in other tables.  So I would like to be able to do something like
Select ID from Master where AccountName = @LoginName and be able to pass this value to  a Select statement against another table(Awards) for a DetailsView2 on the same page. 
Alternatively the value that I am trying to query is in the first row of DetailsView1.  Is it possible to access the value in that field and pass it in the query for DetailsView2?  This would be simpler if possible.

I am not sure how to go about this and would appreciate any guidance that you could provide.  I have found a lot on the web regarding this based on a selected value but not through the method that I am trying to use.  
Thanks in advance,
Ken