gridview没有显示值 [英] gridview is not showing values

问题描述

我的gridview没有显示数据，

i用断点检查，数据表显示数据但是gridview没有显示， .query是正确的，在Mysql workbench.it的winforms应用程序上毁了。

my gridview is not showing data,
i checked with breakpoints, datatable is showing data but gridview is not showing,.query is correct, runed on Mysql workbench.it's winforms application.

<pre lang="c#"> using (MySqlConnection con = new MySqlConnection(ConnectionString))
            {
                String query = "select * from transaction where DATE(paid_date)BETWEEN '" + fromdate + "'AND'" + todate + "' AND(customer_id='" + customer + "' OR card_id='" + card + "')";
                con.Open();
                MySqlDataAdapter da = new MySqlDataAdapter(query, con);
                DataTable dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;
                //dataGridView1.DataBind();

推荐答案

dataGridView1.AutoGenerateColumns = true;



da.Fill（dt）;

dataGridView1.DataSource = dt



查看

dataGridView1.AutoGenerateColumns = true;

da.Fill(dt);
dataGridView1.DataSource = dt

check with this

查看这些链接



http ：//www.aspsnippets.com/Articles/Bind-Fill havenGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx [ ^ ]





http://stackoverflow.com/questions/8154839/ vs2010-winforms-datagridview-binding-to-dataset [ ^ ]

Check these links

http://www.aspsnippets.com/Articles/Bind-Fill-DataGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx[^]


http://stackoverflow.com/questions/8154839/vs2010-winforms-datagridview-binding-to-dataset[^]

这篇关于gridview没有显示值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！