How to create Insert script using c#

Question

From my c# code behind, i pass a query to mysql database and get the data in a DataTable. Now i want to use the data in data table to write the Insert query in a script file [.sql]

The objective of doing so is, whatever records i select from mysql, i should write that to a script file as backup. Thais why i need the insert statements.

How ? Or any other idea is appreciated.

Answer 1

If I understand you correctly, you're doing something like this

string sql = "INSERT sometable (a, b, c) SELECT 1, 2, 3";
DataLayer.Run( sql );

and you want to do something like this

System.IO.File.WriteAllText( "script.sql", sql );

Or, to log multiple statements,

System.IO.File.AppendAllText( "script.sql", sql + Environment.NewLine );

Answer 2

Isn't that why they invented mysqldump?

This allows you to dump a table to as file, as a create statement + a bunch of insert statements.

EDIT: see also this article about Using mysqldump

Answer 3

hey can u pls tell me hw to connect to mysql using c -sharp ?

mail id - [email protected]