我如何以窗口形式在C＃中运行查询 [英] How I can run a query in C# in window form

问题描述

嗨



i在mysql中加入了4个表

i希望看到那个查询om datagridview

i想要在窗口中运行mysql数据库查询









我怎么做？



我尝试过：



i试图完全按照我的意愿进行查询及其工作，但我不知道如何将查询与表格

hi

i joined 4 tables in mysql
i want to see that query om datagridview
i want to run a query of mysql database in a window form




how i can do it?

What I have tried:

i tried to do a query and its work exactly as i want but i don't know how to connect the query with the form

推荐答案

连接：尝试：

Try:

MySqlConnection con = new MySqlConnection(connection))
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = new MySqlCommand("SELECT * FROM MyTable", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
myDataGridView.DataSource = dt;

这篇关于我如何以窗口形式在C＃中运行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！