Zbiebu
asked on
Stop column in DataGridView from displaying
Try
connection.Open()
adapter = New SqlDataAdapter(sql, connection)
adapter.Fill(ds)
ds.Locale = System.Globalization.CultureInfo.InvariantCulture
connection.Close()
DGVListAll.DataSource = ds.Tables(0)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
'Set the DataGridView properties to bind it to the data
Me.DGVListAll.AutoResizeColumn(DataGridViewAutoSizeColumnsMode.AllCells)
'DGVListAll.AutoGenerateColumns = True
Me.DGVListAll.Columns("Date").DefaultCellStyle.Format = "dd/MM/yyyy"
Me.DGVListAll.Columns("VDate").DefaultCellStyle.Format = "dd/MM/yyyy"
'Declare and set the currency header alignment property
Dim objAlignRightCellStyle As New DataGridViewCellStyle
objAlignRightCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
'Declare and set the alternating rows style
Dim objAlternatingCellStyle As New DataGridViewCellStyle()
objAlternatingCellStyle.BackColor = Color.WhiteSmoke
DGVListAll.AlternatingRowsDefaultCellStyle = objAlternatingCellStyle
'Bind Link column
Dim linkColumn As DataGridViewLinkColumn = New DataGridViewLinkColumn()
linkColumn.DataPropertyName = "Link"
linkColumn.HeaderText = "Link"
DGVListAll.Columns.Add(linkColumn)
Hi,
I use the code above to display a DataGridView column text as a hyperlink. This works fine but it still dispays the original column. So I have 1 'Links' column that is normal text and the other as hyperlink. How can I stop the original text column from displaying.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER