public int ExecuteScalar(string storedProcedureName, System.Data.SqlClient.SqlParameter[] parameters) { }I presume that the SqlParameter array must be populated in the calling code. The task is to create five records in a SQL database with four columns. Could anyone give me an example of how to create the calling code that builds up the SqlParameter array parameter?
dbo.InsertEmployee 'HARRISON', 'ANGIE', 'PROGRAMMER', 'IT'Assuming that I get the array passed into the ExecuteScalar method, how do you you call the SQLCommand so that the array is used?