demo
using MySql.Data.MySqlClient;
using System;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApp4
{
class Program
{
//SqlServer
static string SqlConn =
"server=172.20.121.136;uid=sa;pwd=abc123;database=Platform";
//MySql
static string MySqlConn =
@"server=172.20.180.42;Database=Platform;
Uid=root;Pwd=abc123;Port=3306;Allow User Variables=True;";
static void Main(string[] args)
{
string sql = "select * from SYS_User;";
DataTable dtSql = GetSqlDataTable(SqlConn, sql);
DataTable dtMySql = GetMySqlDataTable(MySqlConn, sql);
}
public static DataTable GetSqlDataTable(string conn, string sql
, params SqlParameter[] parms)
{
using (SqlConnection connection = new SqlConnection(conn))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = sql;
command.Parameters.AddRange(parms);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
}
public static DataTable GetMySqlDataTable(string conn, string sql
, params MySqlParameter[] parms)
{
using (MySqlConnection connection = new MySqlConnection(conn))
{
MySqlCommand command = connection.CreateCommand();
command.CommandText = sql;
command.Parameters.AddRange(parms);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
}
}
}