Pass parameter to IN clause in SQL Server

Problem:

Suppose you have a query statement (either in Store procedure or Sql state) something like:

SELECT * FROM
myTable WHERE
Field IN(@DelimiterString)

and you want to execute this by passing a delimiter string '1, 2, 3, 4' to execute the query. Unfortunately, you can't do this. You will get error message "Conversion failed when converting the nvarchar value 'xxx,xxx' to data type int."

Solution:

There are several solutions to this problem something like split the value and save to temp table and read them back in IN clause. But i would like to introduce a simple solution by using dynamic sql. I may transform my query to:

exec('SELECT * FROM
myTable WHERE
Field IN(' + @DelimiterString + ')')

Finally, call your store procedure or sql statement accordingly with your delimiter parameter

Pass Multiple Parameters to a Thread in C#

I think it would help someone working with Thread in C#. I found a good article at CodeProject:

Introduction

Have you wondered how you can send a parameter to a C# thread? Have you thought of using anonymous method calls and outer-variable semantics when you put a function in C# thread? If these questions interests you then you are at a right place to read the article further.

Background

I had a simple scinario of creating a C# thread then send a function that takes multiple input parameters and output a single value. I have been searching over net to find a help on that but could not find many. However, I have figured out a way to do that and thought of sharing the idea with other.

Using the code

Here is a sample code to create C# thread then send-in a delegate to the thread that casts a normal C# function and takes two input parameters. We also return an output from the same function when the thread execution is complete.

This sample has 3 simple C# projects.

PROJECT1: First project is a C# class library and has a one class inside. This class has a single function which takes two int input. The logic for this function is to multiply 'A' with 'N' times where 'A' = First input parameter and 'N' = second input parameter. Then it returns the calculated value to the caller. Following is a code snippet for that.

Collapse Copy Code

public class Thread1
{
   public double Multiply(int lOpr1, int lOpr2)
   {
       double retVal = 1;
       for (int i = 1; i <= lOpr2; i++)
       {
           retVal *= lOpr1;
       }
       return retVal;
   }
}         

PROJECT2: This project is a C# class library and also has a single class with a single function that takes two int inputs. The logic for this function is to add 'A' with 'N' times where 'A' and 'N' are input parameters to this function. This function also returns the calculated value to the caller. Following is a code snippet for that.

Collapse Copy Code

public class Thread2
   {
   public double Add(int lOpr1, int lOpr2)
   {
       double retVal = 0;
       for (int i = 1; i <= lOpr2; i++)
       {
           retVal = retVal + lOpr1;
       }
       return retVal;
   }
}

PROJECT3: This is a windows forms project with three text box and a button. On the button click event we will write a code to create two threads to call the above two class' that are to be executed within its own thread. (huh.. catching up with multithread). Following are the steps to do:

1. Declare two local variable and get the user input values in it.
2. Declare local variables to receive output value
3. Create an instance of a class from Project1
4. Create first thread thereby cast the above instance as a anonymous method to a type ‘delegate’. We assign the local variables created in step 1 as inputs to the anonymous method. This technique is called outter-variable semantics. We also assign a local variable to receive the return value - all in one step.
5. Start the first thread
6. Repeate step 3 to 5 to create second thread for the class from Project2
7. This step is to check whether both threads are done with the execution. If so write the output values to a text box.

Block of code for the button click event:

Collapse Copy Code

using System;
using System.Threading;
namespace MainThread
{
  public partial class AppOne
  {
  private void btnMultiThread_Click(object sender, EventArgs e)
   {
   //1
   int lOpr1 = Int32.Parse(txtInput1.Text);
   int lOpr2 = Int32.Parse(txtInput2.Text);
   //2
   double getmul = 0;
   double getadd = 0;
   //3
   Thread1 ClsMultiply = new Thread1();
   //4
   Thread MulThread = new Thread(delegate()
       {
       getmul = ClsMultiply.Multiply(lOpr1, lOpr2);
       });
   //5
   MulThread.Start();
   //6
   Thread2 ClsAdd = new Thread2();
   Thread AddThread = new Thread(delegate()
       {
       getadd = ClsAdd.Add(lOpr1, lOpr2);
       });
   AddThread.Start();
   //7
   while (MulThread.IsAlive || AddThread.IsAlive)
        Thread.Sleep(1);

   txtOutput.Text = "Addition of " + txtInput2.Text + " Times of " + txtInput1.Text + " = " + getadd
       + " ||| Multiplication of " + txtInput2.Text + " times of " + txtInput1.Text + " = " + getmul; 
   }
  }
} 

Remember to notice that, we can send any number of input parameters to a called method using this technique. Hope, you find this informative and simple to understand.

How to remove or ignore Document Type Definition (DTD) declarations/ Doctype from XML Files using C#

If you want to read an XML file and XML file itself has reference to DTD file or schema file. You may get error if you do not referent them correctly. On the other hand, sometime it is not necessary to have it for reading purpose. You might want to remove the Doctype declarations. The following code should help you to remove Doctype or ignore Doctype
private void Remove_Doctype_From_XML(String strXmlFile)
{
try
{
XmlDocument XDoc = new XmlDocument();
XDoc.Load(strXmlFile);
XmlDocumentType XDType = XDoc.DocumentType;
XDoc.RemoveChild(XDType);

//... Proceed reading

//...Or Saving to file
XDoc.Save(strXmlFile+ ".xml");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}

Snippet Designer Visual Studio 2008

The Snippet Designer is a plugin which enhances the Visual Studio IDE to allow a richer and more productive code snippet experience.

http://www.codeplex.com/SnippetDesigner

Load image/rotate image in Canvas tag (support only firefox)

How to load an image in a canvas tag?

Start unpretentiously with an empty canvas tag:



Now the javascript. Two variables to store a handle to the canvas element and the 2D context of the canvas:

var can = document.getElementById('canvas');
var ctx = can.getContext('2d');

Now let's load an image into the canvas. Using the new Image() constructor you can create an image object, then set its src property to point to the location of the image file. Then set an onload handler for the image which is an anonymous function to be called when the image is done loading. There you put the image inside the canvas using the drawImage() method of the canvas context.

var img = new Image();
img.onload = function(){
can.width = img.width;
can.height = img.height;
ctx.drawImage(img, 0, 0, img.width, img.height);
}
img.src = 'zlati-nathalie.jpg';

You can also notice how the dimensions of the canvas are adjusted to match the dimensions of the image.
How to flip the image upside down

The canvas context provides a rotate() method. The rotation always happens around the top left corner of the image, so we first translate() the image to the bottom right. This way when the image is rotated, it fits back into the canvas. (There is also a one pixel correction, I have no idea why, just saw that the image wasn't flipping exactly otherwise). Assigning this functionality to the onclick:

can.onclick = function() {
ctx.translate(img.width-1, img.height-1);
ctx.rotate(Math.PI);
ctx.drawImage(img, 0, 0, img.width, img.height);
};

C'est tout! Once again, the demo is here.

Configuring Multiple Sitemaps in .NET

http://itechtalk.wordpress.com/2007/12/07/configuring-multiple-sitemaps-in-net/