C# MySql Server 5.1 help

[amr.adawy]

i'm building an application that creates a mySql db from script.sql file, i know that i have to run MySql server 5.1 Command Line Client and type this:

MySql> source ..\filepath\MyScript.sql;

now i need to run this command from my C# Application.

thanx in adcvance.

[JoeBuntu]

this worked for me:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.IO;
using MySql.Data.MySqlClient;

namespace ConsoleApplication1
{
    class Program
    {
        string sqlStr = "";
        static void Main(string[] args)
        {
            Program prg = new Program();
            prg.CreateDatabase();
        }

        void CreateDatabase()
        {
            using (StreamReader reader = new StreamReader(@"C:\Users\Jamie\Desktop\Temp\localhost.sql"))
            {
                sqlStr = reader.ReadToEnd();
            }

            MySqlConnectionStringBuilder cnxBldr = new MySqlConnectionStringBuilder();
            cnxBldr.Server = "192.168.27.5";
            cnxBldr.UserID = "admin";
            cnxBldr.Password = "password";            

            using (MySqlConnection cnx = new MySqlConnection(cnxBldr.ToString()))
            {
                cnx.Open();
                using (MySqlCommand sqlCmd = new MySqlCommand(sqlStr, cnx))
                {
                    int result = sqlCmd.ExecuteNonQuery();                    
                }
            }
        }

    }
}

[amr.adawy]

thanx,
it worked i knew that but it didn't come in my mind,