I have solved the problem :
I changed the code as :
cmd.Parameters.Add("@EmployeeID",EmployeeID);
cmd.Parameters.Add("@ReasonOfChange",ReasonOfChange);
And also
cmd = new SqlCommand(strQuery,Connection);
Previously Connection is missing.
Thanks for your valuable inputs.
1
solved How to write Parameterised Query in .NET Framework 1.1