Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

accessing data from aspnet_profile table

Posted on 2010-11-30
12
Medium Priority
?
1,617 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
  • 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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month10 days, 22 hours left to enroll

572 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