You are creating a Windows Forms application by using the .NET Framework 3.5. You write
a code segment to connect to a Microsoft Access database and populate a DataSet.You need
to ensure that the application meets the following requirements:
It displays all database exceptions.
It logs all other exceptions by using the LogExceptionToFile.
Which code segment should you use?
A.
try
{
categoryDataAdapter.Fill(dsCategory);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, “Exception”);
LogExceptionToFile(ex.Message);
}
B.
try
{
categoryDataAdapter.Fill(dsCategory);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, “Exception”);
}
catch (Exception ex)
{ LogExceptionToFile(ex.Message);
}
C.
try
{
categoryDataAdapter.Fill(dsCategory);
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message, “Exception”);
}
catch (Exception ex)
{ LogExceptionToFile(ex.Message);
}
D.
try
{
categoryDataAdapter.Fill(dsCategory);
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message, “Exception”); LogExceptionToFile(ex.Message);
}
Explanation:
Since you are connecting to Microsoft Access rather than SQL Server, binding must occur through the OleDb interface.