Steps involved to fill a DataSet

Question

What are steps involved to fill a DataSet.

Dorababu Meka · 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);