unable to connect to any mysql hosts

leeweelim — Mon, 28 Oct 2013 14:50:55 +0800

try
{
string myConnection = @"server=localhost,port =3306; database=lipsy2; username=root;password=7483876;";
MySqlConnection myConn = new MySqlConnection(myConnection);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = new MySqlCommand("select * lipsy2.customer;", myConn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
myConn.Open();
// DataSet ds = new DataSet();
//.Show("Connected");
txtMsg.Text = "Connected";
myConn.Close();
}
catch (Exception ex)
{
txtMsg.Text = ex.Message;
//MessageBox.Show(ex.Message);
}

// there are no error but enable to connect . whats wrong.

Lowyat.NET: Latest topics by leeweelim

unable to connect to any mysql hosts