Select e.DataCol.Name Case "A","B","C","D" Dim s1() As String = {"优","良","中","及格"} Dim s2() As String = {"D","C","B","A"} For i As Integer = 0 To s1.Length - 1 If e.DataRow.IsNull(s2(i)) = False Then e.DataRow("E") = s1(i) Exit For End If Next If e.DataRow.IsNull(s2(0)) = False Then e.DataRow("F") = True End If End Select