i have a question , if my transaction have 30 row record to insert into database . do i need to use thread sleep in my function, so that the sql statement will stop execute to give time to sql server time to ready for the next transaction..?
Here sample code :
int i = 0;
while (CountLoop != 0)
{
dbComm = new OdbcCommand(strsql, dbConn);
if (dbConn.State.ToString().ToUpper().Trim() != "OPEN")
{
dbConn.Open();
dbTrans = dbConn.BeginTransaction();
}
dbComm.Parameters.Add(paramNVarchar(idType));
dbComm.Parameters.Add(paramNVarchar(idno));
dbComm.Parameters.Add(paramNVarchar(CupBarCode));
dbComm.Parameters.Add(paramNVarchar(ResultID[i].ToString()));
dbComm.Parameters.Add(paramNVarchar(CollectionResul ...
Go to the complete details ...