storing the login name in my personal database

shario · June 14th, 2006, 04:42 PM

Sorry, Imar, you've been so helpful!

No, it isn't working. The code I posted does not include the parameter from the page completeAccount.aspx to userDetails.aspx. I added the parameter to the redirect code (response.redirect(userDetails.aspx?username={0}). When I did this, I get an exception.

I am using the SQLDataSource code....

    Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, _
            ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEv entArgs) _
            Handles SqlDataSource1.Selecting
        e.Command.Parameters("UserName").Value = User.Identity.Name
    End Sub

This is the exception error:

System.IndexOutOfRangeException was unhandled by user code
  Message="An SqlParameter with ParameterName 'UserName' is not contained by this SqlParameterCollection."
  Source="System.Data"
  StackTrace:
       at System.Data.SqlClient.SqlParameterCollection.GetPa rameter(String parameterName)
       at System.Data.Common.DbParameterCollection.get_Item( String parameterName)
       at adminTest_userDetails.SqlDataSource1_Selecting(Obj ect sender, SqlDataSourceSelectingEventArgs e) in C:\Documents and Settings\shari.PEAKBIZ\My Documents\Visual Studio 2005\WebSites\cpfaa\adminTest\userDetails.aspx.vb: line 8
       at System.Web.UI.WebControls.SqlDataSourceView.OnSele cting(SqlDataSourceSelectingEventArgs e)
       at System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments arguments)
       at System.Web.UI.DataSourceView.Select(DataSourceSele ctArguments arguments, DataSourceViewSelectCallback callback)
       at System.Web.UI.WebControls.DataBoundControl.Perform Select()
       at System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind()
       at System.Web.UI.WebControls.DetailsView.DataBind()
       at System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound()
       at System.Web.UI.WebControls.DetailsView.EnsureDataBo und()
       at System.Web.UI.WebControls.CompositeDataBoundContro l.CreateChildControls()
       at System.Web.UI.Control.EnsureChildControls()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

shario · June 14th, 2006, 06:06 PM

Maybe the problem is in the select query...I've tried it as a session, as a querystring...several of the options and none have worked. What should this be if it is based on the selecting event code you provided?

        <SelectParameters>
            <asp:SessionParameter Name="userName" SessionField="username" Type="String" />
        </SelectParameters>

shario · June 17th, 2006, 02:28 PM

Hi Imar -

Have you had a chance to look over the new post, or does anyone else have an idea? Thank you!

Imar · June 18th, 2006, 07:17 AM

Are you storing the user name in a Session field called UserName? If not, this code will never work.

Did you try a normal parameter, like this:

<asp:Parameter Name="UserName" />

in combination with the selecting event?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Mantra by Tool (Track 4 from the album: Lateralus) What's This?

saf · December 7th, 2006, 01:54 PM

Hi Imar

I need to do something similar and I know the answer is in this post somewhere I just can't seem to put it in the right place..

All I want to do is use the currently logged in user's name (user.identity.name) in an sqldatasource control as a select parameter (e.g where studentname = user.identity.name) I can't figure out how to code the query to use this???? I searched and read posts on using expression builders and created custom parameters but there must be an easier way. only authenticated users get to my page, user.identity.name returns the name I want to query my database by....please help.

saf

Imar · December 7th, 2006, 05:47 PM

Hi saf,

Did you try my suggestion from my last post in this thread? E.g. set up a param like this:

<asp:Parameter Name="UserName" />

and then use the Selecting event of the data source to fill that parameter with the user's name?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

saf · December 7th, 2006, 08:59 PM

Afraid I'm having the same problem as shario. I get error message:

An SqlParameter with ParameterName 'SchoolName' is not contained by this SqlParameterCollection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: An SqlParameter with ParameterName 'SchoolName' is not contained by this SqlParameterCollection.

Source Error:

Line 20:
Line 21: Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEv entArgs) Handles SqlDataSource1.Selecting
Line 22: e.Command.Parameters("SchoolName").Value = User.Identity.Name
Line 23:
Line 24: End Sub

What am I doing wrong???. Here is my sqldatasource:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:LunchOrderConnectionString %>" SelectCommand="SELECT [CategoryName], [CategoryItemName], [Price] FROM [vw_OrderForm] WHERE ([SchoolName] = @SchoolName)">
        <SelectParameters>
            <asp:Parameter Name="SchoolName" Type="String" />

        </SelectParameters>
    </asp:SqlDataSource>

As always, I appreciate your time and patience....

saf · December 8th, 2006, 03:57 AM

Nevermind....

I just used a hidden field valued with user.identity.name instead. Works just the same...Can't believe I didn't think of that 10 hours ago....

Thanks anyway

Imar · December 8th, 2006, 08:13 AM

I just played around with this a little, and it seems that for SQL parameters you need to prefix the name with an @ symbol, just as in the query. The following code worked for me:

Code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
  ConnectionString="YourConnectionString"
  SelectCommand="SELECT [CreateAuthor] FROM [Content] WHERE ([CreateAuthor] = @CreateAuthor)">
  <SelectParameters>
    <asp:Parameter Name="CreateAuthor" Type="Object" />
  </SelectParameters>
</asp:SqlDataSource>

Then fill the parameter in the Selecting event like this:

Code:

Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, _
      ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) _
      Handles SqlDataSource1.Selecting

  e.Command.Parameters.Item("@CreateAuthor").Value = _
      Membership.GetUser().ProviderUserKey

End Sub

Instead of the Guid from Membership.GetUser().ProviderUserKey you can of course have a String parameter and fill it with User.Identity.Name.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.