asked on
try
{
simTmp[i] = expAgg + sExp[i];
StringBuilder insertSQL = new StringBuilder(@"INSERT INTO " + tabnm + " (");
insertSQL.Append(" [SimNum], ");
insertSQL.Append(" [Leg0_MTM], ");
insertSQL.Append(" [Leg1_MTM], ");
insertSQL.Append(" [SetExp], ");
insertSQL.Append(" [CPTY], ");
insertSQL.Append(" [KAES_ENTITY], ");
insertSQL.Append(" [RPT_LEVEL_1], ");
insertSQL.Append(" [RPT_LEVEL_2], ");
insertSQL.Append(" [RPT_LEVEL_3]) ");
insertSQL.Append(" VALUES (");
insertSQL.Append(i + 1).Append(",");
insertSQL.Append(leg0exp).Append(",");
insertSQL.Append(leg1exp).Append(",");
insertSQL.Append(sExp[i]).Append(",");
insertSQL.Append(cpty).Append(",");
insertSQL.Append(KAESEnt).Append(",");
insertSQL.Append(RL1).Append(",");
insertSQL.Append(RL2).Append(",");
insertSQL.Append(RL3).Append(")");
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter oledbAdapter = new OleDbDataAdapter();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = insertSQL.ToString();
insSql = insertSQL.ToString();
oledbAdapter.InsertCommand = new OleDbCommand(insSql, connect);
oledbAdapter.InsertCommand.ExecuteNonQuery();
//cmd.ExecuteNonQuery();
}
catch (Exception e)
{
string exc = e.ToString();
}
}
connect.Close();