NET Centric Computing20815 marksNumerical: SQL update statementCRUD operations with ADO.NET
Given a table BOOK(ISBN,Name,Author,Price), write a program to update the price of the book to 1000 whose author is John.
Given a table BOOK(ISBN,Name,Author,Price), write a program to update the price of the book to 1000 whose author is John. [5]
The table is BOOK(ISBN, Name, Author, Price) and the requirement is a single row update: every book whose Author is John must end up with Price set to 1000. The database work itself is one SQL statement. BIT351 is a .NET paper, so the program that carries that statement to the server is written i...