public static void TestSelect(string cnx)
{
string sql = "select FIELD_1,FIELD_2,FIELD_3 from SAMPLE_TABLE";
try
{
using (FBAdoDBHelper dbHelper = new FBAdoDBHelper(cnx))
{
DataTable table = dbHelper.GetTable(sql);
foreach (DataRow r in table.Rows)
{
Console.WriteLine(String.Format("1: {0} / 2: {1} / 3: {2:dd/MM/yyyy HH:mm}",
r.getValue <int>("FIELD_1"),
r.getValue <string>("FIELD_2"),
r.getValue <DateTime>("FIELD_3")));
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.Message);
}
}
