Place your most r complete and accurate response to the following questions on t
ID: 3831534 • Letter: P
Question
Place your most r complete and accurate response to the following questions on the provided paper needed! Your exam will not be graded unless You turn in this paper with your responses write a procedure of your own design that uses parameterized sQL INSERT statement that takes values from controls a table on a webpage and uses them to insert a new row of data into a SQL Server table that is already made. Create and set parameters and use try catch block. The SQL Server database table you are inserting a row of data into has 6 columns. The value for the first column comes from an auto-increment primary key field. You just need to get the values for the other 5 columns with different datatypes. The values come from different control types a dropdownlist, a textbox with numbers typed in, a calendar, a checkbox, and a radiobuttonlist. Again, you do not have to worry about the primary key field (which is an integer)it is auto- incrementing. Imagine one row of data has been retrieved onto screen for update. Write a procedure that can update one row of data that was retrieved onto screen. You have the values in the 5 controls on your screen, so write an update procedure that pushes these values (some may be edited) back database table. Use parameters, and a try catch block. The data you need to update is in 5 columns with different datatypes so the values come from different control types-a dropdownlist textbox with numbers typed a calendar, and a radiobuttonlist Don't forget about the primary key and to update only one row of data. (Conceptual) What did use SQL Data to accomplish? For which type of SQL statements are data adapters the best vehicle to run? What other two ADO.NET objects data adapter work closely with? (Conceptual) Describe the usage and importance of primary, foreign keys, and auto- the primary key in database design (Conceptual) Describe the ADO.NET datatable, what it is, in which scenarios we used what we used to accomplish, and what other controls and objects work with it. just conceptualExplanation / Answer
Following is possible solution to the Question 1.
==========================================
PROCEDURE INSERT_INTO_TABLE(
p_dropdown IN VARCHAR2,
p_textbox IN NUMBER,
p_calender IN DATE,
p_checkbox IN VARCHAR2,
p_radiobutton IN NUMBER
)
IS
l_module_name constant VARCHAR2(100) := 'INSERT_INTO_TABLE';
BEGIN
INSERT INTO TABLE_NAME
(
Column1,
Column2,
Column3,
Column4
)
VALUES(p_dropdown,p_textbox,p_calender,p_checkbox,p_radiobutton);
END INSERT_INTO_TABLE;
================================================================
Here I have used generic keywords that can be easily modified acording to the need.
1. TABLE_NAME : Name of the table where the values need to be inserted.
2. Column1, Column2, Column3, Column4: Names of the column in the table.
Thanks.