Parameters
- tableName
- Name of the table that will be loaded.
public void CreateMyLoader() { // Create and open connection OracleConnection conn = new OracleConnection( "User Id=Scott;Password=tiger;Data Source=Ora;"); conn.Open(); // Create loader instance OracleLoader loader = new OracleLoader("loader_test"); // Set loader properties loader.Connection = conn; // Prepare for loading loader.Open(); // Set row values for (int i = 0; i < 10000; i++) { loader.SetValue(0, i); loader.SetValue(1, "test string"); loader.SetValue(2, DateTime.Now); // Load next table row loader.NextRow(); } // Flush buffer and finish loading loader.Close(); }
Public Sub CreateMyLoader() ' Create and open connection Dim conn As OracleConnection = new OracleConnection( _ "User Id=Scott;Password=tiger;Data Source=Ora;") conn.Open() ' Create loader instance Dim loader As OracleLoader = new OracleLoader("loader_test") ' Set loader properties loader.Connection = conn ' Prepare for loading loader.Open() ' Set row values Dim i As Integer For i = 0 To 10000 loader.SetValue(0, i) loader.SetValue(1, "test string") loader.SetValue(2, DateTime.Now) ' Load next table row loader.NextRow() next ' Flush buffer and finish loading loader.Close() End Sub