如何将SQL查询选择显示到gridview中？ [英] How to display SQL query selection into a gridview?

问题描述

我在ASP.NET中使用c＃创建了一个Web表单。通过使用此查询：

I have a web form in ASP.NET using c#. By using this query:

SELECT INST_ID, LongName FROM TableCOCINSE
EXCEPT
SELECT INST_ID, LongName from TableAFTE where AFTEYR = 2016

我试图将结果显示到GridView中。这就是我的代码：

I am trying to display the results into a GridView. This is what I have as my code:

SqlConnection con3 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PassoneConnectionString"].ConnectionString);
            con3.Open();

            SqlCommand com = new SqlCommand("(SELECT INST_ID, LongName FROM TableCOCINSE) EXCEPT (SELECT INST_ID, LongName FROM TableAFTE)", con3);

            DataTable dt = new DataTable();

            SqlDataReader sqlDataReader = com.ExecuteReader();

            dt.Load(sqlDataReader);
            sqlDataReader.Close();

            GridView dataGridView4 = new GridView();
            dataGridView4.DataSource = dt;

我缺少什么？



我尝试过的事情：



我几乎尝试过所有事情。 SQL查询在SQL Server Management Studio中工作。

What am I missing?

What I have tried:

I have tried almost everything. The SQL Query works in SQL Server Management Studio.

推荐答案

在此之后添加以下行 - > dataGridView4.DataSource = dt;

add below line after this -> dataGridView4.DataSource = dt;

dataGridView4.DataBind();

这篇关于如何将SQL查询选择显示到gridview中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！