当我运行代码时,有一个错误如下:
无法加载来自汇编的'devart.data.mysql.mysqldipendenty' 'devart.data.mysql,版本= 8.10.1086.0,文化=中性, publicKeyToken = 09AF7300EEC23701'。
哪一部分会导致此问题?
这是我的示例代码...
using Devart.Data.MySql;
public partial class Form1 : Form
{
public string Query = "Select * from tbltransaction";
public MySql.Data.MySqlClient.MySqlConnection cn;
public MySql.Data.MySqlClient.MySqlDataAdapter sqlAdapter;
public DataSet dsdatagrid;
public DataTable dt;
public DataGridView datagrid;
public Form1()
{
InitializeComponent();
Start();
}
string connectionString = "User Id=root;Password=123!@#abcD;Host=localhost;Database=kcms1_test;";
void Start()
{
try
{
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();
MySqlCommand commandDeptEmp = new MySqlCommand("select * from tbltransaction", connection);
//MySqlCommand commandPict = new MySqlCommand("select * from mysqlnet_pictures", connection);
MySqlDependency dependency = new MySqlDependency(commandDeptEmp, 1000);
dependency.AddCommandDependency(commandDeptEmp);
//dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
MySqlDependency.Stop(connectionString);
MySqlDependency.Start(connectionString);
OpenLocalDBConnection();
View_Data();
DataGridView_tbltransaction.DataSource = datagrid.DataSource;
}
catch
{
Stop();
}
finally
{
}
}
void Stop()
{
MySqlDependency.Stop(connectionString);
}
void dependency_OnChange(object sender, MySqlTableChangeEventArgs e)
{
// process changes
View_Data();
DataGridView_tbltransaction.DataSource = datagrid.DataSource;
}
void View_Data()
{
sqlAdapter = new MySql.Data.MySqlClient.MySqlDataAdapter(Query, cn);
dsdatagrid = new DataSet();
sqlAdapter.Fill(dsdatagrid);
dt = new DataTable();
datagrid.DataSource = dsdatagrid.Tables;
}
void OpenLocalDBConnection()
{
cn.ConnectionString = "server=locahost;userid=root;password=123!@#abcD;database=kcms1_test";
cn.Open();
}
}