Select Records For The Current Logged On User

Hi all

I've been having a really difficult time finding out how to run a query which selects records from an SQL database for the current logged on user. I've tried a whole manner of different approaches but here is where I am at now:

<script runat="server">

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

If Not Page.IsPostBack Then

ds_meobservingcolleagues.SelectParameters(0).DefaultValue = User.Identity.Name

End If

End Sub

</script>

 

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ds_meobservingcolleagues">

</asp:GridView>

<asp:SqlDataSource ID="ds_meobservingcolleagues" runat="server" ConnectionString="<%$ ConnectionStrings:StPaulsDatabase %>"

SelectCommand="SELECT [observeTeacher], [observeBy], [observeReason] FROM [Observations] WHERE ([observeBy] = @observeBy)">

<SelectParameters>

<asp:Parameter Name="observeBy" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

 

This is not resulting in any error. But it is not returning the records that it should be either.

Please can anyone help? I'm sure it shouldn't be this difficult to do