Hi guys can you pls help me to retrive login name, sql2000 integrated with win2000 server:
i want to display it in windows form using vb.net
sample; you are logged as Drachx

you mean u want to retrive all the logins in sql2k??

Regards
Ganesh

i mean user login, sql2000 is integrated with win2000 server for login,my account name when i log on to windows is drachx, i need to display my login name in wndows form, how can i do it?

Write an API function to retrieve the value from the key -

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon

You can use GetUserName Lib "advapi32.dll" Alias "GetUserNameA" to get the logon username.

Lookout on calling APIs in VB.NET. Hope this helps.

Dim str As String
str = System.Environment.UserDomainName + "\" + System.Environment.UserName

str will Contain the Login name with the domain name.





It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

Also you can use the following code

Imports System.Security.Principal

Dim wp As WindowsPrincipal = New WindowsPrincipal(WindowsIdentity.GetCurrent())
MessageBox.Show("Your login id:" + wp.Identity.Name)





It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

TNX PRADEEP

code works, really appreciate it