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