In .Net application, you have to update 40 records together in the update query. Previous versions of ADO.NET would be making 40 calls to database. Which of the following parameters is set to 40 with version 2.0?

Read the following statement: DataTable.Merge (DataTable, Boolean) What is the boolean parameter?

You have to update some values in the database. Which method would you execute on a command object named ''cmdUpdate?''

You have a table named 'FirstQTR' and want to create another table 'SecondQTR' which is exactly the same as 'FirstQTR', including DataTable schema and constraints. Which of the following methods fulfills the requirement?

Premium Finance Corp is involved in the savings business with branches all over the country. They provide flexible schemes which can be designed according the client's requirements. A dataset maintains all schemes in separate tables. You want to show all the schemes in different datagrids which should be created in the same sequence as the tables are in dataset. Which one is the most suitable method in the current scenario?

Premium Corporation is running an insurance business. They are planning to create a website to automate the business. An aspx page, Sales.aspx will display the sales generated by an executive. The sales will be displayed in a datagrid. The executives can change some fields like the address or phone numbers of clients, and they can add new sales also. Which of the following will you prefer to use for this?

Which are used for database connections between SQL Server and ASP.NET?

Which one is not associated with the command object in ADO.NET 2.0?

Which option is ideally suited for managing database connections?

Read the following statements: DataRow oDetailsRow = oDS.Tables[''OrderDetails''].Row(); oDetailsRow[''ProductId''] = 1; oDetailsRow[''ProductName''] = ''Product 1''; What is wrong in this code?

Read the following statements: Dim dr As DataRow Dim objCustReader As Data.SqlClient.SqlDataReader Dim dtCustomers As DataTable With dtCustomers.Columns.Add(New DataColumn(''Customer ID'')) End With What is wrong in above code?