dim strsql as string
strsql="select count(*) from team_member where userid= '" & Session("CurUser").ToString() & "' and team_code in(select team_code from sales_team where proj_code='" & request.cookies("Projects").Value &"')"orstrsql= String.Format("select count(*) from team_member where userid= '{0}' and team_code in (select team_code from sales_team where proj_code='{1}')", Session("CurUser").ToString().Replace("'","''"),request.cookies("Projects").Value.Replace("'","''"))
strsql="select count(*) from team_member where userid= '" & Session("CurUser").ToString() & "' and team_code in(select team_code from sales_team where proj_code='" & request.cookies("Projects").Value &"')"orstrsql= String.Format("select count(*) from team_member where userid= '{0}' and team_code in (select team_code from sales_team where proj_code='{1}')", Session("CurUser").ToString().Replace("'","''"),request.cookies("Projects").Value.Replace("'","''"))
除非你重载这个运算符.
所以你知道了,操作数要调整