In addition to the fields defined in CreateUserWizard i want to add some more fields to store information in database for some purpose.But could not get the way to execute the task.
View 1 RepliesI'm using the ASP.NET Membership system to add new users to my site. It's working fine. But I'd like to force the user to enter additional required information (on a different aspx page) before they can successfully complete the registration process. What is the easiest way to direct and force the user to complete a different page of fields (stored in SQL in columns located on the same table as the basic membership fields) as a condition of completing the registration process?
In searching different sites, I see additional properties and templates like Wizard Steps, Continue button, Finish button---but I'm not clear as to which of these (perhaps none of them?) will allow me to accomplish this goal.
1) Extend the CreateUserWizard control to insert additional User fields (eg. Gender, Age, Occupation, Address, Phone, etc...).
OR
2) Create a brand new Custom Membership Provider of my own and skip using the inbuilt ASP.NET membership system.
What is the best way to create a new User system with my own tables of User data as described above?
Should i perhaps still use the standard ASP.NET membership system and then extend my own Registration page to add more User data to my own SQL backend table using the Identity value inserted into the aspnet_users table?
I am using the CreateUserWizard to create users in my new project (I am a complete newbie), but the wizard currently requires information from the user that is redundant for what I need. For example, I don't want security question & answer in my form, but I am not sure how to remove them. If I just remove the text fields, it says they are missing. I am pretty sure I know how to require further information, but I am not sure how to remove some of the defaults from the wizard. Removing the columns from the SQL server shouldn't be a problem.
So, I am looking for a place to edit which information it should gather (and removing some of the defaults) and the SQL insertion code so I don't gather information I will never need and use.
I am experimenting with the customization of the createuserwizard by creating textboxes for FirstName and Last Name. I have altered the web.config file to add the fields, but where does the actual data get stored? What C# code do I need to create, if any?
View 3 RepliesI am trying to add new fields in membership table by using createuserwizrad control. is it possible to do that?
View 3 RepliesI am attempting to customise the CreateUserWizard by following it in my book, but when I come to reference them in code behind I get an error saying 'FieldName is not declared' for each field i'm adding, they are present in the page with the correct ID's, am I doing something wrong?I am only trying to add a firstName and lastName field to the bottom of the CreateUserWizard and remove the need to a security question.
View 1 RepliesI am using the CreateUserWizard in my VB.Net 3.5 web app. I added my own custom fields (First Name, Last Name...) to the form by using the CreateUserWizardStep and the CreateUserWizard1_CreatedUser event. Everything inserts fine into the aspnet_ tables and my own table. However, I cannot get the form validation to work. In other words, the form is ignoring the RequiredFieldValidators that I added.
View 4 RepliesI need to clear the UserName and Email textbox fields in my CreateUserWizard.. Below is the code..
[Code]..........
I want to create a user registration form, I used the CreateUserWizard control, and i intend to add more filed with the wizard interface, the fields were firstname,lastname, telephone all these with the textBox control and sex-male or female with a radioButton control, and upload photo with the FileUpload control.
After a successfull submit to the sql database, i should be able to retrieve all this informtion inluding the photo uploaded in another aspx page using any of the data control in y toolbox and resizein the photo to be 100/100 pixel size. pls could you write out the code (step by step details) to follow to implement all this in my asp.net 3.5 c# website. I have already created a table in my database, using userId as my ForeignKey.
I'm not familliar with the membership provider class. On my create user page I have the following code
[Code]....
If I want to add some fieds like phone number and address, how can I do it? And what happen to the following function if those fields are added.
[Code]....
Is there a way to assign a value to the password field in the CreateUserWizard Control programmatically when the page loads. I would like to assign this value using a random password function that returns the password string without converting it an editable template.
View 2 RepliesIs there a property i can call to set the maximum length for the username or password field in a CreateUserWizard Control to limit the numebr of characters entered in the field? If so, how can this be done?
View 2 RepliesI'm trying to write a form for a user to leave a testimonial on the website. I would like a group of inputs related to the users name (title, firstname and surname) or an input for their company name to be required. They can leave both if they like, but they must at least either fill in all the inputs related to their name or the input for their company name.can I do this with the RequiredFieldValidator?
View 3 RepliesI need to get two fields from a database table (retrieved using linq-to-sql), one field is a datetime (and is a fixed field) and the other is always a decimal, but the field can be different.
The table holds currency data which is processed twice a day and in different currencies so could have fields such as AM_USD, PM_USD, AM_EUR etc. And I need to get data such as a list of the date against PM_USD or the date against AM_EUR.
I would like to be able to call the data using a lambda expression for example (this is a stripped out example):
data = TableData.Select(x=>new {x.DateTimeAdded, x.[**field name as string**]});
I have been trying to write a function to do this, and am failing dismally.
The closest I have managed is:
private Func<TableData, KeyValuePair<DateTime, decimal>> CreateSelect(string FieldName)
{
var parameterExp = Expression.Parameter(typeof(TableData), "sel");
var dateParameter = Expression.Parameter(typeof(DateTime), "DateTimeAdded");
var fieldParameter = Expression.Parameter(typeof(decimal), FieldName);
ConstructorInfo constructorInfo = typeof(KeyValuePair<DateTime, decimal>).GetConstructor(new[] { typeof(DateTime), typeof(decimal) });
NewExpression constructExpression = Expression.New(constructorInfo, new ParameterExpression[] { dateParameter, fieldParameter});
var lambda = Expression.Lambda<Func<TableData, KeyValuePair<DateTime, decimal>>>( constructExpression, parameterExp);
return lambda.Compile();
}
Which fails with "System.InvalidOperationException: Lambda Parameter not in scope".
I'm sure I missing something obvious, or going about it wrong way.
i want to use a function to get all the fields from a LINQ table as ill be using this table alot i thought putting it in a function would be quicker
how can i get all the fields and all the field data from linq table and use it in a function
for example
var address1 = FunctionName.Address1
var postcode = functioname.postcode
or however i can make this work
[Code]....
ive a DB in access with a single table and no primary key, actually i dont need a primary key but i can consider a date field plus another to make an index. however i want to add a counter field based on every change of date field, for instance ill have many records of 20/May and all must have the same id then when the date is different, the next group of records with that new date must show 2 etc.. is it a quick way to update my database?
View 6 RepliesI have a situation where I have a file with each Account Record contains Monthly Expense Total Fields and Monthly Budget Fields for 2009, 2008 and 2007. I'm working with 72 fields (36 Expense and 36 Budget).
Need to create New Year Proceure that will shift data from 2008 to 2007, 2009 to 2008 and move Zeros to 2009 for both Expenses and Budgets.
I can do this using Parameters and Update SQL but I am under the impression that I must specificaly name each field in defining Parameters and SQL Update Command.
Since all fields are sequential withing a record, is there a way that I can use a For/Next loop to index my way through the fields moving data from one year to another?
When using DataReader I'm able to use reader.item(index) to access data record fields.
I have selected the tables using the wizard, but for some reason CR doesn't display all the fields in the tables, so there are some tables in Field Explorer that lack some fields. The fields that aren't shown are both int, and varchar, some of them allow nulls and some of them don't, I can't seem to find a pattern as why some fields aren't loaded into Field Explorer.
View 4 RepliesI am working on a search engine application and was hoping there was a way to take multiple fields from the database and combine the values (separated by spaces) into a single virtual field, without having to actually add it to the database
Let's say I have 2 fields, FirstName and LastName - can I take these 2 fields and combine them into a Name field where Name = FirstName + " " + LastName
What I'm going to be attempting has a lot more to it than that, but if I can get an example on how to achieve that, I can apply that same principle on a larger scale
ways of doing this with AND/OR, I want to combine multiple fields into a single field
I want to insert username and password into two tables (say table1 as well as table 2) using stored procedure.
View 4 RepliesThis is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then
Try
If pasDate <= System.DateTime.MinValue Then
Return Nothing
Else
Return CType(pasDate, DateTime)
End If
Catch ex As NullReferenceException
Return Nothing
End Try
Else
Return Nothing
End If
End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
I have a grid view attached to a custom query. The query selects data and the address data in the database is split into different fields like street_address1, mail_zip etc. etc. What I would like to do is display all the address data fields in my database in one field on the Grid View.
View 1 RepliesI have a sql database that on some field will have a empty string/field. I am using a Datalist to display my results. How do I not make the labels that are empty not display? Currently if the field is empty it will leave a space there which my goal is if the field is empty do not leave a white space instead move the other colunms up.
View 2 RepliesI have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this
title if the datafield is empty. Here is what I have done so far.
<ItemTemplate>
<asp:Label ID="BusinessLabel" runat="server" Text='<%# "Tel. "+Eval("Business") %>' CssClass="TeleStyle" />
Or This:Tel.
<asp:Label ID="BusinessLabel" runat="server" Text='<%# Eval("Business") %>' CssClass="TeleStyle" />
</ItemTemplate>
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?