Restore database from file ?

[lm]

Hi guys

I have exported my database to a file.sql and i works like a charm.

But how do I restore/overwrite it from the file ? I guess I have to use the .Restore() ?..

Code exam. is appreciated

thank you..

[lm]

Hmm. If I export the database with the sample code, and then imports it again, I can't load the database to my datagrid anymore ?

I guess my problem is kinda complex.. damnit.

[Serious]

If you have a sql query and want to execute it (even if it consists of many sdq statements) you can use MySqlScript component. See class reference in MySQLDirect .NET documentation for additional information and sample code for this class. You can also use designer features of this component to become familiar with its functionality.