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 requirements. A dataset maintains all schemes in separate tables. Whenever a new scheme is created, the dataset creates a new table but it must be checked that the new table name should not already exist. Which method of the Tables collection should be used to check whether the table already exists?

You defined a data adapter as follows: Dim adap As New SqlDataAdapter('select * from products;select * from customers', New SqlConnection(ConnectionString)) Dim DataSet As New DataSet adap.Fill(DataSet) How will you pass the customers data to a data grid named as 'dGrid'?

How you can you verify whether a dataset has changed?

You have following data table structure: Sales ----------- SalemanId OrderId Price How will you calculate the total amount generated by a salesman (with SalemanID =2201) if the name of DataTable is 'DatTab?'

ADO.NET is known for disconnected data extraction. Which one does not use the disconnected mechanism while extracting data from the database?

The WriteXml method of a DataSet writes the data of the DataSet in an XML file. WriteXml accepts a parameter for the different types of destinations. Which of the following is an invalid type for the destination?