编译器错误消息：BC30201：预期的表达式。在IF ELSE语句中给出错误 [英] Compiler Error Message: BC30201: Expression expected. give error in IF ELSE statement

问题描述

For Each row As GridViewRow In GridView1.Rows

           If
               Dim studentid As String = CType(row.FindControl("Label1"), Label).Text
               studentid = sid

                 Then

               cmd.CommandText = "update feerpt " & _
                                 " set  receved=receved+@receved,balance=@balance" & _
                                  " where studentid= " & sid & ""

           Else

               Dim amount As String = CType(row.FindControl("Label4"), Label).Text
               Dim feeheadid As String = CType(row.FindControl("Label3"), Label).Text
               Dim studentid As String = CType(row.FindControl("Label1"), Label).Text
               Dim monthid As String = CType(row.FindControl("Label2"), Label).Text
               Dim receved As String = CType(row.FindControl("txtrec"), TextBox).Text

               cmd.CommandText = " insert into feerpt(feeheadid,studentid,monthid,receved,amount) " & _
                             " values (" & feeheadid & "," & studentid & "," & monthid & "," & receved & "," & amount & ")"
               cmd.ExecuteNonQuery()


           End If
               Next

推荐答案

查看代码：

Look at the code:

If
    Dim studentid As String = CType(row.FindControl("Label1"), Label).Text
    studentid = sid

      Then

    cmd.CommandText = "update feerpt " & _
                      " set  receved=receved+@receved,balance=@balance" & _
                       " where studentid= " & sid & ""

可能，你的意思是：

probably, what you meant to say was:

Dim studentid As String = CType(row.FindControl("Label1"), Label).Text
If studentid = sid Then

    cmd.CommandText = "update feerpt " & _
                      " set  receved=receved+@receved,balance=@balance" & _
                      " where studentid= " & sid & ""

这篇关于编译器错误消息：BC30201：预期的表达式。在IF ELSE语句中给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！