C# - Adding Another Table Where UserID Can Have A Relationship With Another UserID?

Mar 31, 2011

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.

View 4 Replies


Similar Messages:

VB - Adding UserId To Custom Table After Membership.CreateUser?

Nov 18, 2010

There are lots of posts about this issue but I can't work out the answers as most of them are for C# or similar. I'm trying to automatically insert the UserId generated by Membership into a custom table. I have membership working correctly, as well as the custom table (I'm able to insert other things from the registration form). But I can't get it to extract the generated UserId and insert it into the custom table. Here's my code:

[Code]....

As you can see I've experimented with the parameters for inserting the record, but that doesn't work (I get an error about ProviderKey not being a part of system.web.security.membershipuser).

View 3 Replies

Security :: How To Retrieve UserID Off From The Session, Or Are There Other Ways To Retrieve UserID From

Jun 28, 2010

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?

View 3 Replies

Can't Insert A Guid (userID) Into Table!

Feb 10, 2011

I'm creating a web project for one of my uni modules using Visual studio 2010. I'm using asp.net membership and have all of my sql-server tables set up correctly (I'm pretty sure).

I have a form that I have created myself that inserts into the database using sqlDataSource.insert(). I had some problems initially with not being able to insert any data into the table at all, but I have cleared that up.

My problem now is that I need to insert the currently logged in user's userID into one of the columns of the table. But every time I hit the submit button, I am told I cannot insert null values in the userID column.

I can retrieve the userID using this snippet:

[Code]....

This is the code behind for the page:

[Code]....

As you can see it is a bit of a mess, I've been frantically trying different variations, as I need to catch up a little with other uni modules.

Here is my SQLDataSource from the .aspx page, The controlparameters work fine for the other data I am inserting. maybe the <asp:parameter name="userID" /> is wrong?

[Code]....

I'm relatively new to vb, and I come from a html & css background.

View 1 Replies

Web Forms :: Matching Logged In Userid To ID In Another Table?

Feb 2, 2011

So I have been trying to pull the userid of whoever is currently logged in and match it to another table that it is a fk in. I have some code that should work but I get an error that says specified cast is not valid in line 10.

here is the code I have behind file:

[Code]....

View 4 Replies

C# - Retrieve UserId From Membership Users Table?

Jun 6, 2010

i'm new to membership. i have a table named contact, with a field, userId that must get its data from the membership users table. so when a user is created i have to get the userId from membership users table. how can i do that?

View 1 Replies

Security :: Pass Membership UserID To Db Table?

Oct 1, 2010

i'm using asp.net membership for logins/registeration. i have a bookings table with few fields, lets say first_name, last_name, product_name and userID.when the user submits 'buy' i want to get the userID from the membership user tablem that way i know whose made the booking. i'll have these two tables (bookings & user tables) linkedbut how do i get userID from the user table to pass to bookings table? i checked the membership class and it gives options like-Membership.GetUser(), Membership.GetUserNameByEmail(), Membership.GetAllUsers() etcothing for getting user id. user id is stored like this: c1c91682-449f-45dd-b20e-3dac5315bba4

View 2 Replies

Web Forms :: Custom Table Profile Provider Has Different UserID?

Feb 11, 2010

I created the Table Profile Provider with the VB.NET and it works perfectly but I have one issue with it.. My Table (UserProfile) can't be linked with any other tables because the UserID on userprofile is different than any other table yet when I do profile.firstname on the vb code it works perfectly. Say for example I have a username called john If I do select * from aspnet_users where username = 'john' The results would come to 2 rows, 1 which has a userid and applicationid that is used on ALL the tables in my database EXCEPT for userprofile The second one would have a applicationid and userid that is only use on my userprofile table.

View 1 Replies

Security :: Best Way To Insert Newly-created UserId Into A Second Table Also?

Sep 25, 2010

[Code]....

View 9 Replies

Security :: How To Automatically Insert UserId Into A Custom Table

Jun 27, 2010

I recently read Scott Mitchell's article series "Examining ASP.NET's Membership, Roles, and Profile". In Part 6 [URL] It says "to store additional, user-specific fields...If you are using the SqlMembershipProvider, this would mean creating an additional database table that had as a primary key the UserId value from the aspnet_Users table and columns for each of the additional user properties."

I created a table named Thread to store some specific users information and comments they make. I set the ThreadId as the primary key and the UserId as the foreign key to the UserId in aspnet_Users table. But when I run the application and use a user's account to submit a comment, there is an error in my Comments.aspx.vb page "Cannot insert the value NULL into column 'UserId', table 'ASPNETDB.dbo.Thread'; column does not allow nulls. INSERT fails.The statement has been terminated."

How can I make the logged-on user's UserId inserted into the Thread table when storing the user's other data information?

View 6 Replies

Security :: Link Aspnet_users To Table With UserID As Foreign Key?

Aug 10, 2010

Perhaps this is a simpler VS9 question, but I want to link a SQLServer table with additional user data to the standard SQLServer membership table using the GUID userID as a foreign key. I go into design mode of my table, right-click on relationships, and click add in the dialog. but the left hand column shows me only the tables in my database. How do I get it to show the tables in the ASPNETDB.MDF database? I went through the tutorial (http://www.asp.net/learn/security/tutorial-08-cs.aspx), but it seems to magically appear in there without explanation.

View 3 Replies

C# - Trying To Select UserID, FirstName, SecondName, PicturePath(from Pictures Table)?

Apr 2, 2011

I'm trying to select UserID, FirstName, SecondName, PicturePath(from Pictures table) LIKE FirstName (string search = textbox.text)

OdbcCommand("SELECT UserID, FirstName, SecondName, p.PicturePath FROM User LEFT JOIN Pictures p ON p.UserID = u.UserID WHERE FirstName LIKE '%" + search + "%' ORDER BY UserID DESC", cn))

My syntax is way messed up. My table structure:

View 4 Replies

Web Forms :: Table Profile Provider Writes UserID Twice In Query - Causes Error

May 21, 2010

I get this error while trying to run my project: "Column name 'UserID' appears more than once in the result column list." Indeed, the query generated in my SqlTableProfileProvider.vb is the following (text in brackets [] has been changed):

"IF EXISTS (SELECT 1 FROM [table] WHERE UserId = @UserId) BEGIN UPDATE [table] SET UserID=@Value0, LastUpdatedDate=@LastUpdatedDate WHERE UserId = '[Guid]'END ELSE BEGIN INSERT [table] (UserId, UserID, LastUpdatedDate ) VALUES ('[Guid]', @Value0,
@LastUpdatedDate) END"

I'll emphasize that the above statement is generated in SqlTableProfileProvider.vb, which was written by .Net people. While I have little control over its source, I've apparently given the fodder whereby the mistake can be generated. Any clues as to why UserID is being written twice in the statement?

View 2 Replies

Forms Data Controls :: How To Change Insert To Edit If UserId Exist In Table

Feb 6, 2011

It sounds pretty simple, but I can't find a way to make it work. I have a FormView with a InsertTemplate where it inserts the current logged in user's UserId and content from a HTMLeditor, and a EditTemplate where it retreives the current logged in UserId and shows content from database in the HTMLeditor.

How can I get it to show EditTemplate if the userId exist in the table, and InsertTemplate if the UserId does not exist in the table?

View 4 Replies

Web Forms :: Passing CurrentUser.UserId With File Upload Control To Database Table?

Feb 18, 2010

implementing an file upload control that uploads the binary data to the database table and associates it with the correct user/the current user who uploaded the data.

View 8 Replies

Security :: Userid Of Newly Created User / To Store Additional Details Of The User In Another Database Table

Nov 10, 2010

Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.

The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?

View 2 Replies

MVC :: Page.user Info - Register User Logs Logs Table - Use Userid

Dec 28, 2010

i use formsauthentication for login. but i wanna register user logs logs table. i can access username page.user.identity.name, but how can use userid?

View 4 Replies

Web Forms :: Link Changes According To Userid

Apr 25, 2010

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#

View 4 Replies

Security :: Why UserID Comes Back Different

Feb 16, 2010

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?

[Code]....

View 6 Replies

Security :: Get UserId From UserName C#?

Jul 31, 2010

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.

View 5 Replies

SQL Server :: Getting UserID By Email

Aug 11, 2010

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.......................

View 1 Replies

How To Get Userid Directly After Login In

Apr 23, 2010

I'm wonder how i can get the userid just after i validate. Is there another method i can use to login than

FormsAuthentication.RedirectFromLoginPage(userName, true);

Here's what i have.

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
}

View 1 Replies

Security :: Get Email From Userid?

Jan 19, 2011

I am using .net membership. How can i get member email address by userid?

View 6 Replies

Security :: Get Username From UserId?

Nov 16, 2010

How do I get the UserName from UserId by the following code?

[Code]....

View 2 Replies

Store An UserID And Name With The LoginControl?

Oct 6, 2010

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

Session("UserID") = LoginControl.UserName

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved