i have an accessdatasource and i want gridview to pull some data based on the current user.  how do i do this?  i'd rather not do this through a code behind if possible...

thanks

<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/myDb.mdb" SelectCommand="SELECT Deals.Name, Tranches.Name AS Expr1, Access.UserName FROM ((Deals INNER JOIN Tranches ON Deals.ID = Tranches.ID) INNER JOIN Access ON Tranches.ID = Access.TrancheID) WHERE (Access.UserName = ?)">
        <SelectParameters>
            <asp:Parameter Name="?" />
        </SelectParameters>
    </asp:AccessDataSource>

Create a custom parameter!

http://weblogs.asp.net/anasghanem/archive/2008/10/15/creating-custom-parameters-for-your-data-sources.aspx