public void TestMethod_ConnectDB()
{
MsAccessDatabase obj = new MsAccessDatabase();
bool value = obj.ConnectDb(ConnString, out errOut);
obj.Close(out errOut);
General.HasTrueValue(value, errOut);
}
public void TestMethod_ConnExec()
{
string SQL = "INSERT INTO Gun_Cal(Cal) VALUES('TEST');";
MsAccessDatabase obj = new MsAccessDatabase();
bool value = obj.ConnExec(ConnString, SQL, out errOut);
General.HasTrueValue(value, errOut);
}
public void TestMethod_GetData()
{
String SQL = "Select * from Gun_Cal";
MsAccessDatabase obj = new MsAccessDatabase();
DataTable table = obj.GetData(ConnString, SQL, out errOut);
string TestValue = @"";
foreach (DataRow row in table.Rows)
{
TestValue += String.Format("{0}{1}", row["Cal"].ToString(), Environment.NewLine);
}
General.HasValue(TestValue, errOut);
}
public void TestMethod_ConnectionOLEStringWithOutPassword()
{
string value = MsAccessDatabase.ConnectionStringOle(Settings.AccessDatabase.DatabasePath, Settings.AccessDatabase.DatabaseName, out errOut);
General.HasValue(value, errOut);
}
