>

>public int ExecuteScalar(string storedProcedureName, System.Data.SqlClient.SqlParameter[] parameters)
>{
>
>}
>

>

>dbo.InsertEmployee 'HARRISON', 'ANGIE', 'PROGRAMMER', 'IT'
>

You need to know the parameter names:

SqlParameter[] params;

params[0] = new SqlParameter("@Param1","Harrison",SqlDbType.Char);
params[1] = new SqlParameter("@Param2","Angie",SqlDbType.Char);
params[2] = new SqlParameter("@Param3","Programmer",SqlDbType.Char);
params[3] = new SqlParameter("@Param4","It",SqlDbType.Char);


Or something similar.

BOb