We are iterating through the results received in a data reader named "DReaderOrder," which is created by using connection "SqlCon." In between, we need to retrieve some more values from the database, so we executed another command using "SqlCon," to get the results in another data reader "DReaderProduct." What will happen if we use ADO.NET 1.1?

Which one is not a valid member of DataAdapter?

You must create a stored procedure to retrieve the following details for the given customer: CustomerName, Address, PhoneNumber Which one is an ideal choice to get the result?

A stored procedure called 'FirstQTR' is used for generating the sales report of the first quarter. Apart from other data, it returns the total sale seperately to make a hyperlink. For this purpose you pass a parameter, TotalSale. Which statement suits for the parameter TotalSale?

We are iterating through the results received in a data reader named 'DReaderOrder,' which is created by using the connection 'SqlCon.' In between we need to retrieve some more values from the database, so we executed another command in the same connection to get the results in a new data reader named 'DReaderProduct.' What will be the result if we are using ADO.NET 2.0? (Note:Multiple Active Result Sets (MARS) is enabled in SQL Server 2005).

Which one is not true about CommandType.TableDirect?

Which one implements IDataReader interface?

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

You have defined an SQL Command object named ''sqlComm'' to run a stored procedure. The OUT parameter is as follows: Dim pm2 As New SqlParameter(''@Amount,'' SqlDbType.Money) How will you add the OUT parameter named pm2 to the command object?

Which command types are provided by an oledb and sql provider?

Which options should you use to copy the edited rows from a dataset called ProductInfo into another dataset called Product Changes?