Microsoft
70-516 · Question #82
70-516 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 70-516 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Question
You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 200B database. You populate a SqlDataAdapter by using the following code. (Line numbers are included for reference only.) 01 SqlDataAdapter dataAdapter1 = new SqlDataAdapter("SELECT * FROM [BlogEntries] ORDER BY CreationDate", connection); 02 cmdBuilder = new SqlCommandBuilder(dataAdapter1); 03 dataAdapter1.Fill(BlogEntryDataSet, "BlogEntries"); 04 .... 05 connection.Close(); You need to update the blog owner for all BlogEntry records. Which code segment should you insert at line 04?
Options
- Aforeach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows)
- Bforeach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows)
- CSqlDataAdapter dataAdapter2 = new SqlDataAdapter(
- DSqlDataAdapter dataAdapter2 = new SqlDataAdapter
Unlock 70-516 to see the answer
You've previewed enough free 70-516 questions. Unlock 70-516 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.