Preferred way to do "update row, or insert if it doesn't exist" using TableAdapters in dataset desig

[H5N1]

hi there

the topic says it all.

I have a outer join select statement in tableadapter that populates
GridView, I want to make it updatetable, so I need to provide an update
command for table adapter.
the problem is that not all rows in gridview exist in database (since
it's an outer join) so I want to UPDATE statement to insert the row if
it doesn't exist.

What's the best practice?

thanks

 

[Guest]

The Sql "Pattern" for this would be (pseudocode)

IF NOT EXISTS( SELECT PrimaryKey from table where primaryKey=@primarykey)
BEGIN
INSERT INTO TABLE ---etf
END
ELSE
BEGIN
UPDATE TABLE SET .... etc
END