在gridview列中显示数据 [英] show data in gridview column

问题描述

我在gridview列中显示数据时出现问题........实际上我在datagridview中有4列，当我从数据库中检索数据并在数据集中存储数据时，当我将数据集连接到datarid视图时创建4个新列，但我想在existes列显示数据......



所以plz帮助我......



关于

Sham

i m getting problem in showing data in gridview column........actually i have 4 column in my datagridview , when i retrive data from database and store data in dataset and when i connect dataset to datarid view then it create 4 new column but i want to show data in existes column......

so plz help me......

regard
Sham

推荐答案

我会以编程方式将数据集中的记录添加到datagridview 。

例如：

- 创建与记录匹配的类（具有与字段匹配的属性）

I would programmatically add the records in the dataset to the datagridview.
For example like this:
- Create class that matches a record (with properties matching the fields)

Class OneRecord<br />
{<br />
  public int UID { get; set; }<br />
  public string Name { get; set; }<br />
  public DateTime Date { get; set; }<br />
  public bool Checked { get; set; }<br />
}<br />

- 创建此类的BindingList

私有BindingList< OneRecord> MyList = new ...

- 将datagridview的数据源引用到BindingList的实例

this.dgv.DataSource = this.MyList;

- 将记录添加到BindingList实例作为类的实例，需要一些逻辑这个

- 刷新datagridview

this.dgv.Refresh（）;



这样你就不会需要担心数据集与gridview等的行为。

- Create BindingList of this class
Private BindingList<OneRecord> MyList = new ...
- Reference DataSource of datagridview to instance of BindingList
this.dgv.DataSource = this.MyList;
- Add records to instance of BindingList as instances of the class, need some logic for this
- Refresh datagridview
this.dgv.Refresh();

This way you don''t need to worry about behavior of dataset vs gridview etc.

我自己解决........



SqlConnection con = new SqlConnection（Data Source = .; Initial Catalog = sham; Integrated Security = True）;

con.Open（）;

SqlDataAdapter da = new SqlDataAdapter（选择姓名，来自员工的地址，con）;

DataSet ds = new DataSet（）;

da.Fill（ds）;

CustName.DataPropertyName =名称;

CustAddress.DataPropertyName =地址;

dataGridView1.AutoGenerateColumns = false;

dataGridView1.DataSource = ds.Tables [0] .DefaultView;

I solve my self........

SqlConnection con = new SqlConnection("Data Source=.; Initial Catalog=sham; Integrated Security=True");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select Name,Address from Employee", con);
DataSet ds = new DataSet();
da.Fill(ds);
CustName.DataPropertyName = "Name";
CustAddress.DataPropertyName = "Address";
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = ds.Tables[0].DefaultView;

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