Post reply

Building Application to connect with SQL Server Tables and Edit records

  • January 18, 2023 at 7:02 pm

    #4139133

    Hello,

    I would like to build a Microsoft-based Application to use SQL Server Tables, and with this application there needs to be the ability to edit, delete, update etc records (in SQL Server). Other than Visual Basic, what other Microsoft Tools/languages are suitable ?

    Thanks !

  • January 18, 2023 at 7:29 pm

    #4139140

    .NET?

  • January 18, 2023 at 8:22 pm

    #4139167

    That's too broad a question.

    Application? What type of application?

    Office-based application? Desktop application? Web application? Mobile application? Console application?

    Even knowing that, it will be hard to advice, because we don't know your skillset, nor your requirements or available resources.

    Almost any programming language will be able to connect to SQL Server.

  • January 18, 2023 at 8:48 pm

    #4139170

    The purpose of the Application is to provide two different forms (based on the Permissions level of the one using it):

    1. For normal users to use it as a form to input records into the SQL Server Database tables.
    2. For Admin users to use it as a form to manipulate records in the SQL Server Database tables.

  • January 18, 2023 at 9:19 pm

    #4139180

    Access works.

  • January 19, 2023 at 1:39 pm

    #4139550

    I'm a fan of C#.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 8, 2023 at 5:24 pm

    #4147216

    I agree with Steve Jones. Based on what you say I think using linked tables in Microsoft Access linked to the tables in SQL server will do the job for you with very little development work. You can edit the tables through the links or you can setup forms with the appropriate functionality if more control and features are needed.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply