Guru Sarkar's Blog - All Comments

re: Storing User Profile into a Custom Table using CreateUser Wizard control

guru_sarkar — Tue, 07 May 2013 16:34:06 GMT

@hozdaman,

CreatedUser event is fired only after user is created. And the code is retrieving the ProviderUserKey. So not sure if you are using some different event or something else would be an issue.

re: Storing User Profile into a Custom Table using CreateUser Wizard control

hozdaman — Wed, 24 Apr 2013 15:09:00 GMT

Hi,

This is a great tutorial! Thanks.

How can I add a check to see if if the aspnet_Users table values have been inserted, before the fields for my other table get inserted.

Im finding that foreign key is trying to insert before the aspnet_Users table is updated. Causing a foreign key constraint.

re: Storing User Profile into a Custom Table using CreateUser Wizard control

hozdaman — Mon, 22 Apr 2013 14:24:07 GMT

Hi,

This tutorial is great, thanks so much.

I keep getting the following error. I am wondering do does there need to be a command to let cuw to complete the insert in aspnet_users table before the insert to my User table? Any help would be great. Thanks.

System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_User_aspnet_Users". The conflict occurred in database "xxx", table "dbo.aspnet_Users", column 'UserId'.

here is my code

//get the userid of the newly created user

MembershipUser newUser = Membership.GetUser(CreateUserWizard1.UserName);

Guid newUserId = (Guid)newUser.ProviderUserKey;

//Get Profile data entered by user

String FirstName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserFirstNameTextBox")).Text;

String LastName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserLastNameTextBox")).Text;

String AddressLine1 = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("AddressLine1TextBox")).Text;

String AddressLine2 = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("AddressLine2TextBox")).Text;

String City = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("CityTextBox")).Text;

String State = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("StateTextBox")).Text;

String ZipCode = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("ZipCodeTextBox")).Text;

String PhoneNumber = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("PhoneTextBox")).Text;

//open database connection

string ConnectionString = ConfigurationManager.ConnectionStrings["PersonalManagementConnection"].ConnectionString;

string InsertSql = "INSERT INTO [User](UserId, UserFirstName, UserLastName, UserAddressLine1, UserAddressLine2, UserCity, UserState, UserZipCode, UserPhone1) VALUES(@UserId, @UserFirstNameTextBox,@UserLastNameTextBox,@AddressLine1TextBox, @AddressLine2TextBox, @CityTextBox, @StateTextBox, @ZipCodeTextBox, @PhoneNumberTextBox)";

using (SqlConnection MyConnection = new SqlConnection(ConnectionString))

{

MyConnection.Open();

SqlCommand MyCommand = new SqlCommand(InsertSql, MyConnection);

MyCommand.Parameters.AddWithValue("@UserId", newUserId);

MyCommand.Parameters.AddWithValue("@UserFirstNameTextBox", FirstName);

MyCommand.Parameters.AddWithValue("@UserLastNameTextBox", LastName);

MyCommand.Parameters.AddWithValue("@AddressLine1TextBox", AddressLine1);

MyCommand.Parameters.AddWithValue("@AddressLine2TextBox", AddressLine2);

MyCommand.Parameters.AddWithValue("@CityTextBox", City);

MyCommand.Parameters.AddWithValue("@StateTextBox", State);

MyCommand.Parameters.AddWithValue("@ZipCodeTextBox", ZipCode);

MyCommand.Parameters.AddWithValue("@PhoneNumberTextBox", PhoneNumber);

MyCommand.ExecuteNonQuery();

MyConnection.Close();

}

The statement has been terminated.

re: Pass querystring parameter with NavigaterUrl in HyperLink inside a GridView

khizerjalal — Tue, 09 Apr 2013 12:36:11 GMT

Thanks, Really Helpful =)

/KhiZer

re: Problem with Unordered List ( ul / li ) tags with fixed–width

PRABU MCA., — Tue, 09 Apr 2013 04:24:20 GMT

i had problem with ul..but ur solution very helpful to me .. Thanks brother

re: Setting authorization rules for a particular page or folder in web.config

guru_sarkar — Wed, 27 Feb 2013 17:53:03 GMT

naji,

yes...There's one example above.

re: Setting authorization rules for a particular page or folder in web.config

naji — Sun, 17 Feb 2013 13:36:55 GMT

thanks.

Is it possible to define 1 user in web.config and allow him to a specific folder like admin?

re: Setting authorization rules for a particular page or folder in web.config

Dinesh Gupta — Fri, 01 Feb 2013 17:51:32 GMT

Great888!!!!!! :)

I was confused since last 2 years..........now feeling good :)

Thanks!

re: Storing User Profile into a Custom Table using CreateUser Wizard control

Joe F — Tue, 29 Jan 2013 19:02:50 GMT

This is a great tutorial, thanks. One tip, add:

ON DELETE CASCADE

...at the end of your CONSTRAINT in your User_Profile table. This will allow user deletes from the primary table to cascade to this table also.

re: jQuery UI Datepicker Visible upon first time page load

Osh — Tue, 15 Jan 2013 10:00:59 GMT

Thank you very much kind sir! Very simple solution indeed! :)