sl1 sl2 sl3 sl4 做为临时值、最后合并到【第九列】;这个公式该怎么改
Select Case e.DataCol.name
Case "第一列","第二列","第三列","第四列"
If e.DataRow.isnull("第一列") = Nothing Then
sl1 = "第一列:" + e.DataRow("第一列") + "米;"
Else
sl1 = ""
End If
If e.DataRow.isnull("第二列") = Nothing Then
sl2 = "第二列:" + e.DataRow("第二列") + "公里;"
Else
sl2 = ""
End If
If e.DataRow.isnull("第三列") = Nothing Then
sl3 = "第三列:" + e.DataRow("第三列") + "公里;"
Else
sl3 = ""
End If
If e.DataRow.isnull("第四列") = Nothing Then
sl4 = "第四列:" + e.DataRow("第四列") + "公里;"
Else
sl4 = ""
End If
e.DataRow("第九列") = sl1+ sl2 +sl3 +sl4
End Select