1 crore data
looping through it
2.5 crore.
1 lac
in 1 hr
public cmd_obj as new oledb.oledbcommand Strquery="update Table1 set field1='Value from dataset' where field2='value from dataset'" ' where field2 is primary key in base table Public Function Executenonquery(ByVal Strquery As String) As Int32 Dim intUpdated As Int32 = 0 Try If VerifyOracleLogin() = True Then ' check oracle connection cmd_obj.Connection = dbconn cmd_obj.CommandText = Strquery 'strquery has update query intUpdated = cmd_obj.ExecuteNonQuery() return intUpdated End If Catch ex As Exception WriteToErrorLog("Query Execution Error : " & Strquery, ex.Message) Return -1 End Try End Function
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)