I'm using .NET 3.5 and C# I've been searching a lot trying to find out how to change the default GUID that is generated by the membership provider to just use an ever increasing INT. Sounds like it's possible but I don't know what code I need to change.
View 1 RepliesWe are using AD and i have a requirement for one my sitefinity module to get GUID from corresponding SID. So i created a class library and overrided GetUser method. But i doubtful with my method. I am sure whether i am getting correct GUID. Herez my code. Kindly let me know how to get corresponding GUID from SID
[Code]....
I would like to insert a GUID into my table, then pass that variable to another page where I will use it in an email validation. Is this how you create a GUID?
[Code]....
Is this how I would insert it into my table?
[Code]....
We have a system where an administrator can login and create other users. If the administrator creates another user, then logs out and immediately logs back in with the new user information the UserID Guid is not available. If you log out and login again with the new username it works, or if you simply refresh the page it works.
Why does it not work on the first run?
I am in the process of building a survey using asp.net and store these results into a database. Now this is what I am trying to achieve: - The survey is fairly long but will be split up in sections. - the way I have been told to develop this is to save each section into the database when the user clicks on a next button for example rather than clicking a final submit button and then submitting the results all in one go to the database. The reason being is for example, the user's browser crashes etc or if they accidentally close it down. I need to build it such a way that survey can remember who the person is.
I can't use windows authentication as it will be externally based, is there anyway I can uniquely identify people when they arrive on the web application e.g. by using a guid? Can it be guaranteed that the person who arrives on the application with a guid on that machine be exactly the same when he/she arrives again?
Once the client is logged in, do I have access to their GUID via something like
User.Identity.Name
I've created a table with a userId column of type uniqueidentifier, and have set that column as the primary key. In the column properties, under the Default Value or Binding, I've put (newid()). I thought that this would create a new uniqueidentifier if no value is specified in the insert statement.
However, when I try to add a new row in the table data view and leave the userId blank, it does not let me add the row. It gives me an error saying that the value cannot be NULL (since it is a primary key), however I had deliberately left it NULL so that it would add a new value by calling newid(). Have I made a false assumption?
I'd like to use sql to select top (#) random row into another table, but it inserts the same record a few times sometimes. I want to avoid duplicates to be inserted, what shall I do?
what I've got for now is
INSERT INTO CompWin (PrizeID, EntryID, UserID) SELECT TOP (50) PrizeID, EntryID, UserID FROM CompEntry ORDER BY NEWID()
What is wrong with this code? The error is Object reference not set to an instance of an object.
I have the below code in my class, then on the login page i need the GUID so i can perform a lookup in one of our custom tables. But then the error above pops up before the page even loads at the line Guid guid = (Guid)userInfo.ProviderUserKey;
[Code]....
I've got a sp as below:
The functionality I want to achieve is that when isHomePageFeatured is checked then this record is set to 1 for that column and for all the other records in the table it is set to 0.
This is fine for update as I can use the property Id to compare against, but for the newly inserted record it doesn't yet have a propertyId so I wondered if using newID() to affect all other records would have the same affect.
[Code].....
I have a url which will take the following form:
/AuditReview/Review/15d49a66-5c11-492c-921f-9e1700bd2618
I cannot get this to route, my routes look like this:
MvcRoute.MappUrl("{controller}.mvc.aspx/{action}/{auditEventUid}")
.WithDefaults(new {controller = "AuditReview", action = "Review"})
.WithConstraints(new { controller = "AuditReview", action ="Review", auditEventUid = new GuidConstraint() });
MvcRoute.MappUrl("admin/{controller}.mvc.aspx/{action}")
.WithDefaults(new { controller = "audit", action = "index" })
.WithConstraints(new{controller = "audit"})
.AddWithName("admin", routes);
MvcRoute.MappUrl("{controller}.mvc.aspx/{action}")
.WithDefaults(new {action = "Index"})
.AddWithName("Default", routes);
I am thinking to use grid as the Primary key for every item created by the user.I have gone through then msdn page, and it say that it is very low probability to get the same guid and that atll.Does anyone know that how low the probabilty is to get the same guid because once the PK is set to use guid and if guid fail to appear unique, the whole systemm need to redone.
View 4 RepliesHow can I cast from object to GUID in asp.net???
View 4 RepliesI'm using ASP.Net/C# and I have a form that allows people to add information into a table and along with it I want to collect the Current Users GUID and insert it.
I have a field setup (UserID) as a unique identifier and I have the following code:
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
Guid temp = (Guid)(Membership.GetUser(User.Identity.Name).ProviderUserKey);
Guid @currentUserID = temp;
}
SqlConnection con = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True");
SqlCommand cmd;
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("insert into Accom (UserID) values('" + @currentUserID + "')", con);
cmd.ExecuteNonQuery();
}
I basically want to link the variable to the Database how as the above gives errors.
I want to add a user's GUID in with the information I retrieve from a user when they submit a post. How can I get the GUID?
I am using the default authentication system that comes along with an ASP.NET MVC application.
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.
I am still new to ASP.net and it has been some time since i worked with code in general, so please forgive me for sounding stupid. I am using SQL to populate several drop down lists in a form, and later using the values selected to populate a datagrid. My issue is that the value i am trying to assign is a GUID in the database. So when I:
Do While (reader.Read())
Dim newListItem
As
New ListItem()Loop
newListItem.Value = reader.GetGuid(0)
newListItem.Text = reader.GetString(1)
Stat.Items.Add(newListItem)
I get an error stating :"Value of type 'System.Guid' cannot be converted to 'String'". My solution to this was to change "newListItem.Value = reader.GetGuid(0)" to
newListItem.Value = reader.GetGuid(0).ToString
that worked to generate the drop downs which was great, but now i am trying to use that value in a sql statement to populate a listbox and since the value is now a string, i cannot use it in my where clause to against a GUID field in the database. I would prefer to not have to convert the GUID in the first place, but have no idea how i could keep it in that format for my drop down list, and if that is not possible how can i convert the data back to GUID from String?
I have a couple of tables I ported over to a new database. Everything is exactly the same from the legacy one to the new one. The back-end code that submits the user generated data to the database is also the same. When I submit changes to the database, all of the submitted information populates the correct columns but the column that stores the GUID populates with all 0's. When I enter in the columns manually using SQL Server Management Studio, the GUID gets populated as it does in the legacy version.
View 2 RepliesSo I'm almost finished my project but I'm stuck. In my application's database I save some records that contain the currently logged in user's userID - and so when it comes to displaying these records, I've been just been outputting the userID whilst developing the rest of the application. Through googling I've found this line of code that will get the a username based on a userID:
Dim membershipUser As MembershipUser = Membership.GetUser(New Guid(userGUID))
Which works great if I can supply it with a GUID - but I'm struggling to see how I can use this line of code if for example I want to show the usernames for comments on an article which are contained in a repeater control.Maybe it would be simpler to just merge my application's database with the asp.net membership database (ASPNETDB.mdf) so I can just select the username in SQL instead - but I'm not even sure how to do that.
I'm attemping to use the Yahoo Contacts API to add an "invite your friends" feature on a site I'm building.
I've found the correct web service to call (http://social.yahooapis.com/v1/user/{guid}/contacts) but it is asking for the user's GUID, not their username/password.
I've searched, and am unable to find a "lookup" feature through the Yahoo API which lets me get the user's guid from their username/password.
Does anyone have any experience with the Contacts API.
I've reaad over the documentation, and looked at YQL as well, but I still haven't found how to get the user's guid.
In the following question, I am using C# and ASP.NET 3.5:I am having a problem with a gift certificate program which requires a way to have the user retrieve a unique validation code consisting of the first 9 digits of a random GUID and the date and time. I have a page that has a button which creates these labels perfectly, but I can't figure out how to bind them to the certificate being validated This is the page described above:
[Code]....
I am open to calling another page called via a hyperlink like so:
For my CMS I want users to be able to upload pictures which connect to a product. This all goes well until someone wants to upload a picture when creating a new record.
The problem here is that every product has a GUID (next to the ProductID (PK)) and will be created when the product is saved for the first time. I'm uploading my images trough a webservice with Uploadify jquery plugin so it's all in an ajax based way. The image uploader however needs to know the GUID to store it in the right directory.
My temporary fix was to just let the user save the product before uploading so the GUID is known but it's not very user friendly and I'm sure there would be a better way but I cannot find a satisfying one myself.
This is the only option which I could come up with which is kinda ok but maybe I'm missing something completely:
Create a GUID without saving the product, so the image can be uploaded and the product with the GUID can be saved afterwards. But what if the user navigates away after uploading? I could maybe create a scheduled task to delete those orphant images
Has anyone dealt with similar scenarios? I'm very interested in your opions about his matter since this functionality will be used in multiple sections in my CMS.
I am making a database with SQL server 2008 express edition and trying to make a GUID for new users signing up. I have the UserID field as a NVARCHAR(36) with a default value of NEWID() but all it keeps providing are all 0's for all 36 characters. How do I fix it where it provides a true GUID with all random letters/number?
View 1 RepliesI have an SqlDataSource with following command:
SELECT * FROM [vw_aspnet_MembershipUsers] WHERE ([UserId] = @UserId)
When I pass simple GUID like "3bd08871-d5d6-4f38-8c8a-29fd6077a719" as a UserId, then nothing gets selected. So what is the correct format for passing the GUID value?
How can I use a Guid for implementing single sign on the same domain? I can't use sessions as the different web apps would open in new windows hence loosing the session.
Technology used: ASP.net 3.5, MVC2 architecture, C#.