Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 6: Write a stored procedure in SQL Server which accepts following values / parameters and inserts data in tbl_Student. Student ID (Auto) First Name

Exercise 6: Write a stored procedure in SQL Server which accepts following values / parameters and inserts data in tbl_Student. Student ID (Auto) First Name Last Name Address Post Code Gender 1. Write code in C# to make use of stored procedure and insert student record in table. Also apply validations on input in order to avoid wrong data entry. Please do not write SQL queries in C#, instead pass data as stored procedure arguments to SQL Server and return success status. 2. Read entered record(s) back into data table using stored procedure and display in data grid on user interface. On each insert grid will be refreshed with newly entered data. 3. Select a row from grid and delete corresponding record in data table. Update grid view after deleting record. Pass arguments to Stored Procedure to accomplish the task, no SQL allowed in C# code. 4. Handle all possible exceptions and display appropriate messages. 5. Apply data validations and use error controls to give feedback to user. Make use of error provider control to display validation errors. 6. Enforce age limit on student (which is from 18 to 25 years, make use of custom enumeration named AgeLimit with two elements Min and Max to represent minimum and maximum allowed age limit).

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

Transactions On Large Scale Data And Knowledge Centered Systems Xxviii Special Issue On Database And Expert Systems Applications Lncs 9940

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Qimin Chen

1st Edition

3662534541, 978-3662534540

More Books

Students also viewed these Databases questions