[DotNetDevelopment] use a Select field from one SqlDataSource in another SqlDataSource

[Gadgetman]

Hi,
This VS 2008 using ASP.NET 3.5
I have 2 SqlDataSources statements and I would like to use a field
that results from the one SqlDataSource (SqlDataSourceDiary) as a
ControlParameter in another SqlDataSource (SqlDataSourceInteractions).
Is this possible? As currently I get a runtime error that EntryID is
not a property of  SqlDataSourceDiary .

Here is my code.

<asp:SqlDataSource ID="SqlDataSourceInteractions" runat="server"
    ConnectionString="<%$ ConnectionStrings:SEIFSAConnectionString
%>"
    SelectCommand='SELECT Diary.ClientNumber, Diary.ClientType,
Diary.EntryID, DiaryInteractionCodes.Description FROM Diary INNER JOIN
DiaryInteractionBridge ON Diary.EntryID =
DiaryInteractionBridge.DiaryEntryID INNER JOIN DiaryInteractionCodes
ON DiaryInteractionBridge.InteractionID =
DiaryInteractionCodes.InterationID WHERE (Diary.ClientNumber =
@MemberNumber) AND (Diary.ClientType = @Origin) AND (Diary.EntryID =
@entid)' >
    <SelectParameters>
        <asp:QueryStringParameter Name="MemberNumber"
QueryStringField="memnumber" />
        <asp:QueryStringParameter Name="Origin"
QueryStringField="Originated" />
        <asp:ControlParameter ControlID="SqlDataSourceDiary"
Name="entid"
                PropertyName="EntryID" DefaultValue=""  />
    </SelectParameters>
</asp:SqlDataSource><br />

<asp:SqlDataSource ID="SqlDataSourceDiary" runat="server"
    ConnectionString="<%$ ConnectionStrings:SEIFSAConnectionString
%>"
        SelectCommand="SELECT EntryID, ClientType, ClientNumber,
DiaryType, ContactDate, FollowUpDate,            SeifsaStaffID FROM
Diary WHERE (ClientNumber = @MemberNumber) AND (ClientType = @Origin)"

    <SelectParameters>
        <asp:QueryStringParameter Name="MemberNumber"
QueryStringField="memnumber" />
        <asp:QueryStringParameter Name="Origin"
QueryStringField="Originated" />
    </SelectParameters>
</asp:SqlDataSource>

Thanks, Stewart