Quote:
The above stored procedure occur a problem "Parameter '@PresentJobLocation' was supplied multiple times."
It is quite clear, isn't it?
location_para[0] = new SqlParameter("@PresentJobLocation", delhi);
location_para[1] = new SqlParameter("@PresentJobLocation", kochi);
location_para[2] = new SqlParameter("@PresentJobLocation", mumbai);
location_para[3] = new SqlParameter("@PresentJobLocation", chennai);
location_para[4] = new SqlParameter("@PresentJobLocation", banglore);
You should define the
Parameter once, not more than that.
Look at your
Stored Procedure and check how many
Parameters it expects. Pass those number of
Parameters from
Code behind.