SqlLoader Constructor(String)
Initializes a new instance of the
SqlLoader class with table name that will be loaded.
The following example creates a
SqlLoader and sets some of its properties. Then prepares data and loads it into the table.
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