domenica 2 agosto 2009

Mysql Data provider...

Non proprio.

Tuttavia potrebbe sempre servire trovarsi un po di pappa pronta...

public class MySqlDataProvider
{
private string _connection;
private MySqlConnection msc = null;

public MySqlDataProvider(MySqlConnectorsDataItem mscDi)
{
msc = new MySqlConnection();
_connection = mscDi.ToString();
msc.ConnectionString = _connection;
}

public MySqlDataProvider(string connectionString)
{
msc = new MySqlConnection();
_connection = connectionString;
msc.ConnectionString = _connection;
}

public void ExecuteNonQuery(MySqlCommand myQuery)
{
myQuery.Connection = msc;
myQuery.ExecuteNonQuery();
}

public DataTable ExecuteReader(MySqlCommand myQuery)
{
DataTable dtx = new DataTable();
myQuery.Connection = msc;
MySqlDataAdapter myda = new MySqlDataAdapter(myQuery);

myda.Fill(dtx);
myda = null;

return dtx;
}
}