How we make the procedure for insert in sql server
Ask by Rajesh Goswami
Updated 20 May 2011
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.