Dataadapter, Sqlcommand, Update and Transaction

Does it make sense to use a transaction to handle updates when already using a dataadapter, a dataset and a datagrid with a sqlcommand.update and sqlparameters that update the records?

In other words, generally speaking, is it overkill to use a transaction on top of the controls, and will the dataadapter essentially do the same thing as a transaction would?

And suppose I wanted to use a non-default isolation level, e.g. isolationlevel.serializable, would that affect whether a transaction is needed?

Thanks in advance.Start Free Trial