OK, I'm glad you got it working. For some reason, in my last reply, I thought you were inserting rows (silly me) ... that's why I asked about the InsertCommand. But, you're right that it's the UpdateCommand that you needed to fix.

~~Bonnie



>Hi Bonnie,
>
> I tried to use the select command before the update command. The select command is to fill the adapter. I think the problem was with the parameters to be passed. Now the problem is fixed when I declared the right parameters in the UpdateCommand. Thanks for your help.
>
>
>string selectText = "select BATCH_NUM, CLAIM_NUM, CLIENT, ID from Claim_Header_in where Client = Client";
>string updateText = "update Claim_Header_In set batch_num = @BATCH_NUM, claim_num = @CLAIM_NUM, Client = @CLIENT where ID = @ID";