Ticket Status Updates - OMIS 675
Edit the FormView to allow an analyst to update and close a help desk ticket - 10 points – Due by end of class 3/5. Google Doc version
- Create a new table in your DB, called STATUS, with one column named ‘Status’. Data Type has to be nchar(15). Add two values in this table OPEN and CLOSED
Modify your existing Incident table
- In your existing incident table, add a column called NOTES. Make this a data type nvarchar(MAX) , It should allow Null values.
Modify your existing Tickets form
- Open your Tickets.aspx form in Visual Studio
- Delete the existing FormView, and the SQLDataSource that went with it.
- Add another FormView in the same place
- Configure the FormView to point to your Incident table and display all records
- Ensure sure that the INSERT, UPDATE, and DELETE statements will be generated. (Hint: ‘Advanced’ button )
- Re-Add the logic you created in lab 5 to ensure the FormView displays the selected record of the record selected in the Gridview (Hint: WHERE button)
- Go into the ‘Edit Template’ menu of your FormView, select the ‘EditItemTemplate’ display option