Save (Insert) Active Directory logged in user name in database using C# and VB.Net in ASP.Net

Hi tjbowesfolio,

To get AD username try with below codes.

Get Username with domain

 string userName = new System.Security.Principal.WindowsPrincipal(System.Security.Principal.WindowsIdentity.GetCurrent()).Identity.Name;

Or

string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;

Get only Username

string userName = Environment.UserName;

Or

string userName = Environment.GetEnvironmentVariable("USERNAME");

To get current datatime use DateTime.Now.

Then write your code to insert in database.

In case this is of benefit for others, achieved as follows. 

HTML

<asp:TextBox Style="display: none" ID="txt_LogUser" runat="server" /> 
<asp:TextBox Style="display: none" ID="txt_DateSubmitted" runat="server" />
<asp:Button ID="Button_agree" CssClass="button" runat="server" Text="I agree" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"  ConnectionString="<%$ ConnectionStrings:Constr %>"
    InsertCommand="INSERT INTO [tbl_log_users] ( LogUser, DateSubmitted)  VALUES (@LogUser, @DateSubmitted )">
    <InsertParameters>
        <asp:ControlParameter Name="LogUser" ControlID="txt_LogUser" PropertyName="Text" Type="String" /> 
        <asp:ControlParameter Name="DateSubmitted" ControlID="txt_DateSubmitted" PropertyName="Text" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>

VB.Net

Protected Sub Button_agree_Click(sender As Object, e As EventArgs) Handles Button_agree.Click
    txt_LogUser.Text = Environment.GetEnvironmentVariable("USERNAME")
    txt_DateSubmitted.Text = DateTime.Now.ToString()
    SqlDataSource1.Insert()
    Response.Redirect("page.aspx")
End Sub

C#

protected void Button_agree_Click(object sender, EventArgs e)
{
    txt_LogUser.Text = Environment.GetEnvironmentVariable("USERNAME");
    txt_DateSubmitted.Text = DateTime.Now.ToString();
    SqlDataSource1.Insert();
    Response.Redirect("page.aspx");
}