How to use UpdateCommand in DataAdapter

  • Thread starter Thread starter vivek srivastav
  • Start date Start date
V

vivek srivastav

Hi All,
I am slightly confused about using the update adapter and don't know how to
update the dataset using the update command. The table that I want to update
does not have a primary key.
I would greatly appreciate any help.
regards
vivek
 
Can I fill my typed dataset that contains additional columns with
dataadapter?
For eg. if I have a Table with A,B,C column but I have created a dataset
with A,B,C,D column
can I directly fill that dataset using DataAdapter's Fill method.
What about when I want to update that table using the DataSet so created.
regards
vivek
 
If you want to use the DatatAdapter wizard or the commandbuilder, you need a
key. As a general rule, tables with keys are like football games without
beer ;-). You can leave off the key and do a lot of extra work, but the
easiest approach is to add a key.

HTH,

Bill
 
Back
Top