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.
You cannot remove the metadata information, it's required for the .NET runtime.
What you can do is renaming all yours classes, methods, and variables. One can still get the code, but its nearly impossible to understand it when everything is named a,b,c,...
Obfuscators are tools that automatically do this renaming in compiled assemblies. They also change the assembly in other ways to make it harder to understand; or try to introduce IL constructs that crash the decompiler.