Parameters
- tableName
- Name of the table that will be loaded.
public void CreateMyLoader() { // Create and open connection SqlConnection conn = new SqlConnection( "User Id=sa;Server=localhost;Initial Catalog=Test;"); conn.Open(); // Create loader instance SqlLoader loader = new SqlLoader("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 SqlConnection = new SqlConnection( _ "User Id=sa;Server=localhost;Initial Catalog=Test;") conn.Open() ' Create loader instance Dim loader As SqlLoader = new SqlLoader("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
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2