I changed the labels so they're not hard coded anymore, its set in
Page_Load, not sure what you mean about the code though.
Anyways, I figured out that if I add a Gridview and bind it to the
datasource, then it works fine. I'm thinking that the sqldatasource
is not querying the database, and thus, not firing the
SqlDataSource1_Selecting function. Is there a way to manually get the
datasource to query?
On Nov 7, 1:23 pm, KeidrickP <[EMAIL PROTECTED]> wrote:
> ok you have several things wrong here, I`m not sure how this was
> working properly at all.
> On label first name you have text hardcoded
> <asp:Label ID="LabelFirstName" runat="server" Text="Label">First
> Name:</asp:Label>
> Try putting what you want to say here in the page load event of this page.
> Next I would recommend using the code behind pages rather performing
> your functions inline, it makes it easier to read, and catch your
> errors.
> See if you can figure this part out, and you can go from there
>
>
>
> On Fri, Nov 7, 2008 at 3:11 PM, Justin <[EMAIL PROTECTED]> wrote:
>
> > Here's a stand alone page that exhibits my problem....
>
> > <%@ Page Language="VB" %>
>
> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
> >www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
>
> > <script runat="server">
>
> > Protected Sub Page_Load(ByVal sender As Object, ByVal e As
> > System.EventArgs)
> > SqlDataSource1.SelectParameters.Add("UserName",
> > System.Web.HttpContext.Current.User.Identity.Name.ToString)
> > End Sub
>
> > Protected Sub SqlDataSource1_Selecting(ByVal sender As Object,
> > ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
> > Username.Text = e.Command.Parameters("@UserName").Value _
> > & "'s Profile"
> > End Sub
>
> > </script>
>
> > <html xmlns="http://www.w3.org/1999/xhtml";>
> > <head runat="server">
> > <title></title>
> > </head>
> > <body>
> > <form id="form1" runat="server">
> > <div>
> > <asp:Label ID="Username" runat="server" Text="Label"></
> > asp:Label>
> > </div>
> > <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> > ConnectionString="<%$
> > ConnectionStrings:UserInfoConnectionString %>"
> > onselecting="SqlDataSource1_Selecting"
> > SelectCommand="SELECT * FROM [UserInfo] WHERE ([UserName] =
> > @UserName)">
> > <SelectParameters>
> > <asp:Parameter Name="UserName" Type="String" />
> > </SelectParameters>
> > </asp:SqlDataSource>
> > </form>
> > </body>
> > </html>- Hide quoted text -
>
> - Show quoted text -
