How to call a sp in asp.net?

Below code may help you out :

string connectionstring = "what ever"
SqlConnection conn = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_to_be_called";
cmd.Connection = conn;

To add the parameters :

cmd.Parameters.Add("@id_of parameter",SqlDbType.Int).Value = value;

Hope this helped.

All the best !

You have not mentioned whether you are using C# or VB.Net.

However....see here[^] for a sample in VB.Net.