Conexion Base de datos

String de consulta

str = "Server=127.0.0.1:3306;Database=veterinari;User id=root;Password=";
MySqlConnection cnx = New MyQslConnection(str);

Ejecutar comando

public int Execute(String sentence) // insert into veterinatio ("daniel","")
    {
	Connection cnx = new Connection();
	MySqlCommand cmd = new MySqlCommand(sentence, cnx.ObtenerConexion());
	return cmd.ExecuteNonQuery();
    }

Consulta

public DataTable Query (String[] Fields, String Sentence)
{
	Connection cnx = new Connection ();
	MySqlCommand cmd = new MySqlCommand (Sentence, cnx.ObtenerConexion ());
	DataTable resultSet = new DataTable ();

	foreach (var field in Fields) {
		resultSet.Columns.Add (field);
	} 

	MySqlDataReader consultar = cmd.ExecuteReader ();
	//resultSet.Load (consultar);

	while (consultar.Read ()) {
		DataRow row = resultSet.NewRow ();
		for (int i = 0; i < Fields.Length; i++) {
			row [Fields [i]] = consultar.GetString (i);
		}

		resultSet.Rows.Add (row);
	}
	return resultSet;
}

Insertar

public int Insert (String table, String[] Fields, String[] Values)

	if (Fields.Length == Values.Length) {

		var str = "INSERT INTO" + table + 
			MkString (Fields, "(", ",", ")") + values
                         + MkString (Values, "(", ",", ")");
		Execute (str);

	} else {
		throw new InvalidExpressionException ();
	}
}