This is a very basic solution, but it should give you a good starting point.
var commandText = "SELECT * FROM dbo.PackageLog";
var connectionString = ConfigurationManager.ConnectionStrings["localDatabse"].ConnectionString;
DataTable dataTable = new DataTable();
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(commandText, sqlConnection))
{
sqlDataAdapter.Fill(dataTable);
}
}
Console.WriteLine("ID Package Name Start Time End Time Status");
Console.WriteLine("--- --------------- ---------------------- ---------------------- --------");
foreach (DataRow dataRow in dataTable.Rows)
{
Console.WriteLine(
"{0} {1} {2} {3} {4}",
((int)dataRow[0]).ToString().PadRight(3),
((string)dataRow[1]).PadRight(15),
((DateTime)dataRow[2]).ToString().PadRight(22),
(dataRow[3] is DBNull) ? String.Empty.PadRight(22) : ((DateTime)dataRow[3]).ToString().PadRight(22),
(string)dataRow[4]);
}
Console.ReadKey();