none
off the shelf tools for insert/update/delete to sql tables

    Question

  • Hi. I read articles like this one when looking for guidance on setting up tools for simple sql table maintence. https://www.aspsnippets.com/Articles/Pass-multiple-records-rows-to-a-Stored-Procedure-in-SQL-Server-using-C-and-VBNet.aspx .  But really wish I can find a one size fits all (abstract) approach to allowing a user to select a table and do simple maintenance to it.  Without custom code for each table.  Does something like that exist?  I may need an option now and then for specific biz rules as they apply to a specific table but overall I just want a one size fits all tool that allows the user to pick which table he wants to update, presents the appropriate grid and allows user friendly updates to happen.  

    • Edited by db042190 Monday, April 24, 2017 11:06 AM adding word abstract
    Monday, April 24, 2017 11:05 AM

All replies

  • I just got word from my previous employer that they used asp.net dynamic data link in VS 2010.
    Wednesday, April 26, 2017 5:54 PM
  • Please post questions related to ASP.NET applications in the ASP.NET forums.

    You can build an SSMS-like application by using a combination of SMO (for DDL) and ADO.NET DataSet (for DML). You really don't need any other tools.

    Michael Taylor
    http://www.michaeltaylorp3.net

    Thursday, April 27, 2017 1:53 PM
    Moderator