第一个是SQL Server 数据库链接字符串
第二个是MySQL数据库链接字符串
App.config
<connectionStrings>
<add name="JMP_APP_SqlServerConnStr" connectionString="data source=192.168.1.22\test;initial catalog=dbName;User Id=sa;Password=xxx;"/>
<add name="QMS_MySqlServerConnStr" connectionString="server=localhost;Port=3306;Database=dbName;UID=root;PWD=xxx" />
</connectionStrings>
Insert 语句
--添加引用 MySQL.Data
using MySql.Data.MySqlClient;
private readonly string _qms_mysql_ConnectionString;
_qms_mysql_ConnectionString = ConfigurationManager.ConnectionStrings["QMS_MySqlServerConnStr"].ConnectionString;
private void saveItemMstAll(string item, string overview)
{
string insertSql = $@"INSERT INTO qms_t
(name
,number)
VALUES
(@item
,@overview)";
try
{
using (MySqlConnection qmsDBConnection = new MySqlConnection(_qms_mysql_ConnectionString))
{
qmsDBConnection.Open();
using (MySqlCommand cmd = qmsDBConnection.CreateCommand())
{
try
{
cmd.CommandText = insertSql;
cmd.Parameters.Add(new MySqlParameter("@item", item));
cmd.Parameters.Add(new MySqlParameter("@overview", overview));
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Log.Error($"Sync from ItemMstAll have error occur, {ex.Message} {ex.Source} { ex.StackTrace }");
}
}
}
}
catch(Exception ex)
{
Log.Error($"Sync from ItemMstAll have error occur, {ex.Message} {ex.Source} { ex.StackTrace }");
}
}
