Problem using command.parameters

[=?Utf-8?B?Sm9obm55?=]

I need to get data from a sql server database and insert records into a sqlce
database if they do not already exist in the sqlce database. I have written
the code below but I'm getting an error message when the cmd.Prepare() line
is executed. The error message is - "The conversion is not supported. [ Type
to convert from (if known) = int, Type to convert to (if known) =
uniqueidentifie r ]"}

I have compared the ordinal position of each parameter to the SqlDbType and
they all match. I don't have any idea why I'm getting the error message or
how to debug it at this point. Any help would be much appreciated.


cmd.CommandText =
"Insert VMI_CUST (CUST_ID, SHIP2_ID, CUST_NO,
QUICK_SCAN, ALLOW_DUPLICATE _SCANS, SIGNATURE_REQUI RED, " +
"VALIDATE_MANDA TORY_ITEMS, PO_TYPE, CUST_PO,
LAST_CHANGE_DAT E, RELEASE_NO, LAST_SYNC_DATE, COMPANY_ID) " +
"Select " +
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, " +
"'" + Global.CompanyI D + "' " +
"FROM vmi_controls " +
"WHERE vmi_controls.co mpany_id = '" +
Global.CompanyI D + "'"; //+
" AND NOT EXISTS " +
"(SELECT cust_id FROM vmi_cust WHERE
cust_id = '" + drCustomers[x]["CUST_ID"] + "'" +
" and ship2_id =
'" + drCustomers[x]["SHIP2_ID"] + "'" +
" and company_id =
'" + Global.CompanyI D + "')";



cmd.Parameters. Clear();

cmd.Parameters. Add(new SqlCeParameter( "CUST_ID",
SqlDbType.Uniqu eIdentifier));
cmd.Parameters. Add(new SqlCeParameter( "SHIP2_ID",
SqlDbType.Uniqu eIdentifier));
cmd.Parameters. Add(new SqlCeParameter( "CUST_NO",
SqlDbType.NVarC har));
cmd.Parameters. Add(new SqlCeParameter( "QUICK_SCAN ",
SqlDbType.NVarC har));
cmd.Parameters. Add(new
SqlCeParameter( "ALLOW_DUPLICAT E_SCANS", SqlDbType.NVarC har));
cmd.Parameters. Add(new
SqlCeParameter( "SIGNATURE_REQU IRED", SqlDbType.NVarC har));
cmd.Parameters. Add(new
SqlCeParameter( "VALIDATE_MANDA TORY_ITEMS", SqlDbType.NVarC har));
cmd.Parameters. Add(new SqlCeParameter( "PO_TYPE",
SqlDbType.NVarC har));
cmd.Parameters. Add(new SqlCeParameter( "CUST_PO",
SqlDbType.NVarC har));
cmd.Parameters. Add(new
SqlCeParameter( "LAST_CHANGE_DA TE", SqlDbType.DateT ime));
cmd.Parameters. Add(new SqlCeParameter( "RELEASE_NO ",
SqlDbType.NVarC har));
cmd.Parameters. Add(new
SqlCeParameter( "LAST_SYNC_DATE ", SqlDbType.DateT ime));

cmd.Prepare();