<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyDatabaseConnectionString %>"
SelectCommand="select b.whse_code+'-'+b.Whse_name as [Warehouse]from users a join Inventory b on a.cust_code = b.cust_oodewhere a.username = @UserName">
<SelectParameters>
<asp:Parameter Name="UserName" Type="String" DefaultValue="Anonymous" />
</SelectParameters>
</asp:SqlDataSource>
C#
protected void Page_Init(object sender, EventArgs e)
{
SqlDataSource1.SelectParameters["UserName"].DefaultValue = this.Page.User.Identity.Name;
}
VB.Net
Protected Sub Page_Init(sender As Object, e As EventArgs)
SqlDataSource1.SelectParameters("UserName").DefaultValue = Me.Page.User.Identity.Name
End Sub