Insert data from local MySQL Database to cloud using C# and VB.Net in ASP.Net

Question

how to insert data from local table to cloud table in mysql using aspnet c

dharmendr · Accepted Answer

Hi  anirudhpRefer below codeCprotected void InsertIntoCloudobject sender EventArgs e    DataTable dt  new DataTable     string constr  ConfigurationManagerConnectionStrings34constrLocal34ConnectionString    using MySqlConnection con  new MySqlConnectionconstr            using MySqlCommand cmd  new MySqlCommand34SELECT Name Country FROM Customers34                    using MySqlDataAdapter sda  new MySqlDataAdapter                            cmdConnection  con                sdaSelectCommand  cmd                sdaFilldt                            foreach DataRow dr in dtRows            string constr  ConfigurationManagerConnectionStrings34constrCloud34ConnectionString        using MySqlConnection con  new MySqlConnectionconstr                    using MySqlCommand cmd  new MySqlCommand34INSERT INTO Customers Name Country VALUES Name Country34                            using MySqlDa

dharmendr · Answer

Speed depends on the network and system configurationYou cant do much for thisOr you may check with MySqlBulkLoader classhttpstheonetechnologiescomblogpostmysqlbulkdataimportusingnetconnectormysqlbulkloaderclass

Insert data from local MySQL Database to cloud using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us