If you're using Microsoft Studio or similar, simply look in their help under DataAdapter, DataReader, DataTable, DataConnection, etc. But instead of using the MS version, add a reference to the .NET connector. Put using MySql.Data.MySqlClient; at the top of your file. Change all the examples slightly. Like this:

///<summary>This data adapter is used for all queries to the database.</summary> private MySqlDataAdapter da; ///<summary>This is the connection that is used by the data adapter for all queries.</summary> private MySqlConnection con; ///<summary>Used to get very small bits of data from the db when the data adapter would be overkill. For instance retrieving the response after a command is sent.</summary> private MySqlDataReader dr; ///<summary>Stores the string of the command that will be sent to the database.</summary> private MySqlCommand cmd; ///<summary>After inserting a row, this variable will contain the primary key for the newly inserted row. This can frequently save an additional query to the database.</summary> public int InsertID;

///<summary>Sends a non query command to the database and returns the number of rows affected. If true, then InsertID will be set to the value of the primary key of the newly inserted row.</summary> public int NonQ(string command,bool getInsertID){ cmd.CommandText=command; int rowsChanged=0; try{ con.Open(); rowsChanged=cmd.ExecuteNonQuery(); if(getInsertID){ cmd.CommandText="SELECT LAST_INSERT_ID()";

dr=(MySqlDataReader)cmd.ExecuteReader(); if(dr.Read())

InsertID=PIn.PInt(dr[0].ToString()); } } catch(MySqlException e){ MessageBox.Show("Error: "+e.Message+","+cmd.CommandText); } //catch{ // MessageBox.Show("Error: "+); //} finally{ con.Close(); } return rowsChanged; }

///<summary>Fills table with data from the database.</summary> public DataTable GetTable(string command){ cmd.CommandText=command; DataTable table=new DataTable(); try{ da=new MySqlDataAdapter(cmd); da.Fill(table); } //catch(MySqlException e){ // MessageBox.Show("MySQL Error: "+e.Message); //} catch(MySqlException e){ MessageBox.Show("Error: "+e.Message+","+cmd.CommandText); } finally{ con.Close(); } return table; }