Re: [DotNetDevelopment] Sql Statement for Different Roles

[Stephen Russell]

On Mon, Apr 22, 2013 at 1:28 PM, Karl Smith <barn...@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 dotnetde...@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopm...@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 dotnetdevelopm...@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