Tracking user and Remote access in windows form application C# Sql Server

I have two questions in Windows Application.

  1. I My application is using by two people and i want to track which user has saved this data and which user has edit it.I need to logged in user activity.

Do I need to pass login id to all forms and save there?Is there any other way?

  • MSSQL updating rows using MSSQL Server Management Studio UPDATE statement fails inserting UTF8 characters
  • Connecting to a SQL 2008 R2 server through XAMPP
  • What is API Usage?
  • SQL update statement is executing but updating with incorrect values
  • Access internal MSSQL database with php/laravel
  • SQL Server 2008 XML Empty Node
    1. I Installed my Application and Sqlserver database on one computer/machine. How the other user will use the same application from his computer in same office.

  • Subquery using Exists 1 or Exists *
  • Can I recreate a temp table after dropping it?
  • Unsure of WITH CHECK clause when adding a constraint
  • Count need to get for only particualr item in SQL Server
  • Fluent NHibernate bulk data insert
  • get all day of month then mapping data to specific date
  • One Solution collect form web for “Tracking user and Remote access in windows form application C# Sql Server”

    If I understood your questions

    1/Do I need to pass login id to all forms and save there?Is there any other way?

    You must implement the features of user registration and authentification , in login phase the program will check the existence of the user ( login, password) in your database (I assume your database is ready) . If the user exists, you will have many choices

    1. Put the user object as a static object
    2. serialize the user object

    So you can check the identity of the user during the execution of the program

    2/ I Installed my Application and Sqlserver database on one computer/machine. How the other user will use the same application from his computer in same office.

    You must put your machine as a server machine and allow the office members to access to it and to your application by remote connection

    Perhaps it helps you 🙂

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.