为什么DataGridView没有绑定？ [英] Why DataGridView is not getting bound?

问题描述

在以下代码中， DataSource ' ds '包含数据，但 DataGridView 除了空白列外没有显示任何内容。使用调试器，行 dataGridView.visible = true 它显示为 false 。



如何将数据库列绑定到DataGridView列？

In the following code, the DataSource 'ds' has data but the DataGridView doesnt show anything except blank columns. Using debugger, at line dataGridView.visible=true it shows as false.

How to bind database columns to DataGridView columns?

List<string> adds = new List<string>();
SqlDataAdapter da = new SqlDataAdapter("seLECT YEAR(startdt) AS [Year],MONTH(startdt) AS [Month], DAY(startdt) as [day],cast(startdt as datetime) as [datetime], COUNT(*),ipaddress from visit Group By YEAR(startdt), MONTH(startdt),day(startdt),startdt,ipaddress", con);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "normalpackage");

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
    adds.Add(ds.Tables[0].Rows[i].ItemArray[0].ToString());
}
dataGridView1.DataSource = ds;
bindingSource1.DataSource = ds;
dataGridView1.Visible = true;

推荐答案

你必须在将数据源分配给gridview之后，使用 DataBind（）。请参阅下面的代码，

You must use DataBind(), after assigning datasource to gridview. See the code below,

List<string> adds = new List<string>();
SqlDataAdapter da = new SqlDataAdapter("seLECT YEAR(startdt) AS [Year],MONTH(startdt) AS [Month], DAY(startdt) as [day],cast(startdt as datetime) as [datetime], COUNT(*),ipaddress from visit Group By YEAR(startdt), MONTH(startdt),day(startdt),startdt,ipaddress", con);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "normalpackage");
 
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
    adds.Add(ds.Tables[0].Rows[i].ItemArray[0].ToString());
}
dataGridView1.DataSource = ds;
dataGridView1.DataBind();
bindingSource1.DataSource = ds;
dataGridView1.Visible = true;</string></string>

-KR

-KR

这篇关于为什么DataGridView没有绑定？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！