Comments by Michiel du Toit (Top 13 by date)

You can create a log table in your database and add code on every activity that you want to record.

If you just want to log changes in the data create yourself a proxy class for your database interaction and do the logging there ;)

Hi Dennis,

You can use Environment.UserName to see which user is currently logged on to Windows.

You can use the Form's Load event to execute code when the form opens up.

Loading the settings from the file will depend on the type of file - if it is a text file you can use something like:
var myfile = new StreamReader(new FileStream("file.txt", FileAccess.Read));
myfile.ReadLine();

More details are necessary if you want more help.

There are no guarantees - they can be spoofed as well. Might be better to create a file on the drive to grant permission and then check its existence in the future.
If you need additional security you can include contents in the file and even encrypt it with a serial number / password.

Hi Donald, I think you're actually looking for Delegate.BeginInvoke (which uses a threadpool thread). Control.BeginInvoke posts to the control's message and thus does not utilize a seperate thread.

A great article on the topic:

http://www.codeproject.com/Articles/10311/What-s-up-with-BeginInvoke

A thread that does the processing and then invokes the UI to update progress might be a more intuitive solution to your problem?

Regards

Have you considered using a DataView and filtering the view on sTemp?

Something like this maybe?

var lst = new List<string>();

for (int i = 0; i < 5/*Number of columns*/; i++)
lst.Add(rd1["Param" + (i + 1).ToString()]);

var lst = new List<myclass>() will create a generic list that contains elements of type myclass.

Since lists do not have a fixed size there is no syntax such as new List<myclass>[10] - you can add items using lst.Add(instanceof_myclass) or lst.AddRange(arrayof_myclass).

What you're looking for is the CSharpCodeProvider to compile the code and then you can use AppDomains if you want to run it plug-in style. You have to implement the events using MarshalByRefObject to cross AppDomain boundaries and then use serializable EventArgs descendants as parameters or you won't be able to unload the domains later.

This is rather complicated to implement - unfortunately my existing code is application-specific, but here a few snippets that can help:

To compile the code (has to be a complete .cs file with usings and all) into a dll:

var cc = new CSharpCodeProvider(new Dictionary<string,>() { { "CompilerVersion", "v3.5" } });
var outputpath = BinaryFolder + TargetAssembly + ".dll";

CompilerParameters cp = new CompilerParameters()
{
OutputAssembly = outputpath,
WarningLevel = 3,
GenerateExecutable = false,
GenerateInMemory = false,
CompilerOptions = "/target:library /optimize"
};

cp.ReferencedAssemblies.Add(
"System.dll", "System.Data.dll", "System.Xml.dll", "mscorlib.dll",
"System.Windows.Forms.dll");

To execute the code from the dll that you have compiled:
var _domain = AppDomain.CreateDomain("Isolated:" + Guid.NewGuid());

var _value = (IExecute)_domain.CreateInstanceAndUnwrap(AssemblyName, "Full name of the class in the dll here", false, BindingFlags.CreateInstance | BindingFlags.Default, null, null, null, null, null);
//_value.Properties = assign them here;

_value.Execute();

Further, you have to create a class based on an interface and then use only the interface in the calling code (main app) and implement the class in the .cs file. If you use any virtual (override) methods you will not be able to unload the appdomain (plug-in) later.

Hope this gives you a point to begin...