Which of the following methods ensures optimum use of Connection Pooling?

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?

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

Which option is ideally suited for managing database connections?

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

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

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?

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?

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?

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

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