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";