Devart Forums

Code: Select all

    using (MySqlConnection conn = new MySqlConnection()) {
        conn.ConnectionString = "server=***;port=3308;uid=***;pwd=***;database=test;";
        conn.Open();

        MySqlCommand cmd = conn.CreateCommand();
        cmd.CommandText = "CREATE TEMPORARY TABLE my_temp_table (" +
                            "  column1 VARCHAR(50) NOT NULL" +
                            ")";
        cmd.ExecuteNonQuery();

        MySqlLoader loader = new MySqlLoader();
        // Specify connection that MySqlLoader will use for loading
        loader.Connection = conn;
        // Set table name that will be loaded into
        loader.TableName = "my_temp_table";
        // Populate Columns collection from table description
        loader.CreateColumns();
        // Prepare MySqlLoader for loading
        loader.Open();
        for (int i = 0; i < 10; i++) {
            loader.SetValue("column1", i);
            loader.NextRow();
        }
        // Flush buffer and dispose internal MySqlLoader structures
        loader.Close();

        cmd.CommandText = "select * from my_temp_table";
        MySqlDataReader reader = cmd.ExecuteReader();
        while (reader.Read()) {
            Console.WriteLine(reader[0]);
        }
        Console.ReadKey();
    }