473,383 Members | 1,801 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Profile and Data. Please, Need Urgent Help/Advice. Thank You Very Much.

Hello,

I am working on an Asp.Net 2.0 / SQL 2005 web site.
I am using profile to save the users info on the database.

For example, I have the following structure:
Public Structure Name
Public First As String
Public Last As String
End Structure

Then in my Web.config file I have:
<properties>
<add name="Name" type="MyWebSite.Name" />
...

This is working fine for saving personal information for each user where
a user has only one Name.

However each user can also publish documents. Various documents.
Public Structure Document
Public Title As String
Public FileUrl As String
Public Date As DateTime
End Structure

I see 2 options:
1. Traditional
Create the documents database with a foreign key to users table.
Should I connect my foreign key to [UserId] in aspnet_Membership
table?

2. Using Profile
Can I use profile to save and retrieve the documents published by
each user?

Basically, what I need is to:
1. Insert, Edit and Retrieve documents records on my database.
2. Each document as a author.
I might need to retrieve the documents from only one author, from
all authors or any other criteria using an SQL Query or Procedure.

Anyway, I am completly confused about profile in Asp.Net 2.0.
I know I can use it to save user information.
But can I use it to save, for example, multiple records regarding one
subject like published documents.

I have been trying to figure this but I really need some help.

Could someone please help me out?
Any advice, simple code example or link would be great.

Thank You Very Much,
Miguel

Jan 28 '06 #1
0 1337

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: VB Programmer | last post by:
I would appreciate your assistance on this ASP.NET 2.0 site.... This is the wierd problem: While accessing the built in .NET functions for 'profiling' or 'membership' an error is generated (see...
0
by: Miguel Dias Moura | last post by:
Hello, I am saving a complex type in Asp.Net 2.0 profile. I am using an SQL 2005 database as a profile provider. I have been consulting MSDN as help to create my class. (Please, see my code...
6
by: Jeff | last post by:
Hey (and thank you for reading my post) In visual web developer 2005 express edition I've created a simple website project.. At this website I want users who register to be able to upload a...
1
by: Max2006 | last post by:
Hi, Do I need to be worry about WS-Profiling or it already had been taken care in ASP.NET asmx web services platform? Thank you, Max
0
by: yui | last post by:
Hi I am very need an advice for this. I am new to ASP.NET C# / VS2003 here is my sql command SELECT tblStudentCourse.CourseID, tblStudents.StudentID, tblStudents.FirstName,...
9
by: Eric Falsken | last post by:
I've added a number of additional properties to my profile. Sometimes, the values are populated when the user is retrieved from the database, but sometimes the values are empty/default. How can I...
5
by: PhilTheGap | last post by:
Hi there, I'm looking for a way to get and update the "Profile" of a user. As I'm not logged as this user, I cannot use the System.Web.Profile class, and after having a look at MSDN, I don't see...
3
by: Oriane | last post by:
Hi there, I would like to open my Asp.Net project as a "Web Application" rather than as a "Web Site" in Visual Studio. But the thing is that I use the System.Web.Profile and the auto-generated...
5
by: =?Utf-8?B?SmVycnkgQw==?= | last post by:
I have a app that uses several membership/role providers. I can list these Providers with the code: Dim rootWebConfig1 As Configuration rootWebConfig1 =...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.