Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Implement web pages using ASP.NET C# in which a database is used. You need to have a login page in order to access to the

Implement web pages using ASP.NET C# in which a database is used. You need to have a login page in order to access to the content.

Note that a constraint on the website is that the users can access it only if they have proper username and password based on the database(Validations are needed).

In the website, the users should be able to add/edit/delete/search the content of the database based on the textboxes they fill. They should also be able to query the database based on the input they enter, there will be a search textbox for this.(note: you must use SQL like insert/update/delete/select)

Refer to the data below:

image text in transcribed

image text in transcribed

image text in transcribed

Name Old Name Description Data Type Allow Nulls Default int varchar(50) varchar(80) decimal(8,2) Price Nm inn 1 CREATE TABLE [dbo]. [Product] ( 2 [Id] INT IDENTITY (1, 1) NOT NULL, 3 [Name] VARCHAR (50) NOT NULL, 4 [Description] VARCHAR (80) NOT NULL, 5 [Price] DECIMAL (8, 2) NOT NULL, PRIMARY KEY CLUSTERED ([ID] ASC) 7 D); Id Price 1 2.99 2 9.99 3 Name Description Bread Baked fresh every day Strawberry Cake Made with organic strawberries Apple Pie Second only to your mom's pie Cheese Very chessy! Beef Fresh from the stock. Chicken From head to feet 5 12.99 12.00 12.00 69.00 6 Name Old Name Description Data Type Allow Nulls Default int varchar(50) varchar(80) decimal(8,2) Price Nm inn 1 CREATE TABLE [dbo]. [Product] ( 2 [Id] INT IDENTITY (1, 1) NOT NULL, 3 [Name] VARCHAR (50) NOT NULL, 4 [Description] VARCHAR (80) NOT NULL, 5 [Price] DECIMAL (8, 2) NOT NULL, PRIMARY KEY CLUSTERED ([ID] ASC) 7 D); Id Price 1 2.99 2 9.99 3 Name Description Bread Baked fresh every day Strawberry Cake Made with organic strawberries Apple Pie Second only to your mom's pie Cheese Very chessy! Beef Fresh from the stock. Chicken From head to feet 5 12.99 12.00 12.00 69.00 6

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learn To Program Databases With Visual Basic 6

Authors: John Smiley

1st Edition

1902745035, 978-1902745039

More Books

Students also viewed these Databases questions