MySqlConnection class

How do I perform queries with this class? None of the reference I've found shows this. It talks about transactions but not queries. Transactions look like queries but seem to be different.

Also how do I do certain things like fetch row, etc? It seems very limited.

Lastly, where can I find error handling examples, like making sure a query executes, the server is up, etc?

Thanks in advance.

Take a look here:
http://dev.mysql.com/doc/refman/5.1/...gintransaction

Look at the examples

Oh so it IS transactions? I read that exact doc but I thought those were for something else. I've never seen queries be called that before, thought they were something else.


Also where can I find error handling for the actual connection? In that doc there is none that I can see. Ex: if password is wrong, it should return an error.

pseudo code:

Code:

---

try
{
  if password incorrect then
  throw new Exception("password is incorrect");
}
catch (exception e)
{
    MessageBox.Show(e.message);
}

---