You are developing a website that has four layers. The layers are: user interface (web pages), business objects, data objects, and the database. You want to pass data from the database to controls on a web form. What should you do?

Read the following statement: DataTable.Select (String, String) Here, the first parameter accepts a criteria for filtration, what does the second parameter do?

Which method 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?

You have got a supplier data table named ''DTSupp.'' To display records specifically with sorting, you employed a dataview as follows: Dim DataViewSupp As DataView = DTSupp.DefaultView What is the 'DataViewSupp' table view by default?

Which one is not correct with regard to DataReader and DataSet?

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?