title: Bulk Update using query - C# and ORacle
body: <p>I am working in C#.Net and Oracle, Windows Application. In my dataset i am having around 1500 records. Using for loop, i need to update those records into database. The loop is executing correctly. For the first time, the first record got updated. whenever the loop goes for second row, nothing happens. I am not getting any error.</p>
  
  <p>Here is my update code</p>
  
  <pre><code>log.Debug("Update Starts..");
              OracleTransaction oraTransaction = BeginTransaction();
              string Zip = string.Empty;
              StringBuilder updateSql = new StringBuilder();
              updateSql.Append("UPDATE STORE SET ");
              updateSql.Append(" LAT = ").Append("'").Append(Latitude).Append("'");
              updateSql.Append(" ,LONG = ").Append("'").Append(Longitude).Append("'");
              updateSql.Append(" ,LOCATION_TYPE = ").Append("'").Append(locationType).Append("'");
              updateSql.Append(" ,UPDATE_TIMESTAMP = ").Append("'").Append(PopulatedDate).Append("'");
              updateSql.Append(" WHERE ");
              updateSql.Append(" STR_ID = ").Append("'").Append(StoreID).Append("'");
              int result =  OracleHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, updateSql.ToString());
              CommitTransaction(oraTransaction);
              EndTransaction(oraTransaction);
              CloseConnection(oracleConnection);
              log.Debug("Update Ends.." + result);
              return 1;
  </code></pre>