public void VerifyData()
{
DataTable dt = mssql.getDataFromTable("Employee");
Object cellValue = dt.Rows[0][0];
Assert.AreEqual(cellValue, 1);
cellValue = dt.Rows[1][1];
Assert.AreEqual(cellValue, "MIKE PEARL");
cellValue = dt.Rows[2][2];
Assert.AreEqual(cellValue, "ACCOUNTANT");
cellValue = dt.Rows[3][3];
Assert.AreEqual(cellValue, "IT");
}
public void gettableData(String tablename, MSSQLConnection ms, OracleSQLConnection os, CUBRIDConnection cs)
{
String data = "";
if (os == null)
{
dt = ms.getDataFromTable(tablename);
}
else
{
dt = os.getDataFromTable(tablename);
}
foreach (DataRow row in dt.Rows)
{
Object[] array = row.ItemArray;
for (int i = 0; i < array.Length; i++)
{
// MessageBox.Show(array[i].GetType()+"");
if ((array[i].GetType() + "").Contains("Date"))
{
data += "to_date(" + "'" + (array[i] + "").Substring(0, 10) + "'" + "," + "'dd.mm.yyyy'" + ")" +
",";
}
else if ((array[i].GetType() + "").Contains("varchar") ||
(array[i].GetType() + "").Contains("String"))
{
String assist = array[i] + "";
if ((array[i] + "").Contains("'"))
{
assist = assist.Replace("'", "''");
}
data += "'" + assist + "'" + ",";
}
else
{
if ((array[i] + "").Equals(""))
{
data += "null,";
}
else
{
if ((array[i] + "").Contains(","))
{
array[i] = (array[i] + "").Replace(",", ".");
}
data += array[i] + ",";
}
}
}
data = data.Substring(0, data.Length - 1);
String insert = "";
if (tablename.Equals("OBJECT"))
{
insert = "Insert into [" + "_" + tablename + "] Values(" + data + ");";
}
else
{
insert = "Insert into [" + tablename + "] Values(" + data + ");";
}
try
{
CUBRIDCommand cmd = new CUBRIDCommand(insert, cs);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e + "");
MessageBox.Show(insert);
}
data = "";
}
//String insert = "Insert into " + tablename + " Values(" + ")";
}
