there are some problem to make the procedure for insertion in sql server
How we make the procedure for insert in sql server Rajesh Goswami 2544 26 Oct 2010 there are some problem to make the procedure for insertion in sql server
You can use following link to solve your problem
https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net
This might be helpful for you.