Archief - [PROG][C#] .NET en MySql

using System.Data;
using System.Data.OleDb;
...
System.Data.OleDb.OleDbConnection con;
con=new System.Data.OleDb.OleDbConnection();
con.ConnectionString="Provider=MySQLProv;Data Source=mysql;";
try
{
	con.Open();
	if (con.State==ConnectionState.Open) MessageBox.Show("Connection to MySQL opened through OLE DB Provider");
	con.Close();
}
catch(Exception ex)
{
	MessageBox.Show(ex.Message);
}

public void InsertRow(string myConnectionString)
{
          // If the connection string is null, use a default.
          if(myConnectionString == "")
          {
                    myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass";
          }
          MySqlConnection myConnection = new MySqlConnection(myConnectionString);
          string myInsertQuery = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)";
          MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
          myCommand.Connection = myConnection;
          myConnection.Open();
          myCommand.ExecuteNonQuery();
          myCommand.Connection.Close();
}