Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started