禁用datagridview自动排序VB.NET [英] Disable datagridview automatic ordering VB.NET
问题描述
例如,我查询表列按此顺序:
选择Booking_ID,Client_Name,Room_ID
尽管SQL以正确的顺序返回列,但datagridview会以不同的顺序自动显示列:
code> Room_ID || Booking_ID || Client_Name
问题是如何禁用此自动列水平排序,因此datagridview会精确地显示表格SQL有吗?
我正在使用datasource方法来填充datagrid。
SQLDA = New SqlDataAdapter(SqlCmd)
SQLDataset = New DataSet
SQLDA.Fill(SQLDataset)
Form2.DGVData.DataSource = SQLDataset.Tables(0)
在大多数情况下,此问题不存在,datagridview与SQL完全一样显示表。
PS:我会发布图片,但我不允许,因为10个声誉是必需的。
简单,但应该工作:
dgvDataGridView.Columns (Booking_ID)DisplayIndex = 0
dgvDataGridView.Columns(Client_Name)DisplayIndex = 1
dgvDataGridView.Columns(Room_ID)。DisplayIndex = 2
'...
In some cases (I believe when inner join is used) datagridview does not represent correctly the column order populated from SQL query.
For example, I query the table columns in this order:
Select Booking_ID, Client_Name, Room_ID
although SQL return columns in correct order, however datagridview displays columns automatically in different order:
Room_ID || Booking_ID || Client_Name
The question is, how to disable this automatic column horizontal ordering, so datagridview displays the table exactly how SQL does?
I am using datasource method to fill the datagrid.
SQLDA = New SqlDataAdapter(SqlCmd)
SQLDataset = New DataSet
SQLDA.Fill(SQLDataset)
Form2.DGVData.DataSource = SQLDataset.Tables(0)
In most cases this problem is not present, and datagridview shows the table exactly as SQL does.
Thank you in advance.
PS: I would post the images but I'm not allowed since 10 reputation is required.
Simple, but should work:
dgvDataGridView.Columns("Booking_ID").DisplayIndex = 0
dgvDataGridView.Columns("Client_Name").DisplayIndex = 1
dgvDataGridView.Columns("Room_ID").DisplayIndex = 2
'...
这篇关于禁用datagridview自动排序VB.NET的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!