在vb.net中压缩查询字符串时预期出现错误表达

debugcn 发表于 Dev

厄默尔

我在vb.net中有以下查询，该查询给出了代码第二行中期望的错误表达式，第二行是＆“ from groups，Group_permissions”＆_，并且用蓝色突出显示了＆，并表示期望表达式？

           Using Grp As New OleDb.OleDbDataAdapter(" select Groups.Group_ID, Count
                                       (Group_PErmissions.Access_ID) as Cnt " & _ 
                                        & " from Groups, Group_Permissions " & _ 
                                  & " where Groups.Group_Id = Group_Permissions.Group_ID " & _ 
                                            & " and Groups.Group_Name = " & "'" & 
                                            Cmb_Groups.Text & "'" & _ 
                                            & " group by Groups.Group_Id ", App_Connection  )
             End Using

提前致谢

爱尔兰怪胎82

 Using Grp As New OleDb.OleDbDataAdapter(" select Groups.Group_ID, Count (Group_PErmissions.Access_ID) as Cnt " & _ 
                                         " from Groups, Group_Permissions " & _ 
                                         " where Groups.Group_Id = Group_Permissions.Group_ID " & _ 
                                         " and Groups.Group_Name = " & "'" & Cmb_Groups.Text & "'" & _ 
                                         " group by Groups.Group_Id ", App_Connection  )
End Using

我没有在VB中测试此语法是否存在其他语法错误。但这应该可以解决您所看到的错误。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。