Thanks for the reply Andrew. But it is not assigning 1 0r 0 value to @Access parameter. I dont know why. Let me figure out other way. 

Hi Andrew,

Thanks for the prompt reply. Actually Stored Procedure is working fine if i hardcode @Access value to 1 or 0.

What i need is how to find that current state of checkbox is 1 or 0? and in which event i need to put this foreach loop?