using stored procedure in asp.net

Add one line of code to Deepthi Aravind's code
cmd.connection=con(sqlconnection variable not necessary to be con it must be what you have declared)

Hi Savitha Joshi,,,

  Please try this code,

                 SqlCommand cmd=new SqlCommand();
                 cmd.CommandText="Stored Procedure Name";
                 cmd.CommandType=CommandType.StoredProcedure;
                 cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = "Value passed into this field";//Input Parameter
                 cmd.Parameters.Add("@Age", SqlDbType.Int).Value ="Value passed into this field"; //Input Parameter
                 cmd.ExecuteNonQuery();



Regards,
Deepthi

@Manish,

As i have told in my post i have already read that article and that is not enough.. I guess u have not read my post completely..

Hi Savita,

Take the reference of this article.

Using Stored Procedure in ASP.NET