oList.Add(new SqlParameter("@PK",PK)); oList.Add(new SqlParameter("@Interviewed", System.DBNull.Value)); oList.Add(new SqlParameter("@LastEvalDate", LastEvalDate));or
oList.Add(new SqlParameter("@LastEvalDate", LastEvalDate)); </i> oList.Add(new SqlParameter("@Interviewed", System.DBNull.Value)); oList.Add(new SqlParameter("@PK",PK));(basically reversing the order).....
SqlCommand oCmd = new SqlCommand("Myprocname", oSqlConnectionObject); oCmd.CommandType = CommandType.StoredProcedure foreach(SqlParameter oParm in oParmList) oCmd.Parameters.Add(oParm);Both work fine...