C#查询MySQL数据库

最新推荐文章于 2024-07-07 20:51:49 发布

Mediary

最新推荐文章于 2024-07-07 20:51:49 发布

阅读量1.2k

点赞数

文章标签： MySQL

本文链接：https://blog.csdn.net/Mediary/article/details/103202679

版权

select id 
from user 
where username=310501 
union all 
select id 
from wallet 
where username=310501

C#读取

 string str = "select id from user " +
                "where username=" + userInfo.UserName +
                " union all " +
                "select id from wallet " +
                "where username=" + userInfo.UserName;
       MySqlCommand sqlCommand = new MySqlCommand(str, client.MySqlConn);
            MySqlDataReader reader = sqlCommand.ExecuteReader();
            string nickname = "";
            int id = 0;
            while (reader.Read())
            {
                //nickname = reader.GetString("nickname");
                id = reader.GetInt32("id");
                Console.WriteLine(/*"昵称=" + nickname + */"+id=" + id);
            }
            reader.Close();