Hi Dan,

Your code and approach have a number of problems. Please stick with me; I'm
not being critical... just pointing out the facts:

1. In every line where you have [comd.CommandText = ...] you are completely
changing the value of comd.CommandText. That is, each line *overwrites* the
previous value of CommandText. So, when you finally get around to
comd.ExecuteScalar(), the value of comd.CommandText is simply "select
@orderid".

2. The solution to the above problem (of overwriting the value of
CommandText in each successive line) is to concatenate the incremental
values, possibly via +=, and ensuring you add a blank space between each).
But you DON'T want to do that in your situation because of #3 below:

3. It appears that you are trying to create a stored procedure without
creating one (and instead putting all of the T-SQL in your CommandText.
There's no way that's going to work the way you are attempting.

What will work is to do the following:
1. Create a stored procedure that does the INSERT, followed immediately by
SET @orderid = SCOPE_IDENTITY, and returning exactly one result set via
SELECT @OrderID.

Then In your client code

2. Set CommandText = name of the stored procedure

3. Set ComandType = CommandType.StoredProcedure

4. Add to the Command.Parameters collection one SqlParameter object for each
of the parameters in the stored procedure.

5. Finally execute the stored procedure via the ExecuteScalar method (as you
were already trying to do).

The above assumes you have opened a connection etc..

-HTH