change gridview text

[martin1]

Hi, All,

Anyone knows how to change gridview text info? specifically the gridview
populate from sql db, first column is string rather than number, i want to
change first row in first column into another string, for example "Book" ,
but I don't want this chnage to affect database.

Thanks

[gene kelley]

On Tue, 22 Aug 2006 11:04:02 -0700, martin1 <ma*****@discus sions.microsoft .comwrote:

>Hi, All,

Anyone knows how to change gridview text info? specifically the gridview
populate from sql db, first column is string rather than number, i want to
change first row in first column into another string, for example "Book" ,
but I don't want this chnage to affect database.

Thanks

I'm not sure, but I think you are after something like this using the CellFormatting Event:

Private Sub MainGridView_Ce llFormatting(By Val sender As Object, ByVal e As _
System.Windows. Forms.DataGridV iewCellFormatti ngEventArgs) Handles MainGridView.Ce llFormatting
With Me.MainGridView .Columns(e.Colu mnIndex)
Select Case .Name
Case "Scans"
e.Value = IIf(CType(e.Val ue, Boolean), "Yes", "No").ToStr ing

Case "Genre"
e.Value = String.Concat(G etGenreName(CTy pe(e.Value, Integer)), ": ", _
Me.MainGrid.Row s(e.RowIndex).C ells("Style").V alue)
End Select

End With
End Sub

In the above, in the column named "Scans", the db's Boolean values are displayed as a string value
rather than True or False.

In the column named "Genre", a concacted string is displayed which consists of a string value based
on the db's genre integer value, plus the string value from a hidden column named "Style".
You can also use "e.RowIndex " to target specfic cells.
Gene