c#获取MySql表中数据

最新推荐文章于 2024-11-20 15:26:45 发布

差点忘记打铁了

最新推荐文章于 2024-11-20 15:26:45 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： c#

本文链接：https://blog.youkuaiyun.com/Fenglele_Fans/article/details/96994383

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