command builder and stored procedure

[nswan]

Hi,

i am returning a dataset by using a dataadapter and a command object that uses a stored procedure. I was wondering if it is possible to use a command builder to perform updates with the data adapter because of the stored procedure? When i try i get an error. Is it because the command builder can't build an update command because of the stored procedure?

Many thanks
Nick

[nswan]

system.data.sqlClient.sqlException : Line1 :incorrect syntax near 'Name'

- this is the error i get when trying to do myDataAdapter.update(myDataset, "policy")

[DevGrp]

Post some more code

[nswan]

ah ha i know what it is!

i have a field in my database table called [first name] (i didn't design the database unfortunately!!!)

the command builder can't cope with putting '[' around the field names so it falls over! I removed the space from this field name and it seems to have now fallen over on [date of birth] field name so i am gonna have to change them all!