"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook
I am doing a project in .net c# 2.0 with sqlserver2005
i have a listbox in the form in which i need to display some data from database.
i need to get the loginnames of those clients who have levelid= 2 and 3, and who r logged in.
For levelid and logindatetime are stored in 2 different tables 'login' and 'dealerlogin' respectively.
Now to get his data i queried (in sqlserveranalyzer): select loginname from login as a, dealerlogin as b where ((b.levelid = 2) or (b.levelid = 3)) AND ((a.logindatetime is not null) and (a.logoutdatetime is null))
But there is some error. There is some problem in joining the 2 diff. clauses of 2 diff. tables.
How can i do this?
Hope to get a reply.
I can able to view my entire assembly using Lutz Roeder’s Reflector Tool.
.NET Reflector, which is a class browser and decompiler that can examine an assembly and show you just about all of its secrets.
but, How do I encrypt or protect my MSIL and cannot be read? Which means, I would like to completely eliminate the metadata information stored in my assemblies such as class and methods names. I can do so using the obfuscator tools offered by various vendors. But, how do I enforce a restriction on a class or method and all its members by pure code.