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"); }