You develop an inventory management application called XYZManagement that will call aÂ Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter.Â This total will be displayed to users in a message box._x005F_x000D_
Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write thefollowing code to call sp_GetDailyXYZSales:SqlConnection cnn = new SqlConnection(myConnString);SqlCommand cmd = new SqlCommand(â€œsp_GetDaily XYZ Salesâ€, cnn);cmd.CommandType = CommandType.StoredProcedure;SqlParameter prm = cmd.Parameters.Add(â€œ@ItemTotalâ€,SqlDbType.Int);prm.Direction = ParameterDirection.Output;cnn.Open();cmd.ExecuteNonQuery();_x005F_x000D_
Now you must write additional code to access the output parameter. Which code segment should you use?

Question

You develop an inventory management application called XYZManagement that will call aÂ Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter.Â This total will be displayed to users in a message box._x005F_x000D_
Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write thefollowing code to call sp_GetDailyXYZSales:SqlConnection cnn = new SqlConnection(myConnString);SqlCommand cmd = new SqlCommand(â€œsp_GetDaily XYZ Salesâ€, cnn);cmd.CommandType = CommandType.StoredProcedure;SqlParameter prm = cmd.Parameters.Add(â€œ@ItemTotalâ€,SqlDbType.Int);prm.Direction = ParameterDirection.Output;cnn.Open();cmd.ExecuteNonQuery();_x005F_x000D_
Now you must write additional code to access the output parameter. Which code segment should you use?

TuteeHUB · Accepted Answer

MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?

TuteeHUB · Answer

MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].Value.ToString());

TuteeHUB · Answer

MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].ToString());

1.	You develop an inventory management application called XYZManagement that will call aÂ Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter.Â This total will be displayed to users in a message box._x005F_x000D_ Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write thefollowing code to call sp_GetDailyXYZSales:SqlConnection cnn = new SqlConnection(myConnString);SqlCommand cmd = new SqlCommand(â€œsp_GetDaily XYZ Salesâ€, cnn);cmd.CommandType = CommandType.StoredProcedure;SqlParameter prm = cmd.Parameters.Add(â€œ@ItemTotalâ€,SqlDbType.Int);prm.Direction = ParameterDirection.Output;cnn.Open();cmd.ExecuteNonQuery();_x005F_x000D_ Now you must write additional code to access the output parameter. Which code segment should you use?
A.	MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].Value.ToString());
B.	MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].ToString());
C.	MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
D.	MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
Answer» D. MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?

Discussion

No Comment Found

Related MCQs

Reply to Comment