MySQL Import ASP.NET C#

Posted on Posted in C#, SQL

ASP.NET C# is a powerful that I have use for a long time. Due the limitation that PHP have on thread programming with background process, therefore PHP need to bring the long processing job the font process before sending the website the browser. In ASP.NET C# I can put the time consuming job the background thread and then update the browser using AJAX integrate with ASP.NET (I know PHP has AJAX, don’t get me wrong with this). But PHP is an interpreter language, while .NET is compiled language.

Why I started programming this code?

After trying to restore a database of mine to the eNom web hosting, their PhpMyAdmin is so bad that i try to restore of 334k i get a CGI error. Also after trying the phpdump.php (i don’t remember where this from), again i get the max_execute_limit = 300 seconds. Dam it, why does eNom MySQL database so slow. GoDaddy didn’t have any issues at all with restoring my database (GoDaddy Windows IIS7 yet has issue with custom php.ini).

Requirements of the web application

·          .NET Framework 2.0

·          ASP.NET AJAX 1.0 Extension

·          MySQL Connector/.NET

Codes of the MySQL Import

·          Default.aspx

·          Default.aspx.cs

·          App_Data the SQL script folder

Default.aspx

Default.aspx.cs

Well I hope this was useful for you, if have any question please leave me a comment.

Thanks