How do i...how to get the current user of the system and store to database?

Question

1.00/5 (1 vote)

See more:

How to get current user of the system

What I have tried:

query = "insert into AllottedLicense  (Department , AllottedLicense,Server,DateAllotted,CreatedBy) values(@Department,@AllottedLicense,@Server,@DateAllotted,USER_NAME())";

Posted 16-Mar-21 21:31pm

Member 15088142

Updated 16-Mar-21 22:24pm

Add a Solution

Comments

Maciej Los 17-Mar-21 4:16am

What system? Database (server) system or loacal computer system?

Member 15088142 17-Mar-21 4:25am

local computer system

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2021-03-16T22:24:00

Solution 1

Your query should do the job!

USER_NAME() and CURRENT_USER should return the same, the name of user, which currently executes the statement.

More at: CURRENT_USER (Transact-SQL) - SQL Server | Microsoft Docs[^]

In case you wanted to get other answer, you need to explain what's worng with your code or what you want to achieve...

[EDIT]

Maciej Los wrote:

What system? Database (server) system or loacal computer system?

Member 15088142 wrote:

local computer system

To get local computer user name, use:

C#

string currUser = Environment.UserName;

and pass it as a parameter into command ;)

Posted 16-Mar-21 22:24pm

Maciej Los

Updated 16-Mar-21 22:37pm

v2

Comments

Member 15088142 17-Mar-21 4:28am

if (row["Department"].ToString() != null && row["AllottedLicense"].ToString() != null)
{
OleDbDataAdapter _oda = new OleDbDataAdapter();
query = "insert into AllottedLicense (Department , AllottedLicense,Server,DateAllotted,CreatedBy) values(@Department,@AllottedLicense,@Server,@DateAllotted,CURRENT_USER())";
//query = "insert into AllottedLicense ALT (Department , AllottedLicense,Server,DateAllotted) values(@Department,@AllottedLicense,@Server,@DateAllotted)'" +
// " INNER JOIN DetailUsage DU ON ALT.CreatedBy = DU.CreatedBy";
_cmd = new OleDbCommand(query, _cnn);
_cmd.Parameters.AddWithValue("@Department", row["Department"].ToString());
_cmd.Parameters.AddWithValue("@AllottedLicense", row["AllottedLicense"].ToString());
_cmd.Parameters.AddWithValue("@Server", row["Server"].ToString());
_cmd.Parameters.AddWithValue("@DateAllotted", dtn);
//_cmd.Parameters.AddWithValue("@CreatedBy", row["CreatedBy"].ToString());
_oda.SelectCommand = _cmd;
_oda.Fill(resultDt);
}
}

this is my code i want to updated created bu column if user updates anything in created by column username name as to store

Maciej Los 17-Mar-21 4:38am

See updated answer.

Maciej Los 17-Mar-21 4:53am

Please, read my answer carefully...
Do NOT post the same content in comments. It's rude!

Member 15088142 17-Mar-21 4:54am

if system is a Database (server) system, how i can get

Maciej Los 17-Mar-21 4:57am

The second statement of my answer is:
USER_NAME() and CURRENT_USER should return the same, the name of user, which currently executes the statement.
What's unclear here?

Member 15088142 17-Mar-21 4:55am

due to network issue it came so many time sorry

Member 15088142 17-Mar-21 5:14am

query = "insert into AllottedLicense (Department , AllottedLicense,Server,DateAllotted,CreatedBy) values(@Department,@AllottedLicense,@Server,@DateAllotted,USER_NAME())";

i have tried but getting an error System.Data.OleDb.OleDbException: 'Undefined function 'USER_NAME' in expression

Maciej Los 17-Mar-21 5:26am

What's database?

Member 15088142 19-Mar-21 0:46am

MBD file database

Maciej Los 19-Mar-21 3:07am

MS Access file... Am i right?

Member 15088142 19-Mar-21 3:15am

yes

Maciej Los 19-Mar-21 3:31am

MS Access database does not store information about user(s). You need to get that value from Environment.

Member 15088142 19-Mar-21 3:36am

Ok Thanks