Thanks for the help, Cathi. I decided to just go ahead and open another connection for the rare times that I need to use this method ... there won't be too much overhead. Should have just done it this way to begin with, instead of wasting all day trying to figure out why it wouldn't work. <g>
~~Bonnie
>Bonnie,
>
>Without you using DeriveParameters before setting the transaction, I don't think you will be able to do this. The problem is the method is static so it prevents using the DA associated with a CommandBuilder instance.
>
>>Cathi,
>>
>>Well, I'm not using a DataAdapter in this particular case ... I'm saving changes with StoredProcs, not getting data, so I don't really need to use a DataAdapter. But anyway, this is what I tried but it still gives me the same error:
>>
>>Command.Parameters.Clear();
>>SqlDataAdapter da = new SqlDataAdapter(Command);
>>da.SelectCommand.Transaction = Command.Transaction;
>>SqlCommandBuilder.DeriveParameters(Command);
>>
>>Did I do this wrong? Or maybe this isn't what you meant? Or maybe I'm an idiot? <g>
>>
>>
>>~~Bonnie