How to use a three-tier architecture to call a stored procedure in Asp.net

The logic layer only needs to pass parameters to the data layer for database operations.
Presentation Layer:
Methedbll BLL = new methedbll ();
Bll. methed (parameter 1, parameter 2 );
Logic layer
Public return type methed (string parameter 1, string parameter 2)
{
Metheddal Dal = new metheddal ();
Dal. methed (parameter 1, parameter 2 );
}
Data access layer
Public return type methed (string parameter 1, string parameter 2)
{
Sqlconnection con = new sqlconnection (connection string );
Sqlcommand cmd = new sqlcommand ();
Cmd. Connection = con;
Cmd. commandtext = "Stored Procedure name ";
Cmd. commandtype = commandtype. procedure;
Cmd. Parameters. Add (add parameters );
Cmd. Parameter ["parameter name"]. value = parameter 1;
...
Con. open ();
Cmd.exe cutenonquery ();
Con. Close ();

}