Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

These are the instructions for the lab, I am out of town and can't complete it. Can anyone help? Thank you! Lab 4 In this

image text in transcribed

These are the instructions for the lab, I am out of town and can't complete it. Can anyone help? Thank you!

Lab 4 In this lab assignment,yau will do the fallowing: . Create a SQL Server Express Database with two tables Adld records to Tables in a database . Use GrldVlew Data Controls to dlsplay table rocords Validate user input bfoequerying a database . Use SqlDataSourco deslan wizard to loln two tables divider line Create a SQL Server Express Database with two tables 1. Start up Server Explorer to create new databas" file l ab3.mdf 2.Aud two tables to your database: Suppliers arid Iriventory 3.Add the columns to Suppliers and Inventary as showr: suppliers table iriventory table o Let Supplicrld be the primary loey of type int for the Supplicrstable and set its Identity Specification Is Identitylto Yes (increment by 1 o LetInventoryld be the primary key ot type Int tor the Inventory table and set ts Identlty Specihcation (Is Identity) to Yes (Increment by 1) Note: by using the same column name Supplierld, Visual Studio's toels are smart enough to realize that Supplierld is a foreign key in Inventory. divider line Add records to Tables in a database Add the records to the Supplers table tor three suppliers and to the Inventory table tor ve htenns Inlnventory: invrntary tablr filled suppllers table illed divider line Use GridView Data Controls to display table records Add the l ITML, GridView, and SqlDatasuurccunL' uls lo you' Default.aspx pege lu Display all the suppliers - Display the entire Inventory Alkww the user to entera quantity,clirkthGet Reorder List' button, and display all items at ar bekw the quantity entered divider line Validate user input before querying a database Add validation controls to the 'Get Reorder List" button to guard against the use' enterinillegal quantities. Edit the GriView's EmptyDataTeplateso that if there are no iterns that need to he re-ordered (hasedd on quantityl.yur GridView shauld display No its rieed to be rc ordered. divider line Use SqlDataSource design wizard to join two tables Atici an 'mpo ved reorder ist Grid iew to y ur efault.aspx pege that dis la s ust the product rarne, supplier name, and quantity or items that need to ber ordered. Note: The SqlDataSource design wizard's Query Builder can be used to help write SQL statements that pertorm a join on multiple tables in a database. Add a new 5qIDsta5our ce control to your DefaulLaspx page Conture the SqlDataSource to o Use the same lab3 conrnection string (saie databasel as before, click Next a Specity a custom SQL statement, click Next Click the Query Builder button Add both the Inwentory and Suppllers tables to the Query bullder, click Close Click an the Calumns in the datahanc tableynuwd losclected ProductNamr SupplirrName, Cuantity). On Quantity Column Hllter, type inquantity where @quantity is a parameterto the query Notryou cancherk ynur selet qurry by clirking Fxcaute CeI should promat ynu for thr @quantity paramrter. o Click Next, Click Next to et to ehne Paramaters Idrntify wur quantity text box cnntrl as the parameter snurer,set thr defult valur to * Add nother h3 header and Gridlew to your Detaut.aspx page to hold your Improved reorder list

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

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

More Books

Students also viewed these Databases questions

Question

Psychological, financial, and career counseling.

Answered: 1 week ago