What are the methods provided by the dataset for XML?

The important methods of a DataSet class for XML are :
1. GetXml Method
2. GetXmlSchema Method
3. InferXmlSchema Method
4. WriteXml Method
5. WriteXmlSchema Method
6. ReadXml Method
7. ReadXmlSchema Method

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Which is the best place to store connectionstring ?

App.config - Windows Project
Web.config - Web project

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How can we force the connection object to close?

There are 2 ways you can do this:
1. using the ExecuteReader method with "CommandBehavior.CloseConnection" parameter
2. Putting the Connection object with Using statement

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the two fundamental objects in ADO.NET ?

1. DataReader ( connected mode )
2. DataSet ( disconnected mode )

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning