public void ExecuteSql2DataSetTestNoData() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); string sql = "select * from users where userid=''"; System.Data.OleDb.OleDbParameter[] parameters = null; int startIndex = 0; int length = 5; string srcTable = string.Empty; System.Data.DataSet actual; actual = target.ExecuteSql2DataSet(sql, parameters, startIndex, length, srcTable); Assert.AreEqual(0, actual.Tables[0].Rows.Count); }
public void ExecuteSql2DataSetTestOneRecord() { DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); string sql = "select * from users where userid=@userid"; System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter() { ParameterName = "userid", Value = "Payne" } }; int startIndex = 0; int length = 0; string srcTable = string.Empty; System.Data.DataSet actual; actual = target.ExecuteSql2DataSet(sql, parameters, startIndex, length, srcTable); Assert.AreEqual(1, actual.Tables[0].Rows.Count); Assert.AreEqual("Payne", actual.Tables[0].Rows[0]["UserID"].ToString()); Assert.AreEqual("Payne Kang", actual.Tables[0].Rows[0]["Name"].ToString()); }