Explain the various steps involved to fill a dataset?

Posted By: Avi

Date: 8 October 2009 03:16:53 AM

Answer:

Step-1:
Open the database connection by creating a Connection object. We can load the connection string from config file.

SqlConnection objConn = New SqlConnection(strConnectionString);
objConn.Open();

Step-2:
Create a command object with appropriate SQL command and set the connection object to this command.

SqlCommand objCommand = New SqlCommand("Select FirstName from Employees");
objCommand.Connection = objConn;

Step-3:
Create the DataAdapter object and pass the command object.

SqlDataAdapter objDataAdapter = New SqlDataAdapter();
objDataAdapter.SelectCommand = objCommand;

Step-4:
Create a DataSet object. Call the "Fill" method of the DataAdapter object and pass the DataSet object. It will load the data into the DataSet object.

DataSet objDataSet = New DataSet();
objDataAdapter.Fill(objDataSet);

Posted By: eTechPlanet

Date: 8 October 2009 03:16:53 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website