how to insert value using store procedure

First, please move your post into Forums section.

I know this is not the right place to ask question but just want to help you. Please read this article - http://www.dotnetfunda.com/articles/show/2708/3-tier-architecture-in-aspnet-a-complete-article

This contains the stored procedure code as well as ado.net code to submit a record into the database.

Thanks