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