How to insert only some rows?

Accepted answer

I got it! public DsPrecios UpdatePrecios(DsPrecios prec) { try { preciosTableAdapter1.Update(prec.Precios.Select("ISNULL(Precio,0) <> 0")); } catch { return null; } return prec; }

Satyanarayan Bajoria16y ago

Hi,

You can achieve this by creating DataView.

Norberto Kelijman17y ago

Original: INSERT INTO Precios (idArticulo, idServicio, idTarifa, Precio) VALUES (@idArticulo,@idServicio,@idTarifa,@Precio) Edited: INSERT INTO Precios (idArticulo, idServicio, idTarifa, Precio) VALUES (@idArticulo,@idServicio,@idTarifa,@Precio) WHERE @idPrecio is not null

Rodick Wu17y ago

Could you display your souce code?

Norberto Kelijman17y ago

May you explain how? I use TableAdapter to update. I tried to edit the autogenerated Insert clause with a Where statement but I get an error. Thank you. Norberto

Rodick Wu17y ago

It seems you can filter these rows that field is null directly when update.