Unit 2 Practical 9

Create four tables as given: Customer (CustomerCode, Name, Address) Product (ProductCode, ProductName, Price, Qty) SalesMaster (InvoiceNumber, CustomerCode, DateofInvoice) SalesDetails (InvoiceNumber, ProductCode, Qty, UnitPrice) Design a webpage to generate Invoice details in which Customer name, Product name, and Line total (Unit price * Quantity) is shown using GridView.

U2_P9.aspx

Now you have to create view for access different values from different Tables from the database as below..

view1

OUTPUT