public void OleDbGetFieldUsingCommand()
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.;Extended Properties=dBASE IV;User ID=Admin;Password=;");
OleDbCommand cmd = new OleDbCommand("select * from TEST order by CODIGO", conn);
WorkArea workarea = new WorkArea("TEST", cmd, OleDbFactory.Instance);
workarea.MoveNext();
object result = workarea.GetField("CODIGO");
Assert.AreEqual(1.0, result);
}
public void OleDbGetField()
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.;Extended Properties=dBASE IV;User ID=Admin;Password=;");
WorkArea workarea = new WorkArea("TEST", conn, OleDbFactory.Instance);
workarea.MoveNext();
object result = workarea.GetField("CODIGO");
Assert.IsNotNull(result);
Assert.IsInstanceOfType(result, typeof(double));
}
public void OleDbGetNameFieldUsingCommand()
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.;Extended Properties=dBASE IV;User ID=Admin;Password=;");
OleDbCommand cmd = new OleDbCommand("select * from TEST order by CODIGO", conn);
WorkArea workarea = new WorkArea("TEST", cmd, OleDbFactory.Instance);
workarea.MoveNext();
object result = workarea.GetField("DETALLE");
Assert.IsNotNull(result);
Assert.IsInstanceOfType(result, typeof(string));
Assert.AreEqual(result.ToString().Trim(), "uno");
}