Home All Groups Group Topic Archive Search About

datagridview update with dataset and dataasapter

Author
19 Sep 2006 10:51 AM
mikalush
is anyone know if i can update access database with dataset in the vs
2005 express?

really imortant to me.

i need to know maybe i just wasting my time!

i've a datagridView that get is data from a dataset:

Me.T_1TableAdapter.Fill(Me.T_1DateSet.T_1)

and i try to update it in a bottom-click:

Me.Validate()

Me.T_1BindingSource.EndEdit()

Me.T_1TableAdapter.Update(Me.T_1DataSet.T_1)

and i get the followin error:

Update requires a valid UpdateCommand when passed DataRow collection
with modified rows.

i'll appriciate any help!!!!

Author
19 Sep 2006 1:30 PM
Brian Tkatch
mikalush wrote:
Show quoteHide quote
> is anyone know if i can update access database with dataset in the vs
> 2005 express?
>
> really imortant to me.
>
> i need to know maybe i just wasting my time!
>
> i've a datagridView that get is data from a dataset:
>
> Me.T_1TableAdapter.Fill(Me.T_1DateSet.T_1)
>
> and i try to update it in a bottom-click:
>
> Me.Validate()
>
> Me.T_1BindingSource.EndEdit()
>
> Me.T_1TableAdapter.Update(Me.T_1DataSet.T_1)
>
> and i get the followin error:
>
> Update requires a valid UpdateCommand when passed DataRow collection
> with modified rows.
>
> i'll appriciate any help!!!!

Did you instantiate a New (valid) update command to
Me.T_1TableAdapter.UpdateCommand?