I have just created an extra table named AccountDetails with four columns named AccNo,Balance,Transfer and UserId as foreign key to aspnet_userID primary key. I want to display users account and balance whenever the user successfully loged in.
View 4 Replies
I have a web app Which Uses Forms Authentication.
One thing that we want to be able to do on Support is login to a specific users account Via our admin account.
We are using the standard asp.net membership authentication.
The idea would be for the support technition to be able to login using credentials like admin(<Troubled User>) using the Admin Account password
We are using a a Standard ASP.Login Control
The real Issue is that the Me.Page.User.Identity.Name is set to the value on the CtlLogin.Username Property. I need it to be the the Support Login?
Login Control
Code:
<asp:Login ID="ctlLogin" runat="server" DisplayRememberMe="False" Font-Names="Arial Rounded MT Bold" Font-Size="12pt" ForeColor="Black"
MembershipProvider="MembershipProvider" Width="100%" TitleText="" UserNameLabelText="User" VisibleWhenLoggedIn="False" RememberMeSet="True"
PasswordLabelText="Password" EnableTheming="False" Height="35px" >
[Code] ....
Validate User Script
Code:
Dim objstrSupUser As String = ""
'Load the user from the membership provider
Dim strUserName As String = ctlLogin.UserName
If ctlLogin.UserName.IndexOf("(") > 0 Then
objstrSupUser = Regex.Match(strUserName, "(([^)]*))").Groups(1).Value
[Code] ....
I want to display opening balance in page header of the report.
ex :
opening balance :
aaaaa bb 340 2000.00
item brand qty amt
aaaaa bb 34 340
aaaaa bb 34 340
I'm using ASP.NET MVC and I want to authenticate users with their Google or Facebook account
View 4 RepliesWe would like to redirect a user to a different page based on his or her credentials.
In other words, if a user's credentials are authenticated, a user is presented with a dropdown list belonging to his/her group to select from.
So far, it doesn't matter what the user's credentials are, the user is not getting redirected.
[code]....
I have tried looking everywhere but I can't seem to work out how to do the follow:
I am trying to make a page that will display the fields that are asscoiated with the current logged in user:
User name
Secret Question and Answer fields of the authenticated user,
Last Login date of that user
Last Password changed date of that user
When the account was created of that user.
Here is my code so far (I have not attached my code behind file because it is empty)
[Code]....
Also by default it does not display anything, so after the .aspx extension I add .aspx?UserId=1 and it displays the first record on the database. But if I change it to .aspx?UserId=2 or
.aspx?UserId=3 etc, it still displays the first record on the database. Why does it not display the next user name. (I am logged in with admin and it is displaying a user that is in another role group)
I created a user manually using Membership.CreateUser(). User created successfully but as soon user create Logged In User's tasks display. I want to use DisableCreatedUser() some how. or is any method to disable it?
View 1 RepliesI am implementing strightforward membership provider. I do not want new users to be able to login without being approved.
I have tried the setting on the registration wizard called DisableCreatedUser="True" and this does not work.
I also set LoginCreatedUser to False, and the user still gets logged in.
If I look in the SQL membership table, 'IsApproved' is set to 0 for the account, but they can still login.
We have implemented the ASP membership and roles..and we would like to display the users currently logged in and also display the number of users online so we can display that on the page. The list of users woudl only be available to our admins. BUt the number of users will show for everyone.
View 9 RepliesI was wondering if a user logs in using the login controller for asp.net, how do I display the users information in a "My Account" page. Do I simply do that through C# and SQL? Is there something that gets stored when a user logins already so I can return the username anywhere in the project?
View 3 RepliesI have a website that has a login (Like most websites xD) This then obviosly fetches information from a database and loads it on the page. (EG. Welcome "Display Name")
I have designed and coded a application for my site you can use the features from my web on your desktop, I have added a login (required to use the application) and a register. Both login and register work (Fetching information from the database and writing to the database).
Now I have those out of the way I'm now onto the main part of my program which is to display infomation onto the application about the user account. This could include editing the user account, uploading content to the website or viewing content from the website.. (Sorry but I'd like to explain how I have certain things to get the point across clearly )
Anyway how would I create a sort of session? Like PHP, once you login you can grab information from the database based on the information submitted from the login which was fetched from the database.. When the user presses login on my application it brings them to the main part of the application but I'm now unsure how to load variables and/or session data.
(Side note, I have also sha encryption on my website in the register/login, at the moment VB reads the information from the textbox as normal text is there anyway I can get it to read the sha encryption? and also insert data into the database with this encryption?) - This question is optional.
I have two table , how to sum and show balance ...
Table 1
ClientID Amount
001 100
002 200
003 300
001 400
004 500
001 600
004 100
Table 2
ClientID Amount
001 200
002 50
003 100
001 150
004 75
001 25
I need the result set like this Here Table 1 minus Table 2.
ClientID BalanceAmount
001 725
002 150
003 200
004 525
I have a web page that allows user to make transaction and they are allowed to choose if they want their transaction to be immediately transferred to the payee or for future transfer. I have problem handling future transfer, for an example, I want to transfer $100 to A on 12 August but today is only 09 August. So the amount should be deducted . I decided to make 2 balances; Available and Ledger balances. Available balance is the net balance after doing all the future transfers etc. but for ledger balance is what is available at the point of time. I'm thinking how should I form the query for the SQL statement. Currently, this is what I have. Transfer code = 2 -> future transfer
IF (@TransferCode = '2')
BEGIN
--Insert into the account transaction table first--
INSERT INTO ACCOUNTTRANSACTIONS (AccountTransID, CustID, TransDate, TransType, Reference)
VALUES (@AccTransID,@CustID,@Date,@TransType,@Reference)
IF NOT (@Date = Getdate())
IF (@Withdraw > @BankBal)
BEGIN
INSERT INTO ACCOUNTTRANSITEM (AccountTransItemID, AccountTransID, AccNum, Withdraw, Deposit, status)
VALUES (@AccTransItemID, @AccTransID, @AccNum,@Withdraw,@Deposit, 0)
PRINT 'INSUFFICIENT AMOUNT IN BANK'
SET @ReturnValue = 4
RETURN @ReturnValue
END
ELSE
BEGIN
INSERT INTO ACCOUNTTRANSITEM (AccountTransItemID, AccountTransID, AccNum, Withdraw, Deposit, status)
VALUES (@AccTransItemID, @AccTransID, @AccNum,@Withdraw,@Deposit, 1)
END
ELSE IF (@Date = GETDATE())
BEGIN
IF (@Withdraw > @BankBal)
BEGIN
INSERT INTO ACCOUNTTRANSITEM (AccountTransItemID, AccountTransID, AccNum, Withdraw, Deposit, status)
VALUES (@AccTransItemID, @AccTransID, @AccNum,@Withdraw,@Deposit, 0)
PRINT 'INSUFFICIENT AMOUNT IN BANK'
SET @ReturnValue = 4
RETURN @ReturnValue
END
This is Table Stucture..
[Code]....
How do you currently find the balance between javascript and code behind. I have recently come across some extremely bad (in my eyes) legacy code that lends itself to chaos (someHugeJavafile.js) which contains a lot of the logic used in many of the pages.
Let's say for example that you have a Form that you need to complete.
1. Personal Details
2. Address Information
3. Little bit more about yourself
You don't want to overload the person with all the fields at once, so you decide to split it up into steps.
Do you create separate pages for Personal Details, Address Information and a Little bit more about yourself.
Do you create controls for each and hide and show them on a postback or using some update panel?
Do you use jQuery and do some checking to ensure that the person has completed the required fields for the step and show the new "section" by using .show()?
Do I just need to make a field for account type in my user account table? In a technical way, if(account type = admin) then the account would log as admin; otherwise, a user with less privileges.
View 7 RepliesI want to learn how to add/delete/update account (including adding mail boxes for new users). Can someone point to a good book where I can begin from. I want to start with some real basics and build from there.
View 1 RepliesI have an ASP.NET page where at the top of the page is a search box. There are 2 text boxes - one is an autocomplete extender for the Name on a database, and one is just inputting the ID.The page features DetailsViews and GridViews primarily, and even when no account has been searched for, these display blank data which is not ideal. I sort of fixed this by using if (IsPostBack), encasing the elements in a placeholder and setting it to visible only if the page ispostback. But this doesn't cover if the user types in an incorrect ID.
Also, some accounts have huge amounts of data inside the GridView's. I had an issue where because I have no way of detecting when a data source's rows has changed, I end up binding whenever the page loads (Page_Load method). I've come to realise this is simply very bad - there are lots of times when the user can click various things in the page and have the page postback, and it takes an eternity to load each time I click something for accounts with lots of data.Anyway, my question is essentially two-fold but I have a feeling the solution will be similar:1: How can I detect when there are no accounts returned when searching, and disable the Grids/Detailsviews and show an error message?2: How can I figure out when the user searches for another account and only rebind the grids after that has happened?
I have use the mvc 2 web site template and I would like to attach
A user db that I have already created
In my web config file I have change the connection string to this"
[Code]....
When I'm tring to register I'm getting this error :
Login failed for user ''. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''.Source Error:
[Code]....
I have set a break point in line 127 and I can clearly see that is getting the data (username ,password ,email) What is wrong( with the contion string)?
We are currently running an asp.net application with 3.5 framework, using a SQL 2008 back-end. We have found that when we go from http to https we lose our session. Basically you come in on Server01 in http, add an item to your cart go to the secure checkout page (https) and you are now on Serve
View 2 RepliesI'm seeking an algorithm to split a list of items of varying sizes into "N" number of similarly-sized groups.
Specifically, I'm working on an ASP.NET site in C# where I have a (database-retrieved) list of strings. The strings are of varying lengths. I have a set of columns which need to display the strings. I need an algorithm that will find the most balanced sets (item order is irrelevant) to allow the final columns to be as balanced as possible.
Abstracted Example:
Creating 3 columns.
Items to distribute:
- Item A - height 5
- Item B - height 3
- Item C - height 7
- Item D - height 2
- Item E - height 3
Desired output:
Column 1: Item A, Item D
Column 2: Item C
Column 3: Item B, Item E
Im using asp.net 2.0 with Visual studio 2005... My requirement is i want to show my balance sheet from MS SQL 2005 database to graphical Chart... so Would u guyz will let me know the best high qulaity chat which support asp.net 2.0 with Visual studio 2005..
View 3 RepliesI am logged in as the administrator when I installed an application named pdflatex.exe on my server. This application works as a converter from LaTeX input file to Pdf file. I host an Asp.net MVC 3 application running under an Application Pool Identity with Load User Profile = True. The Asp.net MVC 3 code contains a code that executes pdflatex.exe using System.Diagnostic.Process instance as follows:
Process p = new Process();
p.EnableRaisingEvents = true;
p.Exited += new EventHandler(p_Exited);
p.StartInfo.Arguments = "-interaction=nonstopmode " + inputpath;
p.StartInfo.WorkingDirectory = @"c:mydomain.comworking";
p.StartInfo.UseShellExecute = false;
p.StartInfo.FileName = "pdflatex.exe";
p.Start();
p.WaitForExit();
From the scenario above, the web application runs under a restricted acount but it executes an external application under a default account that I don't know. Can an application running under a less privileged account start a process executing another application under an administrative account?
I have an asp.net page with a gridview. I would like to make it so that certain columns in the gridview are displayed only if the user is in a certain role, that is, if HttpContext.Current.User.IsInRole(XXX) returns true.
What is the easiest way to do this?
I would prefer a solution where I can easily put this in my ASP code and not in the page code-behind.
after the users login i would like to have a greeting message
eq. WELCOME RONALD MC DONALD. in aspx page...
is this possible? check my codebehind program
string strCmd;
string namesung;
strCmd = "Select EMP_NAME, EMP_NO from user where";
strCmd += " emp_no = ' " + Request.QueryString["user"].ToString() + "'";
namesung = Convert.ToString(mycommand.ExecuteScalar());
Label1.Text = " WELCOME " + namesung.ToString();
in aspx page.
<asp:Label ID="Label1" runat="server" CssClass="font2" Text="Label"></asp:Label>
