admin管理员组

文章数量:1356064

I'm getting this error when my code runs and I can't work out why as the syntax looks on point but I could be missing or misunderstanding something

System.Data.SyntaxErrorException: 'Syntax error: Missing operand after 'OrganisationSiteCode' operator.'

This is the code. Treatments is a simple data access layer object. I've tried various syntax changes but still the error.

            Dim siteCode = 'RHA58'
            Dim RowF = $"SiteCode IN (SELECT OrganisationSiteCode FROM vwOrganisations WHERE OrganisationCode = (SELECT DISTINCT OrganisationCode FROM vwOrganisations WHERE OrganisationSiteCode = '{siteCode}'))"
            Treatments.getDataTable.DefaultView.RowFilter = RowF

本文标签： netSyntax error using DefaultViewRowFilter on DataTableStack Overflow

版权声明：本文标题：.net - Syntax error using DefaultView.RowFilter on DataTable - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744026056a2578059.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。