Explain the purpose of a dataset and describe how to create a dataset called dsEmployee in Visual Studio 2012. Assume you have the following function in the clsDataLayer class. Write the SQL command to select all rows from the tblEmployee table, and write the code to fill the dataset.
public static dsEmployee GetEmployee(string Database)
{
dsEmployee DS;
OleDbConnection sqlConn;
OleDbDataAdapter sqlDA;
sqlConn = new OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + Database);
// Write the code here to select all rows from the tblEmployee table
_______________________________________________________
DS = new dsEmployee();
// Write the code here to populate the dataset
________________________________________________________
return DS;
}