MySql data source plugin for the BPGridView package.
Using MySql Connector/Net, MySql.Data.dll v. 5.1.1.1.
The package only consists of two dll's.
Modify it any way you like. The source code is here:
using System;
using System.Data;
using MySql.Data.MySqlClient;
using System.Web.UI.WebControls;
namespace BP.Umb.DataSourcePlugin
{
public class MySqlPlugin : IDataSourcePlugin
{
public MySqlPlugin()
{
}
// The single point of entry to our plugin
// Accepts an IPluginContext object which holds the current context.
public void PerformAction(IDataSourcePluginContext context)
{
context.DataSource = CreateDataSource(context);
}
// Create the data source
private DataTable CreateDataSource(IDataSourcePluginContext context)
{
MySqlConnection myConnection = new MySqlConnection(context.ConnectionString);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter(context.QueryString, myConnection);
DataTable myDataTable = new DataTable();
myDataAdapter.Fill(myDataTable);
return myDataTable;
}
}
}
The IDataSourcePlugin is defined within the
BP.Umb.DataSourcePlugin namespace in the BPGridView dll:
using System;
using System.Data;
using System.Runtime.InteropServices;
using System.Web.UI.WebControls;
namespace BP.Umb.DataSourcePlugin
{
[GuidAttribute("3ce6edc1-be6e-4a80-aabb-3368dd813841")]
public interface IDataSourcePlugin
{
void PerformAction(IDataSourcePluginContext context);
}
public interface IDataSourcePluginContext
{
string ConnectionString { get; set; }
string QueryString { get; set; }
DataTable DataSource { get; set; }
}
}