在我的网格视图中,我有一个列,它返回的值可以是0、1或2。
‘/>
当单元格中的行值分别为0、1或2时,我希望将colum的值更改为“NO”、"YES“和"N/S”。我一直在使用下面的代码,但我的网格视图只返回第一行。问题隐藏在哪里?
Sub GridPurch_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles GridPurch.RowDataBound
If (e.Row.RowType = DataControlRowType.DataRow) Then
Dim myVal As Integer = Convert.ToInt32(e.Row.Cells(0).Text)
If myVal = 0 Then
e.Row.Cells(13).Text = "NO"
ElseIf myVal = 1 Then
e.Row.Cells(13).Text = "YES"
ElseIf myVal = 2 Then
e.Row.Cells(13).Text = "NS"
End If
End If
End Sub这里是我按建议所做的更改,但是它只返回三行中的两行,而单元格中的文本没有改变,它仍然显示数字值?
Sub GridPurch_RowDataBound(ByVal sender As Object, ByVal e As
GridViewRowEventArgs) Handles GridPurch.RowDataBound
If (e.Row.RowType = DataControlRowType.DataRow) Then
For Each row As GridViewRow In GridPurch.Rows
Dim myVal As Integer = Convert.ToInt32(e.Row.Cells(13).Text)
If myVal = 0 Then
e.Row.Cells(13).Text = "NO"
ElseIf myVal = 1 Then
e.Row.Cells(13).Text = "YES"
ElseIf myVal = 2 Then
e.Row.Cells(13).Text = "NS"
End If
Next
End If
End Sub发布于 2017-05-06 11:04:07
在数据加载到数据网格之后,尝试这样做:让您的程序将数值从数字更改为单词。
对于DataGridView1.row中的每一行为DataGridViewRow
给出的代码应该让您知道应该做什么和寻找什么,只需编辑它以适应您想要做的事情。(在谷歌上寻求更多帮助)
https://stackoverflow.com/questions/43819381
复制相似问题