Comments by Daniele Rota Nodari (Top 45 by date)

The records are duplicated, then you need to instruct the query processor to avoid repetitions.
An alternative to DISTINCT is GROUP BY, but id would not add value to the query; it would render it longer and less readbale.
The only way to avoid duplication is to prevent it by having a table containing only the key combination records; that is, a table with only PlaceId and Loc fields, populated without repetitions; that would become a master/parent table.

Yes, as you already did, disposing the Graphics objects is important to reduce resource usage, and "using" is an easy way to ensure that.
This is a further reason to move "Save" out of "using", in order to dispose Graphics objects as soon as they are no longer needed.
You can move before any "using" block any instruction that DOES NOT interact with the Graphics object allocated by that "using"; this could also help into refactoring code by moving some code to new, specialized, methods (e.g.: there are 2 "using(Graphics...." blocks that seem almost identical to each other).
Last thing: using/Dispose are missing for tempBitmap; pay attention to this one because two new Bitmap objects are assigned to that variable.

I would check effects of "SetResolution", in case postponing its invocation or trying avoiding it.
Variable myEncoderParameters is another candidate.
In additon, I would move all "Save" invocations out of "using (Graphics)" blocks (this would also allow to move SetResolution between using block and Save invocation).

Have you tried Invalidate instead of Refresh?
Does RotatingFlash regenerate the image? Does it test the current timestamp (thorugh date/time, ticks, StopWatch or whatever...) or simply increments a frame counter?

What are the exact error exception and message?
If it refers only to FileMode, than could be that the GetStream method does not support that specific mode; usually FileMode.CreateNow is used to create (and write) a new file, not to read an existing one.
Write responsibility in your code seems delegated to XmlWriter only and mainPart.GetStream seems to return (read) a stream of existing data.

Did you mean that the toolstrip button should be disabled when the form is shown and the button should be re-enabled when the form closes?
What happens to the other buttons? You have to disable or enable them when the form becomes visible or closes?
Anyway, the current loop contents are equivalent to a simpler "item.Enabled=(item!=sender);"; that does not change the result but makes the code more readable and maintenable.
In case, you can save "item!=sender" to a locale variable and assign that variable to "item.Enabled":
var itemIsSender = item == sender;
item.Enabled = !itemIsSender;

The result (third table) is NOT the representation of what you ask.
All the days from the first table are used in the second table (all DayId values are present).
Maybe you should clarift what do you mean for "used" or "not used".
Does "used" mean that a combination of PlaceId+Loc has that specific DayId?

Searching in RegEdit should not be an issue, even if you input wrong search parameters: if it really hangs the system, then I'd look for something more serious than a DLL mismatch. It could be a registry corruption that prevents correct system behavior and might yield to unpredictable issues.

What do you mean with "modification" ?

It seem I overlooked your problem.

It could be that all your problems are within the initial loop.

for(int q=0;q<=4;q++){
for(int j=0;j<=4;j++){
a[q,j] = textBox1.Text[q].ToString();
}
}

try to rewrite it as

var asLines = textBox1.Text.Split(new[] { Environment.NewLine }, StringSplitOptions.None);
for(int q=0;q<=4;q++){
for(int j=0;j<=4;j++){
a[q,j] = asLines[q][j].ToString();
}
}

Let me know the result

What value do you expect to find after reset? Is 0 okay?
Why you don't want to set Value property? Do you want to avoid firing events or there is some other reason?

I just improved the solution to show you how to obtain that behavior in C#.
Anyhow, I encourage you to adopt in VB.NET the same approach C# is using by default.
More, I suggest you to study all the provided links and the Encoding class.

Hi there.

Have you resolved this issue?

I'm glad to have been helpful. :)

Daniele.

That should mean that Me.Controls(sInitCtrlName) returned Nothing
This might be due to Me not being the parent of the label control or sInitCtrlName containing a wrong name.
You should make sure that sInitCtrlName contains the right full name of the label control and which container is the parent of the label control (being it Me or a sub control like a Panel).

Just to be more clear, if the label control is layed inside a sub control of Me (e.g.: "panel1"), you should replace "Me.Controls" with "panel1.Controls". The easiest ways you can determine what is the right control are through the designer window or the "document layout" window.

As an alternative to Me.Controls(sInitCtrlName) you can also use Me.Controls.Find(sInitCtrlName, true), but this will return an array of Control objects, not only one.

More, as a general rule because InitCtrl is obtained dynamically, before using it you should always check for a valid value.

For further details you can look at http://msdn.microsoft.com/en-us/library/system.windows.forms.control.controls%28v=vs.100%29.aspx and http://msdn.microsoft.com/en-us/library/system.windows.forms.control.controlcollection%28v=vs.100%29.aspx

Regards,
Daniele.

Hi.
If you want Count(ID) value for each combination of FILELOGID and RECORDNO then you have to add a GROUP BY clause similar to the last ORDER BY (insert "GROUP BY FILELOGID, RECORDNO" before "Order by FILELOGID, RECORDNO"); otherwise (if you want Count(ID) for any FILELOGID and RECORDNO) remove the last ORDER BY clause at all.
Regards,
Daniele.

Reason for my vote of 1 \n You didn't explain how to obtain that information, more this seems more a tip than an article.

Reason for my vote of 5 \n Simple and tasty! :)

Reason for my vote of 1 \n Sorry but...

Inappropriate or obscure introduction (what "use system applications using C#" does mean?).
Example covers only little part of the concept (two classes have been used and only simplest methods have been pictured, with minimal explanation).
Very basic example that produces no useful results (a blank medium sized image).
Final goal of tip does not justify the tip itself (you can obtain same result without creating such a basic application).

Reason for my vote of 3 \n Hi.
This tip only points in a direction but does not cover details.
You should improve it explaining parameter usage of those methods and add more info about the native structures or enumerations used.

Hi.
I can see that the Conc function expects 6 parameters but only 4 are passed to it; then, the inner SQL uses all the 6 parameters (including the 2 unassigned).

Hi.
You wrote that the exported file is not readable, but the sample code you provided shows only import function.
You should add more details about export process or about importing errors or imported results.

I know :) and I hope it really solved your issue.

Someone did not like this solution.
Can this one kindly explain what's wrong?

OK but...
In the original code, no WHERE clause was present and SupplierCode was present two times inside the SET clause.
Did the error occur due to oneor both of these things, thus fixing them the error was resolved?
If so please mark the solution as correct; otherwise let us kindly know where was the problem.

Hi.
I'm glad I was helpful. :)
About your other issue, have you assigned format "N2" to the DateTime column? This should be the only cause of the problem. Keep in mind that every type works with different format strings: "N2" is valid for some numerical types (like float) but not valid for others. For DateTime you have to use one of the default formats (e.g. "D") or custom formats (e.g. "dd-MM-yyyy").

If you still have problems, I suggest you to post another question on the forums in order to receive the best response possible and to share the solution with anyone else.

Regards, Daniele.

You tell that you cannot call CWnd::UpdateData(FALSE)...
What is the reason you are telling that? Some compiler error? Or simply it seems not working?
Is dir_backup the CWnd (or CDialog, or derived one) object or some other class?

Do you mean a kind of application that shows instead of the usual desktop and/or user login window.. a kind of application that replaces the default windows shell in order for the owner to provide a closed system where users can launch only a limited set of applications?

Or do you mean a user login replacement to customize only the user selection phase?

Yes, You are right, but velvet7 was not asking for the whole solution: he was asking for a way to find the solution by himself.. so I think he has exactly to find how to sort them... in order to complete the process within 7 steps.
I think that article can help him walk this way.

And about limits of humans and computer: this is a topic we can discuss really long. ;)

You are looping j from ChunkSize to 1 and comparing it with World.ChunkSize / 2.
Are ChunkSize and World.ChunkSize in some way related?
What are current values for ChunkSize, ChunkY, World.ChunkSize?

Why are you converting int to bool using Convert.ToBoolean ? You should directly test for the int value using ==,!=,<,>,<=,>= operators !
More.. I see a "switch (l%3)" with only "case 1" and "case 2", so case 0 is ignored: is it correct?

The link you provided requires registration to the hosting site.
Would be better to choose another (lighter) hosting method.

Is there any reference between the two forms? Is one of them the parent or owner of the other? Are their references stored somewhere?
In case none of this conditions are met You can use Application.OpenForms to find a reference to form1.

Then, if listbox is private (or protected) You should make it public (or internal) or add into form1 some method or property to forward access to it, or to its properties.

Your code does not work as expected because ShowDialog makes frm2 modal, preventing the Close call to be reached until frm2 gets closed.
The solution provided by NeelmaniN work around this behavior by displaying frm2 as non-modal.
Beware that as being non-modal, other forms inside the same application can be used while frm2 being still shown.

Compare dates converted to string format is culture dependent, and thus is likely to not work in many cultures

Hi. Your question is not clear to me.
- You say that You need to set focus by pressing "TAB" manually: do you mean that the final user will simply hit the TAB key?
- You say that SetFocus does not work as expected, but the "default function" is working. What is this default function?