Inserting Variables Into A Query Using SqlDataSource

 

Hi all,

I was wondering if anyone can help me figure out how to insert a
variable into a query using Visual Studio 2005 with the SqlDataSource
control. I cant seem to be able to enter a var into the query
parameters.





this is my SqlDataSource:

        <asp: SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:imLookinLikeConnectionString
%>"
            DeleteCommand="DELETE FROM [tblDiaryEntries] WHERE [DiaryEntryID] = @DiaryEntryID"
           
SelectCommand="SELECT tblDiaryEntries.DiaryEntryID,
tblDiaryEntries.EntryDate, tblDiaryEntries.Subject,
tblDiaryEntries.DiaryEntry, aspnet_Users.UserName FROM tblDiaryEntries
INNER JOIN aspnet_Users ON tblDiaryEntries.UserID = aspnet_Users.UserId
WHERE UserName=@UserName ORDER BY tblDiaryEntries.EntryDate DESC"
           
UpdateCommand="UPDATE [tblDiaryEntries] SET [DiaryEntry] = @DiaryEntry,
[EntryDate] = @EntryDate, [Subject] = @Subject WHERE [DiaryEntryID] =
@DiaryEntryID" InsertCommand="INSERT INTO tblDiaryEntries(UserID,
EntryDate, Subject, DiaryEntry) VALUES (@UserId, GETDATE(), @Subject,
@DiaryEntry)">
            <DeleteParameters>
                <asp: Parameter Name="DiaryEntryID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp: Parameter Name="DiaryEntry" Type="String" />
                <asp: Parameter Name="EntryDate" Type="String" />
                <asp: Parameter Name="Subject" Type="String" />
                <asp: Parameter Name="DiaryEntryID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp: Parameter Name="DiaryEntry" Type="String" />
                <asp: Parameter Name="EntryDate" Type="String" />
                <asp: Parameter Name="Subject" Type="String" />
                <asp: ProfileParameter DefaultValue="Anonymous" Name="UserName" PropertyName="UserName" />
                <asp: Parameter Name="UserId" />
            </InsertParameters>
            <SelectParameters>
                <asp: ProfileParameter DefaultValue="Anonymous" Name="UserName" PropertyName="UserName" />
            </SelectParameters>
        </asp: SqlDataSource>


What I want to do is to tell the SqlDataSource that  @UserName = this.User.Identity.Name, but I only know how to do that in
code-behind, not sure how to insert it into the code above.Any ideas?