.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Website Database Design

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :ASP.Net
 

 Hello,

 

I hope this post is in the right section.

 

I am designing a new application and I am after some advice in regards to designing the database structure. The application is being built in ASP.NET 3.5, SQL SERVER 2005 Express and using the built in membership/profiling tables.

The website will allow a user to login and verify their account with a link in an email they will be sent. I have got this working fine using the createUserWizard control, but I also need them to select the type of membership they want when creating an account and I am a bit stumped at what stage this should be put in.

Do I put this in when creating the user before they verify their account? or do I have it listed when they first login to allow them to change their membership status from a free account to a paying account?

They will have four options list below:

  • free
  • bronze
  • silver
  • gold

The bronze, silver and gold accounts will be a monthly subscription which the user can signup to.

 

The second part to this post is the main bit in how do I design my database for monthly subscriptions? I was thinking something along the lines below.

 

MembershipSubscription Table:

UserID, SubscriptionID, StartDate, EndDate

12345, 1, 10-10-201


View Complete Post


More Related Resource Links

database interface design question

  

For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.


Login database with visual studio 2010 asp website template

  

Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.


creating different sub page design template in sharepoint website

  

I know very little about sharepoint and have outsourced the design of a master page and sub page design for a new website using sharepoint. i received a site master file with all of the necessary images and the home page works just fine. However the file i received for the sub page design template was an ASPX file with the following instructions:

 

Here I enclosed the inner page layout file. You upload this file by using following instructions. you can change & edit the blue menu section in the master page itself. If I change into modifiable section you need to add the menu in each and every page, otherwise it will show as empty block. Please let me know your comments.

 

Steps for uploading inner page layout page.

================================

1.Select the Site Actions button and click on Site Settings->Modify All site settings

Post Website and database online

  

I know this is a simple thing but i  don´t how to.....

I have the website working on my pc .... but i want to get it online with the database.

Do i have to put debug to false to publish it?

thanks in advance for your patience Smile


How to send an email to a website and enter it into the database

  
Is there a way to send an email to a certain email address and have the message inserted into a database?  The subject would be intered into "Subject" table field and the message body would be inserted into the "Message" table field.Thanks.

database design for multiple vendors

  
 I have constructed a simple database schema with one vendor.now i would like to add multiple vendors who can/may provide similar products. so i am looking for a design that lists products,there attributes and can be filtered on respective Product Sizes,Brand,Colour easily.    

VS 2010 could not find database at design time

  
Hi all, I'm having this problem.... Scenario: C# 2010, WPF, SQL Compact 3.5 SP2. I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime. As soon as I open the window with the wpf editor I got the error (translating from Italian): "Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]" Now, in settings and app.config I have the connection string which is something like Data Source=|DataDirectory|\thedbfile.sdf I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok. Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error.... thanks

what is the better design for location of system database data / log files and user data/log file,

  
is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

Can I have an SQL Express database open in VS2010E along with the website? "Login failed for user ..

  
Hi, as the topic says..Whenever I have my database open in Visual Studio 2010 Express, I get this error:Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.

Need Suggestion for Database Design ...

  
Hi folk..i want suggestion to design my database tablesi have senario likehere i have a job which will start and then completeso i have fields like StartTime, CompleteTime to store both timestamp...now i need to find the time consumed in this process [(CompleteTime - StartTime) Hrs:min:Sec]so i have two optionshave a field in database Table which will calculate the ConsumedTime for each recordwhen i need to display the consumedtime, i will calculate the differencee.from above which is better.??Assumptions :The table will have a large number of recordsThanks

Database design for treeview and content

  
HiI"m student and need help to design a database for treeview and some content.I need a database design with treeview and it's childnodes,  different content for each node, and modules for each page, like search, contact form and etc... with ability to turn it on and off.Maybe you can show me the way or maybe you have some good links for database design. Any help would be appreciated.THANKS

Ajax enabled website and MSAcess Database

  
Hi i have problem while connecting to my MSAccess  Database in App_Data Folder in Ajax enabled website. How to bind Gridview with MsAcess Databse in Ajax enabled website???? Can u please help me , i m new to Ajax and Asp.net.   Thanks in Advance    

Database Design

  

hi....

I am creating a very high level relational database diagram for attendance and payroll system.

 

so far I have taken these table into account .

Employee

Attendance

Leave

Department

Company

Payslip

....I am confuse in salary process how to store details related to that...and with which tables it would have relations.Here I want salary process to be done and also payslip has to be generated.

 

Thanks In Advance. 

 


Dental Database Design Help

  

Currently i doing dental appointment website for my lessons, and i having problem in database design. The major of the database is for appointment booking and view information.

The flow

Admin doing the registration for patient, admin, dentist.

Patient login > view dentist > view appointment > make appointment   or view treatment comment

Dentist login > insert patient treatment comment   /   view appointment

Admin > view appointment > Delete appointment and others stuff like report


While creating the dental user table, should i include the dentist into dental user table?Should i create 1 more table for registration ?

I having problem in linking all the table ..Kindly if you could help me in giving suggestion / ideas. Thank you.


Dentist Table

Dentist ID (Primary Key)

Dentist Name

Dentist Specialize

Dentist Contact Number

Dentist Email

Dentist Job Description

 

Appointment Table

Appointment ID (Primary Key)

Dentist ID (Foregin Key)

Appointment Time

Appointment Date


Dental User Table

Username

Password

Name

Identification Card Numner

Contact

VS 2010 could not find database at design time

  

Hi all, I'm having this problem....
Scenario: C# 2010, WPF, SQL Compact 3.5 SP2.

I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime.

As soon as I open the window with the wpf editor I got the error (translating from Italian):

"Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]"

Now, in settings and app.config I have the connection string which is something like

Data Source=|DataDirectory|\thedbfile.sdf

I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok.

Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error....

thanks


how to download Database in sql from Website Control panel ?

  

Dear Professionals.....


My control pannel doesn't has any option to download database so i want to download database from control panel. is there any way to download it ? any software,?


i'm a new user so please explained answer will be apperciated.


Regards,

Sagheer


Cannot determine how to set owner to install database design

  
My compatibility settings are fine. Anyone know how to to this?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend