Gridview insert/update

[JasonT80]

I have populated a gridview using a LEFT OUTER JOIN query against a calendar
table. This creates dated records on the gridview where no records exist in
the data table. I need my gridview to be able to insert a new record on
update if none exists.

How can I do this?

Thanks!
Jasont80

 

[offwhite]

Are you using a Table Adapter?

An approach I would use would be to bind the update statement to a
stored procedure. In that stored proc you could check if the item
exists and choose to do an insert/update as needed.

Alternatively, I would also consider using a ObjectDataSource which I
find is easier to manage. You tag the class as a DataObject and the
various methods as Select, Insert, Update and Delete methods. In those
methods you can run any ADO.NET routine to do what you gotta do.

You can read more about it here...

http://msdn2.microsoft.com/en-us/library/57hkzhy5.aspx