using MySql.Data.MySqlClient; //引入MySql.Data.dll
public static Dictionary<string, string> csv_nameDic2 = new Dictionary<string, string>();
private void ConnectDataBase()
{
try
{
//建立连接
MySqlConnection mysqlConn = new MySqlConnection(string.Format(
"Server={0};Database={1};Uid={2};Pwd={3};port={4}",
"192.168.9.170", "****", "root", "*****", 3307));
mysqlConn.Open();
MySqlDataAdapter dataAdapter1 = new MySqlDataAdapter("select * from csv_name", mysqlConn);
MySqlDataAdapter dataAdapter2 = new MySqlDataAdapter("select * from csv_field", mysqlConn);
DataSet csvNameData = new DataSet();
DataSet csvFieldData = new DataSet();
dataAdapter1.Fill(csvNameData);
dataAdapter2.Fill(csvFieldData);
DataTable csvNameTable = csvN
c#获取MySql表中数据
最新推荐文章于 2024-11-20 15:26:45 发布