In an effort to not recreate the wheel, I thought I would reach out and see if anyone else has done this....
I have a SQL Server table that I want to allow row level, interactive maintenance on. Basically, I want to be able to display the table (or a subset of it based on a filter), allow the user to select a row and then allow the user to maintain certain columns and then update the row in the table. Also allow the user to add rows.
An example set of data might be something like this...Allow maintenance of UserName, Applicationname, ActiveFlag and/or EmailAddress. Also allow inserting a new row with validation.
Has anyone done anything like this in the past?
Thank you