Welcome to KwunHo.com

string zConnectionStringL = “Database=TestDataBase;UserID=Admin;Password=Admin;Server=11.111.112.8″;
DB2Connection aDB2ConnectionL = new DB2Connection();
aDB2ConnectionL.ConnectionString = zConnectionStringL;
DB2Command aCommandL = new DB2Command();
DB2Transaction aTransL;
try
{
aDB2ConnectionL.Open();
aTransL = aDB2ConnectionL.BeginTransaction();
}
catch
{
return false;
}
try
{
string zQueryStringL = “”;
foreach (Data TheDataL in zDataP)
{
zQueryStringL = zQueryStringL + ” Insert into Emp(Name,Salary,EmpNo) values (‘Nathan’,’50000′,’1001′); “;
}
aCommandL = new DB2Command(zQueryStringL, aDB2ConnectionL);
aCommandL.Transaction = aTransL;
aCommandL.ExecuteNonQuery();

aTransL.Commit();
aDB2ConnectionL.Close();
return true;
}
catch
{
aTransL.Rollback();
return false;
}
finally
{
aDB2ConnectionL.Close();
}
}