I am retrieving user data from aspnet_user table from aspnetdb database but I also want to retrieve data (such as first name, last name, email, address etc) from aspnet_profile table. I am using dropdownlist which retrieves user names from the aspnet_user table.
retrieve user data from aspnet_profile instead?
My code is as followed:
[Code]....
[Code]....
Is it possible to setup the CreateUserWizard to check for a duplicate entry in the aspnet_profile table (for a custom field) before the new user is created? For example, if I added a phone number field and wanted to make sure nobody else could create an account using that same phone number if a user already has an account with that phone number in the aspnet_Profile table's PropertyValuesString row?
View 10 RepliesI am using profiles it works fine but it is not saving in aspnet_profile table besides using save method
In Web Config:
<profile enabled="true" defaultProvider="SqlProvider">
<providers>
<clear />
<add name="SqlProvider"
type="System.Web.Profile.SqlProfileProvider"
connectionStringName="dd"
applicationName="AJAXEnabledFor Master Page"/>
</providers>
<properties>
<add name= "FirstName" />
<add name= "LastName" />
<add name= "Address1"/>
<add name= "Address2"/>
<add name= "City"/>
<add name= "State"/>
<add name= "Country"/>
<add name= "PinCode"/>
<add name= "Contact"/>
</properties>
</profile>
In Code Behind File
if (CreateUserWizard1.ActiveStep.Title == "Complete")
{
Roles.AddUserToRole(CreateUserWizard1.UserName, "Guest");
ProfileCommon p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard1.UserName, true);
WizardStep Details = CreateUserWizard1.FindControl("Details") as WizardStep;
p.FirstName = ((TextBox)Details.FindControl("TextBox1")).Text;
p.LastName = ((TextBox)Details.FindControl("TextBox2")).Text;
p.Address1 = ((TextBox)Details.FindControl("TextBox3")).Text;
p.Address2 = ((TextBox)Details.FindControl("TextBox4")).Text;
p.City = ((TextBox)Details.FindControl("TextBox5")).Text;
p.State = ((TextBox)Details.FindControl("TextBox6")).Text;
p.Country = ((TextBox)Details.FindControl("TextBox7")).Text;
p.PinCode = ((TextBox)Details.FindControl("TextBox8")).Text;
p.Contact = ((TextBox)Details.FindControl("TextBox9")).Text;
p.Save();
}
I've recently used the CreateUserWizard to add firstname, middlename and lastname to my aspnet_Profile table. I was wondering how I would go about placing these values in a dropdownlist (ddlEmployees) so that I may wind up with a list displaying these values concatenated, eg. Mary Anne Brant, Joseph Ezra Shultz etc. That's the firstname, middlename and lastname from the profiles table.
View 9 RepliesI have the aspnet membership on my own sql database, I am trying to add the user's first and last name into my sql select query. How can I do it?
View 3 RepliesBasically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I have a list of user , each user have a profile , contain FullName , stored in ASPNET_PROFILE .
Problem is how can i query them list (username , Fullname ) , order by FullName .
I'm using Entity Framework
I store string using , (comma) now i want to retrieve data back from the comapre string in another with the price.
I store string like this a,b,c,d.
Now i want to retrive it like
name price
a 10
b 20
c 30
totla 60
using ms access databse and .net C#
i got a Food table and a Notification table. each Food has an expiry date. I wish to put all foods which are going to expired into the notification table. since user can create new food anytime, how can i update the Notifcation table once got any new food (but with near expiry date) added? and how to make sure the Notification table retrieve the nearly-expired food everytime (mayb update once everyday??)
View 1 RepliesI have created a dynamic table using user entered values for Rows and columns. After the table is created the data is populated on the table. I have a separate event that is clicked to retrieve this data, but I am not able to get this data upon postback.
I need to convert the table values (in int) to an array for further processing.
I want to check if a user in User table is found either in UserName Column or in FriendUserName Column in UserFollow table and if yes display lable found, But if no display lable notfound. This code will be excuted onse a user logs in the connection code
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] != null && Session["UserName"].ToString() != string.Empty)
{
string userName = Session["UserName"].ToString();
if (!this.IsPostBack)
[code]...
I am creating a kind of feedback website which has a feedback form on it. Each question is answered choosing from a radio button group. the answers to each question are (very good, good, bad, failed). I need to be able to create a table on the webform that will display the number of answers to each questions. for example, if the question is "Rate the use of this software" i need to be able to put in table format say 20 people said "very good", 30 said "good" etc. at the moment i only have one table to display the questions and answers and a date that will be used to select the date's report. so all the information i need is coming from this table. all i need to do is how to say like "SELECT Count* Question where Review date = "user entered date" and answer = "very good" etc.
View 4 RepliesI want to retrieve the data from the last record of a table. For eg: I have sorted the data in my table and want the value from the last record? How can I do that?
Is there a way to check that "saving" data to a table was successful and then do something after that?
I have a profile of member to be displayed. I am using a dataset with all the data table adapter to retrieve the information from database.
I have a memContact method which has NRIC and Number as a composition primary key. Thus, automatically, the table adapter has created a method called FindByICNum () for me. However, when I do the search to display the contents, i will only need to search by memberic instead.
Is there anyway to change the table adapter query?
i have the following code where I want to retreive the data form a table using entity framework and put it to a list of the same type:
List<ItemDetail> iDets = new List<ItemDetail>();
iDets = (List<ItemDetail>) from l in db.ItemDetails
where l.ItemID == varItemID
select l;
when I run the page, it throws the following error:
Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[LIBRIModel.ItemDetail]' to type 'System.Collections.Generic.List`1[LIBRIModel.ItemDetail]'.
why i'm having this problem? or am I missing something here if i'm not wrong it worked once, but now it throws this error
With a single datalist control, I need to retrieve the data from three table..
View 1 RepliesI am using Visual Studio 2005 version, DOTNET Framework 2.0, Technologies C#.NET and ASP.NET and Operating System WindowsXP.In my excel sheet i have two columns of data. Using Gridview i am retrieving data from excel sheet and presenting data. While i am writing RowDeleting event i am getting error primary key not exist.Below code i am using in my program: Default.aspx
View 2 Replies i have dataset with two data tables inside
dt1
dt2
i want to bind data from both data table t gridview
for this how can i make join between two data tables inside dataset and retreive data
how to retieve images which are stored in database one by one and put them in webpage's table.
My project is shopping cart type project in asp.net and server is sql2003
I saved the image urls in database.
when an aspx webpage retrieve data from an sql database into variables can it use the data in the variables for other users or does it has to reretrieve the data from the sql for each user ?
View 1 RepliesI have an asp.net database which has users table. In this table password is saved as sncrypted. Now, I am creating my own users table. I want to copy user's data from my old table t this table. I can to decrypt old users table password. Which encryption technique is used by default in aspnet database for passwords.
View 2 RepliesI have a web page with a GridView and a table outside the gridview to display more information of the record when it is selected (like record details). I'm using data of five tables for this particularly window. I use one table of the five to bind the gridview the other tables are for the details, but I use like 1 or 2 fields of those tables. I'm binding the page with web services. I need some advice on which is the better way for doing this to make a faster web page.
In sql server I made a view with the five tables (all the tables relations are working perfectly). In the web service I call the view; and in the web page I call the web service to bind the page. Everything is working. All I want to do is retrieve from the server all the necessary data only once when the page loads and bind the five tables data (like 18 fields total) in the gridview which I only show 12 fields the other 6 fields are hidden, those 6 are for the details which I get with jQuery (that's another topic). Bind everything only once and manage the data on client side. Everything is working perfectly. Here is my doubt.
How are the maximum table joins I can make? To retrieve the data via web and not get a server time out error. Which is a better way to make a faster page? Make 2 views one for the gridview and one for the details and put each view in a web service; or make one view with all the table joins and one web service. Right now all is working but I have to make other pages that use different tables and joins and I don't know if the server gets me the time out error when the page is fully working.
I have this gridview made.But it gets populated with columns, column names and template fields dynamically. The template field tht I am using throught the field in each colum is a textbox. The user when loads this page sees a gridview with texboxes in all the columns. I need to be able to retrieve the data entered by the user in the textboxes on a button click.
public class GridViewTemplate : ITemplate
{
private DataControlRowType templateType;
private string columnName;
public GridViewTemplate(DataControlRowType type, string colName)
{
templateType = type;
columnName = colName;
public void InstantiateIn(System.Web.UI.Control container)
{
switch (templateType)
[code]...
i need a script on ASP.net that can build this form.
1.Users === Drop Down Menu then in the Drop down should be the names of all Taafoo staff.
What is the easiest way to save form data and retrieve it when the user navigates back to the page?
We have an application process that consists of several web forms. If the user clicks to go back a step we would like to auto-populate the fields. I am assuming there is a common generic way to do this without having to mess with individual controls - what is it?