I would like my website to fetch the data for username and password from a database in SQL server and authenticate that. I have used a login control in the website.
Presently I can assign username and passwords using the 'login control' from the website administration tool.
I'm trying to make a dropdown list with data available based on the users login name. Heres what I have as my SQL Query in the SQLDataSource:
SELECT Client_Name, Client_ID FROM Client WHERE (Client_Name LIKE '%@Client_Name%')
So say if the login username is "User1" but the database client name is "User1 Steel" I want the dropdownlist to pull "User1 Steel" as the display and Client_ID as the value from the dropdown list.
Well, I have a website with login feature (username and password fields). . I then changed the ID and NAME attributes of the textbox. (I made sure the client Id has changed). How come? Doesn't the browser relate usernames stored in history to the ID of textbox? I'm using asp.net!
View 2 RepliesWould like enquire how to retrieve images from database.I have a table call "Image" with 3 attributes.. ImageID, AlbumID and ImagePath.I want to retrieve the photo and display out at my index page inside a gridview which will display the photos that recent users uploaded.My friend suggested the Eval way, but i have no idea how to do it.
View 3 RepliesI'm developing a web application with ASP.net and Sql Server 2005.
How i can retrive data from database on every seconds basis?
For your information , I have a Server application which will update hardware status (every seconds) into database and
my web client need to retrieve and display out the latest status (every seconds)
I am working to retrieve list of values from database according to the dropdownlist value in view page in asp.net using linq to sql.I am having the dropdown values as static values.I am using table view to display the details.
View 2 RepliesHow to select the month only from the dateTime datatype in sqlserver Express database to asp.net/c# dropdownlist?
View 3 RepliesI'm using Content Management System, DotNetNuke for my dynamic website. DNN itself they have one database, I named it dnnDB. Inside the dnnDB they have the users table which have the list of users. I need to be able to pull this set of information or synchronize to my own database, myDatabase for development purposes. I do not want to incorporate my database into dnnDB, afraid that I may corrupt the system.
View 4 RepliesI am working on Edit operation for dropdownlist box using linq to sql in asp.net mvc.During edit operation i could retrieve it from database but i am not able to restore the selected value back to the database.
View 2 RepliesHow to retrieve the data from the session (Dataset) and save it into a database
[code]...
My issue today is that i have a MySQL Database and am using the security framework provided by the ASP.NET Membership and Role Providers...I override the default methods with my own MySQL.
Now the issue comes in when i someone would like to have their password reset. My application is running entirely on an Intranet so i cannot have their passwords emailed to them. Is there a way i can have this information displayed in any way so that the user can use it to Log Reset, Create Accounts or Recover their lost passwords on an intranet without the administrators intervention?
Recently i had an approach as follows. In my web.config<system.net><mailSettings><smtp deliveryMethod="pickupDirectoryLocation" and my location was a folder on C drive as c:/SavedPasswords. Now i understand this was such a big security threat and thats why i am looking for a better option.
I would have that folder created using my System.IO and then the Mail is dropped into that folder. Then after the process is successful, i tell the user to check into that location and Read its content.
Then there is a global variable that is set to true...meaning that the folder at c:/ has been created. then there is a Method in a certain class that once it sees this variable True, it reads the readers c:/ and deletes that folder "save" if it exists;
I have a small database, with a very small number of users. The passwords were stored as clear as the database was so small and held no sensitive data. The database is now to be expanded and passwords are required to be encrypted. I can change the Password Format in the web.config, but is there a way to change the existing passwords from clear to encrypted?
View 1 RepliesI have a .Net 1.1 app that must be upgraded to 2.0. The application encrypts passwords in the database using MD5CryptoServiceProvider. After I upgraded to 2.0, the MD5 value was different. In the machine.config, the machinekey was set to autogenerate. Is there a way to retrieve this key?
View 2 RepliesI have a gridview code behind like below, and in the aspx page I called it <%# Eval("TrackedUsername") %> which displays a cell for me that has the username. Now, in my code behind, I want to be able to retrieve that data (username) from that gridview1, how can I do that?
[Code]....
I have 2 tables: Users and Accounts. The Accounts table has CreatedBy, UpdatedBy fields for audit purposes.
On my UI I need to display: ABC Inc. was last modified by "John Smith" - where John Smith is the UpdatedBy ID from the user's table.
In my DataContext file I have removed all relationships. Can anyone tell me how to retrieve the username for the foreign key.
What is the difference when retrieving username for the view?
<%= Page.User.Identity.Name %>
or
<%= Membership.GetUser().UserName %>
I could retrieve current username, but how Could I get CurrentUserID. I ma using builtin asp.net membership provider and UserID field is UniqueIdentifier.
View 5 RepliesI have secured my website using Web.Config (authentication mode Forms)
Now I want to create an Admin area where administrator can edit the password.
But how do I retreave password from Web.Config?
Want the password to be displayed in TextBox.
Have found this:
[Code]....
Once the user has authenticated, I would like to base all of the information displayed to the user based on their username. Isn't that saved in the cookie?
For instance, I would like to pull all of their client information using a GridView and have the parameter set to the appropriate authentication information.
How to get the username and password of the user in ASPNETDB. I am using ASP.NET 2.0 and C#.
I have configured the membership provider. I want to retrieve the username and password from the aspnet db?
How do I retrieve the UserName for a logged in user? Membership.GetUser().UserName doesn't work for me - Object reference not set to an instance of an object.I need it to get the associated UserID which my own db tables use as primary keyFurthermore, as I am a rookie is the best approach to achieve this through LoggedIn as below?
[Code]...
I have a formview that is working fine for with the exception of the username is not inserting on a new record. The username is visible on login so I know that is working. I'm attaching my sql code as well as the code behind as I don't know what I'm missing.
[Code]....
SELECT DISTINCT TblSections.SectionID, TblSections.Description
FROM TblSections INNER JOIN
UMG.Users ON TblSections.SectionID = UMG.Users.SectionID
WHERE (TblSections.Description IS NOT NULL) AND (dbo.Users.LoginName = [@Session(UserName)])
ORDER BY TblSections.Description
I have problem in using Session name in the above BOLD WHERE clause.
I have the following code where i enable the user to insert their password to retrieve their username.
[Code]....
But nothing happens, it doesnt work. I want it to do the check and then do something. I am just testing with a label for the time being.
But why does this not work?
how to check if a particular data in the database already, for example, i want to check if a username already exist in database, then the user cant choose that username.
View 6 Replies