Hi guys, I am trying to connect to mysql database from a .NET compact framework using C#. Each time I run the program, I get a missingmanifestresourceexception just at the point of opening the connection. Can any one please tell me how to go about this, I've lost four days already.
P.S: I already added the reference Mysql.Data.CF.
my code is as below
string MyConString ="SERVER=localhost;" + "DATABASE=kunle;" + "UID=root;" + "PASSWORD=olakay;"+ "pooling=false;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from mycustomers";
try
{
connection.Open(); //***this is the point where I get the error***
MessageBox.Show("Connected successfully");
}
catch (MySqlException asd)
{
MessageBox.Show("" + asd.Message);
}
catch (MissingManifestResourceException ex)
{
MessageBox.Show("" + ex.Message);
}
Reader = command.ExecuteReader();
while (Reader.Read())
{
//statement goes here;
}
connection.Close();
will be looking forward to an answer from anyone.
Olakay.