带有数据源的VB.net Datagridview列类型 [英] VB.net Datagridview column type with datasource

问题描述

亲爱的专家，每次从数据库收集数据时，我都会有
，我有超过500条记录，每个数据需要在我填充自定义datagridview之前被消化。通过使用For Each循环，花了10-15秒，所以我决定使用数据源将数据添加到datagridview。



但我怎么能做一些如果我使用数据源将数据添加到datagridview中，那么现有列会变成DataGridViewButtonColumn吗？

解决方案

在运行时手动定义列。

< br $>

 Datagridview1.DataSource = MyDatatable 
 
 使用 Datagridview1 
。清除
 .AutoGenerateColumns = 错误 
 
 ' 文本框列 
 .Columns.Add（  ColumnName1， 列名1）
 .Columns （ 0 ）。DataPropertyName =   FileName  数据表列名称 
 .Columns（  0 ）。DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft 
 
 ' 复选框列 
  Dim  m_Active  As  新 DataGridViewCheckBoxColumn 
 m_Active.HeaderText =   Active 
 m_Active.DataPropertyName =  有效 
 .Columns.Add （m_Active）
 .Columns（ 1 ）。DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft 
 
 ' 按钮列 
  Dim  m_ButtonColumn 作为 新 DataGridViewButtonColumn 
 m_ButtonColumn.HeaderText =    SomeValue 
 m_ButtonColumn.DataPropertyName =   SomeValue 
 .Columns.Add（m_ButtonColumn）
 
 结束 使用 

Dear experts,
each time I collect data from database, I have more than 500 records and each data need to be digested before I populate in customised datagridview. By using "For Each" looping, it took 10 - 15 seconds, so I decided to use datasource to add the data into datagridview.

But how can I make some of the existing columns become DataGridViewButtonColumn if I am using datasource to add data into datagridview?

解决方案

Manually define you column at runtime.

Datagridview1.DataSource = MyDatatable

With Datagridview1
 .Clear
 .AutoGenerateColumns = False

'Textbox Column
 .Columns.Add("ColumnName1", "Column Name 1")
 .Columns(0).DataPropertyName = "FileName"'Datatable column Name
 .Columns(0).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft

'Checkbox column
 Dim m_Active As New DataGridViewCheckBoxColumn
 m_Active.HeaderText = "Active"
 m_Active.DataPropertyName = "Active"
 .Columns.Add(m_Active)
 .Columns(1).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft

'Button Column
Dim m_ButtonColumn As New DataGridViewButtonColumn
m_ButtonColumn.HeaderText = "SomeValue"
m_ButtonColumn.DataPropertyName = "SomeValue"
.Columns.Add(m_ButtonColumn)

End With

这篇关于带有数据源的VB.net Datagridview列类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！