how to insert only the New (Added) Rows with a SqlDataAdapter?

[DraguVaso]

Hi,

I know there is some way to select only the new rows (and not the deleted,
changed etc) in a DataGrid, and insert them in the DataBase.

I want to do this by using a SqlDataAdapter.

Does anybody knwo how to doe this?

Thanks,

Pieter

 

[Shiva]

Hi,
Use DataSet.GetChanges(DataRowState.Added) to get the new rows into a data
set. Then invoke SqlDataAdapter.Update() passing the new dataset.

Hope that helps.

Hi,

I know there is some way to select only the new rows (and not the deleted,
changed etc) in a DataGrid, and insert them in the DataBase.

I want to do this by using a SqlDataAdapter.

Does anybody knwo how to doe this?

Thanks,

Pieter

 

[DraguVaso]

Thanks!
Unfortunately I'm using not a DataSet, only a DataTable, hehe :-/
Can you do something like this with only a DataTable too?

 

[DraguVaso]

hehe ok I can do the same with a DataTable
Thanks!
dtblGrid.GetChanges(DataRowState.Added)

 

[Mike McIntyre]

Hi Piete,

This is done through the DataAdapter's Update call e.g.

custDA.Update(updTable.Select(Nothing, Nothing, DataViewRowState.Added))

Excellent advice and sample code is at:

http://msdn.microsoft.com/library/d...conupdatingdatabasewithdataadapterdataset.asp


--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

 

[Cor Ligthert]

Pieter,

Do not forget that the getchanges creates a copy of your dataset.
In this method you have to do an acceptchanges from your original
dataset/table after an succesful update.

I hope this helps?

Cor