troubleshooting Question

Stop column in DataGridView from displaying

Avatar of Zbiebu
Zbiebu asked on
Visual Basic.NET
2 Comments1 Solution382 ViewsLast Modified:
 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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros