Security :: Capture The Value Of The Username And Insert In A SQL Server 2008 Database Table
Jun 30, 2010
I am using ASP.Net 4.0/Visual Studio 2010. However, I think it would be the same if it was ASP.Net/VB.Net 3.5. I am inserting three form filed values into a database table. I have placed a LoginName Control on the page and the login name is properly displaying. I am using forms Authentication and it is set up properly in the web config file. I simply want to insert the logged in username value into the database table so I can track who created the records. I am happy to be able to insert the UnserName or the UserID value. I assume both of the values are derived out of the aspnet_Users table. Being able to insert either one would be fine but I believe UserID would be better because it will always be unique.
View 8 Replies
Similar Messages:
Oct 26, 2010
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server.I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......?i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise.
View 2 Replies
Aug 28, 2010
I have a table setup in the database for users who are basically going to create a classified listing. How can I setup a diagram that would easily create a table relationship with the Users table, so that it automatically inserts the users username when they submit a new ad? If so, how? I've tried adding a UserName row to my table and creating a relationship with the Users table "UserName" row, but it wasn't accepting the relationship when I tried to save the diagram...apparently because the UserName row in the Users table isn't a primary key?
Also, one this is setup, what's the best way to provide the user a way to see a list of their ads and have the ability to edit them?
View 1 Replies
Mar 24, 2010
I have set up security on my ASP.NET site and currently have 1 user (soon to be more!). I would like to send the logged-on user's username to a variable, to input this value to a custom-designed stored procedure on my SQL database (for recording search statistics).Does anyone know how I can harness the current logged-on users username? I am using VB. Will the following achieve the result?session(username)If so, how do I implement this? I tried using "Current_User" in the SQL stored procedure, but obviously this did not record the ASP.NET user. Also, if the current user has not logged onto the site, I would like the "username" value to be "annonymous".
View 10 Replies
Mar 19, 2010
I want to capture when a user logs in and his username. I am using a login control inside a anonymous temp[late of a login view control. on the logedin event of the login I have this code:
Dim log As Login = CType(sender, Login)
If Not log.UserName = "bcweed@live.ca" Then
Dim mil As MailUtility = New MailUtility
mil.ClientLogin(log.UserName)
End If
but log.username is always empty and so is the page.user.identity.name and the page.user.identity.isauthenticated always returns false this even thouhgt this is the LogedIn event of the login and also I "just loged in" I really did.. is there a way to capture this is the global.asax?
View 4 Replies
May 7, 2015
I am using this tutorial, and my question is how can I save it to database after I capture? in ASP.Net
View 1 Replies
Aug 17, 2010
I have an excel sheet that contains around 30,000 rows and 18 colmns. These no of rows and columns may increase in future. I need to read all these records from excel sheet and insert into a table in sql database. For reading the excel book I am using Oledbconnections. The possible solutions I have known as per my knowledge, to insert the data are
1. To insert one record at a time which makes 30,000 database hits. How will this affect the performance?
2. To use liked servers - bu this is not working for me.I do not have database permissions to use linked servers. So, the only option i have is the first one.
View 2 Replies
May 29, 2010
I was reading about "Change Data Capture" functionality in SQL Server 2008. It sounds awesome. My implementation of it would be in a website environment where ASP.NET pages use SQLDatasources to do inserts, updates and deletes. When enabling "Change Data Capture" can you store additional information supplied from the website like a UserID, SessionID, UserRole etc so you can identify who did the insert, update or delete? [URL]
View 1 Replies
Mar 24, 2010
With windows and sql server accounts, I can access the logged in user with functions like: user_name() or suser_sname().Can I access the user that is logged into asp.net in the same way?
View 1 Replies
Aug 11, 2010
I have a CreateUserWizard control to be able to allow an anonymous user to create an account. Provided that all entered information is correct that the user enters, a new account is created for him/her. But also, when this user is created, I want to [b]also[/b] add the username to another table in my ASPNETDB database. How exactly can I "tap" into the event that creates a user and adds it to the appropriate tables (aspnet_Users, Members, etc.) and make it add the username to yet another table?
View 1 Replies
Dec 15, 2010
I have a gridview on a page that allows a user to edit the data. I need to be able to insert the current user's username in the database table whenever they click update on the gridview. I am new to coding and im strugling to get this project done.I am using MSSQL Server 2005 and VB in the codebehind.
View 2 Replies
Jan 27, 2011
I currently write all log4net events to a database, and it seems to work just fine. To capture the logged in user account I use this piece of code:
HttpContext context = HttpContext.Current;
if (context != null && context.User != null && context.User.Identity.IsAuthenticated)
{
MDC.Set("user", HttpContext.Current.User.Identity.Name);
}
The code seems ok, except for events that have no user context associated with them (ie. a user on our public web page). In that case the log4net capture seems to sometime write the last logged in user account (bad) and sometime write a null (good). Anyone got this feature to work reliably in all cases? I believe I saw a note that MDC is no longer a recommended feature to use, but I wasn't able to find any alternatives that are recommended.
Note: I find it odd that MDC is set with an account name, but never cleared if no user is active. That could be part of the problem. However, I didn't find any MDC code extracts that also clear the username.
View 3 Replies
Mar 4, 2010
I want to compare username and password store in database table to the textbox values for that I am using session variable. How to use dataset for session variable?
How to retrive values from database table using dataset?
View 4 Replies
Mar 10, 2010
I got a username and password field which made by myself and a User database which is all manually made
So now I wish to know how to authenticate user using the username and password data enter by the user and match with the database data to verify user is a member and login?
For what i know, the code should be something like this
SELECT UserName, Password FROM dbo.User WHERE UserName - @UserName
@UserName = ?
How do i assign the value from my username text field to @UserName?
View 3 Replies
Feb 16, 2010
so I will admit this is a pretty stupid question. To my defense, I have never done it before. So take pity. I followed Joe Stagner's video on using the built-in authentication. Now, I would like to query a database using VB.net codebehind to verify if the user exists. I am clueless. Yes, I have a connection string already.
[Code]....
View 15 Replies
Jul 29, 2010
I am using SQL server triggers to do the database auditing for my website. My problem is that I cannot pass the username who manipulate data into the Audit table. The username saved into Audit table is always the SQL server user name which is part of my connection string. Is there any better way to handle this?
View 6 Replies
Mar 26, 2010
How do I use the FormsAuthentication.Authenticate(Username,Password) method to match against the generated Database?..since as far as I have read, it matches the values against the Web.config.
View 1 Replies
Sep 8, 2010
i would like to do a project that enable to capture photo from webcam, and record audio from microphone store to database. but the photo and audio store in folder and the database only store the filename. later i set the path and its play back the audio and show the photo.
View 2 Replies
Oct 8, 2010
im new to trigger concept
when i insert data in a table [DSR_OUT_PRO] data get enter in another table ie [trg_Insert_DSR_OUT_PRO] but 2 times..
Is it ok, or something is wrong..
View 1 Replies
Nov 18, 2012
After filling all the required information in any registration form, I want to capture the Date of submitting the form in Sql Server 2005 how to achieve this using Asp.net C#?
My insert query is:
con.Open();
SqlCommand command = new SqlCommand("insert into data (UserID,Name,Email,Country,Date,Multiselect,Gender,Pincode)values('" + txtuserid.Text + "','" + txtname.Text + "','" + txtemail.Text + "','" + ddlcountry.SelectedItem.Text + "','" + s1 + "','" + lbmultiselect.Text + "','" + rblgender.Text + "','" + txtpincode.Text + "')", con);
command.ExecuteNonQuery();
View 1 Replies
Jun 29, 2010
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 Replies
Aug 20, 2010
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 Replies
Mar 3, 2010
why when i'm loging in the loginName turns in to the name of my server and not the name of the username ... ? give some tutorials or articles about loginview.
View 2 Replies
Jul 21, 2010
[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 Replies
Mar 21, 2010
I want to pick the date from the table(Oracle) & want to insert it into the another table. In Pic see,I am picking the date of the second row. I convert the date to the dd/MM/yyyy format
Code:
TxtHiddenCtrl .Text = DateTime.Parse(ds.Tables[0].Rows[0]["FROM_DATE"].ToString()).ToString("dd/MM/yyyy");
Code:
?TxtHiddenCtrl.Text
"05/10/2001"
If I dont convert the date then
Code:
TxtHiddenCtrl.Text =ds.Tables[0].Rows[0]["FROM_DATE"].ToString()
"10/5/2001 12:00:00 AM"
I convert the date!
Now when i save the date into another table
Code:
cmd.Parameters.Add("@p_FROM_DATE", TxtHiddenCtrl .Text );
Error is dere not a valid Month!Why the error is coming?Its a valid month?
View 15 Replies
