Use QueryString On UserId Defined In AspNet_membership?
Mar 19, 2011
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>" SelectCommand="SELECT * FROM [JobList] WHERE [UserId] = @UserId">
<SelectParameters>[code]....
How to use QueryString on UserId defined in aspNet_membership? My order table has a foreign key of UserId from aspNet_membership, uniqueidentifier. I tried above by walking through the configure datasource,even specify a single UserId not working
I have a confusing question, I have a user table and it stores all the usual data for a user that you would expect but im trying to figure out how a user could add another user?
Sounds strange but each user in the User table has his own UI which is UserID how could I add another table where UserID can have a relationship with another UserID?
i.e how would I right the syntax for the above question if I wanted to display all the UserIDs friends on a page. How would I add a friend.
I want to create a mailto hyperlink that contains not just one user address but the entire contents of the email column in the table aspnet_membership table.
aspnet_membership is parent table. tbl_country is child table.
In table aspnet_membership I must add new column ID autoinc primarykey? Is it sufficient if I add a column in the table tbl_country new columns UserId foreignkey, and then join aspnet_membership with UserId primarykey and table tbl_country UserId foreignkey?
I am working on the user registration process which uses the asp.net membership provider. When users are registered with the application, the some of the user details(emailID, password, password salt, password question, answer etc) are stored in aspnet_Membership table.
We have a requirement of adding two additional columns in the same table for secondary password question and answer. I see that this table has a lot of dependencies with the membership stored procedures. Kindly let me know how some of the extra columns can be added to this table.
I have used session to the creation of user and led them to the edit page ..But how do I retrieve my userID off from the session, or are there other ways to retrieve userID from?
I have a problem with my membership management. I moved the aspnet membership database to my MSSQL server and I would like to create an add user form not using the CreateUserWizard (I would like to add more information then in the simple CUW). I've created the form and I would like to use the Membership.CreateUser method to add the user. After running the script (VB) the user is available in the aspnet_Users table, also in the aspnet_UserInRoles table but not in the aspnet_Membership table. I'm sure that something is wrong with the configuration, I just can't find what.
I've created a membership system based on asp.net 2. There are other tables that store user information, such as emails sent etc. I've created a users table based on the TableProfileProvider. My question is concerning deleting the member
Is it OK to delete the member from the aspnet_membership table and roles related tables using Membership.DeleteUser, though keep all the custom tables and the information including the information in the Users table created by the TableProfileProvider? or can you foresee problems?
Here in below code i have used querystring for sending imagename from this page to another page. Now i just want that with this imagename in also want to send span element's text with same querystring.How can i achieve this?
The following code works well as long as I pass a querystring value to the datalist.
Private Sub BindGrid() Dim id As Integer = Integer.Parse(Context.Request.QueryString("id")) Dim strConnString As String = ConfigurationManager.ConnectionStrings("Conn").ConnectionString Using con As New SqlConnection(strConnString) Using cmd As New SqlCommand() cmd.CommandText = "select Id, Name from tblFiles where Id=@Id"
[Code] ......
However, the page errors with the message "Value cannot be null." if I don't pass a value. I know that DataList does not have an EmptyItem Property like a Gridview control. I do not want the page to error if I don't pass a value. Need info to deal with empty values in a datalist.
Most websites have pointed me to this code to use:
The 'list' throws an error. The error is "Too few type arguments to 'System.COllections.Generic.List". I am not sure if the code is written in C# and that is what is causing the error. It seems that it should work but I can not figure out the 'list' error.
I'm using the ASP.Net Membership provider, but I don't want to allow system administrators to DELETE any users. Instead, I simply want to mark them as locked out (aspnet_Membership.IsLockedOut) of the system so they can't log in when an administrator assigns them to a role titled "Inactive". Make sense? Right now my trigger isn't throwing any errors, but it's not working either. Here's my trigger (which is on the aspnet_UsersInRoles table):
in social networking sites when we login in left side it shows link of our scrapbook and when we open on others persons profile these links open his scrapbook not ours. as i know that it links open according to user_id but how. what will be the code for that link so that link changes according to userid in asp.net. and one other question in our profile it shows link like profile edit, scrapbook, album, many more and when we open others it shows only few links how these link increase or decrease according to userid. Is these links comes from the dtatbase or somthing else. where these coding takes place in webform or in masterpage or any other place using c#
When I create the user I am also pulling the UserID as I need it to enter this into a secondary table. However, the number that seems to come back is different then what ends up getting stored in the membership table ? can someone tell me why that is and what I might be doing wrong ? what i have noticed is that it truncates the first 3 characters when it is returned back?
I am setting up membership and rolls for a small forum site that im working on. All this info is stored in the standard aspnetdb database. When a user is logged in and saves a post to the forum, their UserId is saved to a database in unique identifier format such as: b40e346d-0399-4bbb-90ee-c7c440726cfd. I want to set up a web service so that the name of the author of each post can be clicked on to retieve details about him or her. Rather than passing along the UserId of the author to the web service, I want to pass along the UserName and use that to retrieve the user's Id, which will in turn be used to query the database. I cant seem to find info on how to do this. I can find how to retrieve this kind of info for the current logged in user, but not any or all users in general.
I am trying to get a user Id by user email, but I am getting an error like this Incorrect syntax near '.'. 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.Data.SqlClient.SqlException: Incorrect syntax near '.'.
Source Error:
[Code]....
Source File: C:UsersSparrowDocumentsVisual Studio 2008WebSitesCTSSLApp_CodeFunctions.vb Line:40
Here is the code behind public Shared Function LoadDataSet(ByVal sqlStmt As String, ByVal sqlTable As String) As DataSet 'connection Dim myConn As New SqlConnection
myConn = New SqlConnection (Conn) 'initialize dataAdapter Dim myDA As SqlDataAdapter myDA = New SqlDataAdapter (sqlStmt, myConn) 'Set command type as store procedures.......................
if (Membership.ValidateUser(userName, password)) { // i get a null object on the below as i haven't logged in yet Guid UserID = new Guid(Membership.GetUser(User.Identity.Name).ProviderUserKey.ToString()); // some other logic that requires UserId }
I have a LoginControl that works great, however, I want it to store more information than just being authenticated or not. I would like to store the UserID of the user so when they make changes I can call that UserID and record that they made the changes.
Here is my code.
Dim db As New DataClassesDataContext Dim User = (From UserTable In db.Users _ Select UserTable _ Where UserTable.Active = True And _ UserTable.Name = LoginControl.UserName And _ UserTable.Password = RC.CryptedText _ ) If User.Count = 1 Then e.Authenticated = True Else e.Authenticated = False End If
I just want to be able to call the UserID later, I'm able to login and access the pages fine, but something like
How can I get the exact ID of a user that is logged into a site?
I'm using the login and registration controls created by Visual Studio 2010, in the database the unique identifier is in this 28e8957e-00b8-4e75-bec9-2b90e640962d for example how can I return the exact one to be used in an SQL command for example?
