70-316 Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET Training Boot Camp

Microsoft ™

70-316 Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET

Note 1: 70-316 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-316 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 8.

You are contracted to develop a Customer Relationship Management system for CKWare Inc. You have created a stored procedure named sp_GetYTDRevenues that returns the Year to Date revenue as an output parameter. This total must be produced in a string. You write the following code to call sp_GetYTDRevenues: cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm = cmd.Parameters.Add( __ "@YTDRev", SqlDbType.Int); parm.Direction =ParameterDirection.Output; cnn.Open(); cmd.ExecuteNonQuery(); Now you must write additional code to access the output parameter. Which code segment should you use?

A. strResult = "Total is: " & _ cmd.Parameters("@Output").Value.ToString();
B. strResult = "Total is: " & _ cmd.Parameters("@Output").ToString();
C. strResult = "Total is: " & _ cmd.Parameters("@YTDRev").ToString();
D. strResult = "Total is: " & _ cmd.Parameters("@YTDRev").Value.ToString();

Display Answer

Purchase Full Version:

70-316 Printable PDF Prep Guide $49.95 BUY NOW!

70-316 Test Simulation Engine $69.95 BUY NOW!

70-316 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: D The @YTDRev parameter is declared as an output parameter with SQL Server data type INT. We use the Value property of the SQLParameter class to retrieve the value of this parameter. We must also convert the INT value to a string value with the ToString method. We then supply this string to the MessageBox.Show method.

Explanation: