How to insert only some rows?

Question

Sorry for my bad English. I'm using C# WinForms in VS2008 and SQL Server 2008. I have a grid with some rows with Price = null. I want to insert only the rows with Price != null when I update the database without delete the rows with Price = null from the grid. How can I do it? Thank you. Norberto

Norberto Kelijman · Answer

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

Satyanarayan Bajoria · Answer

Hi You can achieve this by creating DataView.

Norberto Kelijman · Answer

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 Wu · Answer

Could you display your souce code?

Norberto Kelijman · Answer

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 Wu · Answer

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