how to create stored procedures

In the object Explorer
Go to your database in SQL
Go to the folder Programmability; Go to Stored Procedure--> Right click on the folder Stored Procedure
and Click on New Stored Procedure.

You will get predefined Variable and Syntax for a Stored Procedure.
Just add your query statements after BEGIN

Once you get successful message for the Stored procedure you created.
Go to the program and check your web.config file for User name and Password for SQL if already exists
If not, give User name and password in web.config
If that is difficult for you.
Just give your connection string in the program it self

SqlConnection conn= new SqlConnection("Server=(local);DataBase=master;Integrated Security=SSPI");
                conn.Open();

and call the Stored procedure

SqlCommand cmd = new SqlCommand("StoreProcedureName",con);
cmd.CommandType=CommandType.StoreProcedure;
cmd.Parameters.AddWithValue("@value",txtValue.Text);
int rowAffected=cmd.ExecuteNonQuery();

Believe me Google[^] is your friend! Use it. Next time, please respect the rules[^]!

2 results returned by this site:
CREATE PROCEDURE (Transact-SQL)[^]
How to create a SQL Server stored procedure with parameters [^]

Hi,

Ref this articles:

1) Views & Stored Procedure in SQL Server 2005
2) Sql Server - How to write a Stored procedure in Sql server
3) How to write a stored procedure in SQL Server Management Studio 2000/2005/2008