//01. Demo: Introduction to ADO.NET
public static void TestConnection()
{
Console.Clear();
DataAccessLayerADO dal = new DataAccessLayerADO();
if (dal.TestConnection())
{
Console.WriteLine("\n\n Connection successful \n");
}
else
{
Console.WriteLine("\n\n Some error occured \n");
}
}
public static void ReadDatafromDB()
{
DataAccessLayerADO dal = new DataAccessLayerADO();
if (dal.TestConnection())
{
string data1 = dal.ReadDataPerson1();
string data2 = dal.ReadDataPerson();
string data = dal.ReadDataRoles();
Console.WriteLine("\n\n" + data + " \n");
}
else
{
Console.WriteLine("\n\n Some error occured \n");
}
}