On Mon, Apr 22, 2013 at 1:28 PM, Karl Smith <barnun...@gmail.com> wrote:
>
>
> Dim ThisRole As String = Session.Contents("AccessType")
> If ThisRole <> "CORP" Then
> strSQL = "SELECT * FROM eIndLic WHERE (UID =" & Session("UID") &
> ") AND (RegionCode =" & CLIENTID & ") AND (Status IN ('R', 'RR','N','NN'))
> AND (ServiceType = 'R') ORDER BY State"
> Else
> strSQL = "SELECT * FROM eIndLic WHERE (RegionCode =" & CLIENTID &
> ") AND (Status IN ('R', 'RR','N','NN')) AND (ServiceType = 'R') ORDER BY
> State"
>
-----------------------------
Pass the ThisRole as well as CLIENTID to a SPROC and execute the same
concept in the backend.
Or I am not in favor of generating statements and just submitting them to
the backend as you have done.
Could be done via Entity Framework or old school passing a stored procedure
request with a params collection.
>
>
> --
> --
> You received this message because you are subscribed to the Google
> Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
> Web Services,.NET Remoting" group.
> To post to this group, send email to dotnetdevelopment@googlegroups.com
> To unsubscribe from this group, send email to
> dotnetdevelopment+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
> or visit the group website at http://megasolutions.net
>
> ---
> You received this message because you are subscribed to the Google Groups
> "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
> Services,.NET Remoting" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dotnetdevelopment+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetdevelopment@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopment+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
---
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to dotnetdevelopment+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
