I can think of one really good reason to know IL -
in 2.0 you can use the DynamicMethod class to generate functions
on the fly and attach them to assemblies - rates 10 on the coolness scale!
think about the first WHERE clause - top 250 < x
starts with first record so you get 1 .. 250. This suggests you
should use an ORDER BY in the first select to reverse the sort order.
a) get the char index of the line by sending message EM_LINEINDEX
b) set the selection to that point in the control (or the whole line EM_LINELENGTH) with EM_SETSEL or Select(int index, int lenght)
a million lines of code ? man! that's some complex form.
and either you've been cranking out a thousand lines of code day
for the last three years or you've resorted to 'other methods', best
not described in polite company.
noticed that too - real slow down on start up. didn't turn on the fire wall (probably noticed ZoneAlarm) - the only real groans of agony seem to come from the malicious
hacker corner.
Take a higher level view of what the framework offers.
check out help topics under .NET Remoting.
An excellent book on the subject is:
Advanced .NET Remoting by Ingo Rammer (Apress)
why reinvent the wheel? look into .NET Remoting
MarshalByRef objects
passing serializable objects by value - you get a wide range of configuration options. Binary, Soap, Http, TCP even custom protocols and formatting layers.
for starters - in the 'Accept Changes' subsection (bad programming style, better
to factor out into separate functions) you declare a variable: Dim SearchPart but
you don't use it. You just grab whatever the CurrencyManager happens to be sitting on (why bother with a CurrencyManager if you don't uses UI databinding?).
Your code as deeply flawed.
Besides this - it's necessary to see the updating logic of the Adapter's Commands
to know what's going on.
sorry i can't be of more help - I've been using the GPL SharpDevelop to learn .NET, and just Monday managed to get a free copy of VB Net Standard, so don't really
know enough - sounds like your templates (used to create new stuff) are missing or corrupt.