how to call a stored procedure in asp.net at run time

create procedure SP_Example(@var1 varchar(20))
As
Begin

Select Column1 ,Column2,Column3 From tempTable where Column1= @var1

End

SqlCommand Cmd;
       SqlDataReader dr;
       SqlConnection Con = new SqlConnection("Your connection String");
       Cmd = new SqlCommand("SP_Example", Con);
       Cmd.CommandType = CommandType.StoredProcedure;
       Cmd.Parameters.Add("@Column1 ",SqlDbType.VarChar).Value="D025";
       Con.Open();

       while(dr.read())
       {
       Response.Write(dr[0].ToString()+" "+dr[1].ToString()+" "+ dr[2].ToString()+"\n");
       }