1)

Which of the following statements executes a LINQ query, called searchByName, and displays the query result using the StudentsBindingSource object (which was generated by a Drag-N-Drop process)? One essential statement is missing from the following untyped DataSet application. The DataSet is supposed to cache all supplier records in a DataTable object. Which of the following is the missing statement? Dim northwindConnection As String "Provider- Microsoft Ace.OleDb.12.0 data source-cnorthwind.accdb" Dim SqlStatement As String "Select from Suppliers" Dim northwindDataAdapter As New OleDbDataAdaptertSqlStatement, northwindConnection) Dim northwindDataSet As New DataSet northwindDataAdapter.UpdatelnorthwindDataSet. "suppliers Dim supplierDataReader as new OleDbDataReader northwindDataAdapter.FilknorthwindDataSet, "suppliers One essential statement is missing from the following DataReader application. Which of the following is the missing statement? Dim northwindConnection As new OleDbConnection Provider Microsoft Ace.OleDb.12.0:data source cinorthwind.accdb") northwindConnection Open) Dim northwindCommand As New OleDbCommando northwindCommand.CommandText "Select From Suppliers northwindCommand.ExecuteReader) Dim suppliersDataReader as OleDbDataReader Do While suppliersDataReader Read TextBox1. Text- suppliersDataReaders.GetStringlO Loop suppliersDataReader.close) O northwindConnection Close northwindCommand Connection northwindConnection