?
Solved

accessing data from aspnet_profile table

Posted on 2010-11-30
12
Medium Priority
?
1,559 Views
Last Modified: 2012-06-27
Hello guys,

I am new to aspnet membership table and I am have created a module which actually uses aspnet_membership table to store all the user related information. In this case it stores all the user related information in  a particular way. I  am not sure of a straight forward way to read data out of this table.

How do I read data from aspnet_profile table? Is there any C# function call that I have to use to fetch this functionality?
0
Comment
Question by:TheCommunicator
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
12 Comments
 
LVL 9

Accepted Solution

by:
Seven price earned 1600 total points
ID: 34241959

use a function and bind it to a table. But you should write a ms-sql storedprocedure syntax to putll the information you want for example.

(ASP.NET 2.0) For example I'm looking for all users WHERE the "UserRace" profile value is 'Caucasian'. Thanks.
0
 
LVL 32

Assisted Solution

by:Erick37
Erick37 earned 400 total points
ID: 34242029
SearchableSqlProfileProvider - The Searchable SQL Profile Provider
http://www.codeproject.com/KB/aspnet/SearchableProfileProvider.aspx
0
 

Author Comment

by:TheCommunicator
ID: 34242329
Well, this is fine as far as merely accessing and seeing data is  concerned but I want to use this data for many purposes like data manipulation, data reporting and all that. i want my self to be able to write SQL queries on top of this data. How can I do that?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 9

Assisted Solution

by:Seven price
Seven price earned 1600 total points
ID: 34242372
>>write SQL queries on top of this data
Are you asking how to write a query or stored procedure?
0
 

Author Comment

by:TheCommunicator
ID: 34242388
No. My ultibale goal is to transport this data stored on aspnet table to XMl and since this table does nto store data in regular format and stores all the user information in single field. I was wondering how can I use this data as normal data? Is there any way that I can use this data for many other purposes like reporting and everything?
0
 

Author Comment

by:TheCommunicator
ID: 34242403
ultimate**
0
 
LVL 9

Assisted Solution

by:Seven price
Seven price earned 1600 total points
ID: 34242405
You can use the data for what ever you want. You can use it to write to xml, create reporting or crystal report. It all depends on the function you are creating and the stored procedure.
0
 

Author Comment

by:TheCommunicator
ID: 34242629
I know but normal the tables contain data in different fields but in this case, everything goes in the single table which is pretty unusual design. What if I want to make Joins and do reporting on this. Even though I achieve a functionality to read from it, it would be affecting the performance badly and would not be a good programming practice anyways.
0
 

Author Comment

by:TheCommunicator
ID: 34242855
I am sorry, when I said that everythingoes in single table I actually meant everything goes in single field
0
 
LVL 9

Assisted Solution

by:Seven price
Seven price earned 1600 total points
ID: 34243242
If you want to join them into a single field then you should use a COALESCE
0
 

Author Comment

by:TheCommunicator
ID: 34244200
Noooooo. in asp_profile table, they are already joined in a single field. i am seeking a way to saperate them into different columns that they look like a normal table.
0
 

Author Comment

by:TheCommunicator
ID: 34296712
Thank you so much information was helpful.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question