01-08-2012 The order of the parameters collection of an OleDbCommand must match the order to which those parameters appear in the SQL statement. Otherwise the .net framework will try to fill the parameters in your SQL statement according to the order of parameters in the OleDbCommand.Parameters collection. This can cause an Data type mismatch in criteria expression. Exception if the data types mismatch or at worst, if those data types ma...
Using Short-Circuit Condition Evaluation in VB using AndAlso and OrElse
02-07-2012 Normally, a programming language stops evaluating a composite condition when it finds one of following scenarios. (Condition 1) AND (Condition 2) Since the above composite condition to evaluate to true, both condition 1 and condition 2 have to evaluate to TRUE. If the condition 1 evaluates to FALSE then it is obvious that the whole condition is going to evaluate to FALSE Regardless of the condition 2. Therefore, usually ...
How To Use OpenFileDialog In WPF
WPF has it's own encapsulated version of OpenFileDialog. You can find this under Microsoft.Win32 namespace. Sample code:
What is Go in SQL Server and the Importance of Using Go
25-05-2012 Go is not a SQL or Transact SQL command. Go is a command recognized by sqlcmd and osql facilities provided by SQL server studio. Go specifies an end to a particular SQL batch. Once the parser interprets a Go, that block is considered completed and the following SQL are considered as new batch till the parser finds a new Go. For example, even though following code isn't syntactically wrong, it won't work because a create pr...
Computer Hardware - Memory : Static RAM Vs Dynamic RAM
2008-12-10 Random Access Memory plays a crucial role inside a computer. RAM is where the processor keeps the data it needs to work. The computer always has to load necessary data into the RAM because the speed of hard disks is very low for processor to work with. Actually even the RAM is not fast enough for the processor so computers use many types of memories in different places such as cache or registers for different purposes. The purpose of...
ILT - How to bring your window (form) to the top C#
2013/04/11 How to bring a window (form) to the top? Or how to make your window active from the code? Simply: call the Activate() function (method) of your form instance. Menol ILT
ILT - Divide and Conquer Strategy - Why it is so powerful
08/02/2013 Divide and Conquer is a very interesting and effective strategy that has been used by many technical experts, leaders, mangers, and warriors through out the world for many years. Following is a story of the famous Sri Lankan king Dutugemunu. Apparently he learnt the lesson from an old woman! King Dutugemunu was fighting his opponent, King Elara. During these days, the king used to go walk among general public in disguise to le...
/// Stops asp.net from encoding the source HTML string.
public static IHtmlString HTMLRaw(string source)
return new HtmlString(source);
call this function whenever you want asp.net NOT to encode the string.
Note: You can use <%= and %> tags to avoid encoding as well.
StackOverFlow has become a popular site over the years. This unfortunately has given wings to their owners and senior members who beleive they have an almighty power to control anything a junior/new member says.
StackOverFlow is utilizing an interesting strategy to maintain their site at ZERO cost. They have introduced a points system according to which people with more points get the almighty power.
And the most stupid thing is that they give “MORE” points when someone “EDIT” or “CRITICIZE” someone else s comment/opinion.
This has made a massive circle of so-called “senior” guys who will find something in a relatively “junior” persons post.
Basically, if you are new to the site, your post will be “EDITED” so many times since you publish it.
Don’t get me wrong this DOES NOT mean that those senior guys give you a solution. Oh No!
All they do is “EDIT” your post!
They will find something, a spelling mistake most of the time.
They are also good at finding a similar post and then criticize your post saying it’s a “DUPLICATE”
The most funny thing is that you cannot even complaint!
Because guess who edit complaint forum? Yeah the SAME SENIOR GUYS
read more about my experience below…
It is very unprofessional to go and edit someones’s post unless they have misused the site.
Every time I submit a question, the first thing that happen is some “superior” guy delete a word or two TO GET HIS/HER NAME IN THE POST.
IT’S VERY CLEAR THAT PEOPLE DO THIS TO GET THEIR NAME EVERYWHERE.
What’s wrong with saying thanks to other professionals for spending their time to consider my matter?
The usual answer for this is that deleting “Hi” and “Thanks” makes the question “Clear”
Seriously? How can deleting most human friendly one or two words from a post and adding a comment to justify that act can make the post “clearer”???
It only makes IT pros look like “geeks” I’m sorry but not all professionals are “geeks” there are people who knows how to have a balanced life.
Perhaps if you guys stop editing others “Thanks” out may be you can have one too.
Many thanks for your time.
p.s. Now, if you can, tell me how my first “Hello” and last “thanks” lines made this post “unclear”?
I CHALLENGE SUCH “SUPERIOR” EDITORS TO RESPECT MY OPINION AND ANSWER THIS RATHER THAN DELETING (OR TOUCHING) THIS POST
Thanks again. (“You can chose to be a geek but you were born human” – a quote)
How to avoid detecting substrings, how to check for perfect substrings, avoid detecting substrings, avoid detecting substrings when checked for substrings.
Today I needed to find if a string is contained within a string.
So I used the most straight forward method (I used SQL but this works for any language)
declare @msgsToSkip varchar(max) = ‘geoLocation,statusUpdateCheck,forceClose’;
declare @msg varchar(max)= ‘statusUpdate’
if(charindex(@msg, @msgsToSkip) > 0)
print ‘not found’
Problem – as you can see, this code is written to messages with caption as either “geoLocation”, “statusUpdateCheck”, or “forcedClose”
But I also receive a message with caption “statusUpdate” this is different to “statusUpdateCheck” and must be allowed but obviously the code returns true for statusUpdate as it is a substring of statusUpdateCheck.
Simply make each word dirty by adding a character to it. It could be any character as long as you keep the code consistent. In more simple words, simply add a character to the string you are
Looking For and the string you are Searching In.
This is the fixed code
declare @msgsToSkip varchar(max) = ‘geoLocation-,statusUpdateCheck-,forceClose-’; — <– Notice that a ‘-’ is added to make each word dirty
declare @msg varchar(max)= ‘statusUpdate’
if(charindex(@msg + ‘-’, @msgsToSkip) > 0) — <- Notice the + ‘-’
print ‘not found’
This will not detect statusUpdate as statusUpdateCheck because at the checking time, the code sees statusUpdate as statusUpdate- and it is not a substring of statusUpdateCheck (note that statusUpdateCheck is now statusUpdateCheck- but it’s the ‘-’ in the statusUpdate that does the trick.)