Parameters
- tableName
- Name of the table that will be loaded.
public void CreateMyLoader() { // Create and open connection SugarConnection conn = new SugarConnection( "server=https://your_company.sugaropencloud.eu;user id=admin;password=AmFFA4ZryM;"); conn.Open(); // Create loader instance SugarLoader loader = new SugarLoader("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 SugarConnection = new SugarConnection( _ "server=https://your_company.sugaropencloud.eu;user id=admin;password=AmFFA4ZryM;") conn.Open() ' Create loader instance Dim loader As SugarLoader = new SugarLoader("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
SugarLoader Class
SugarLoader Members
Overload List
Devart.Data.Sugar.SugarLoaderColumn
Devart.Data.Sugar.SugarLoaderColumnCollection