Forms Data Controls :: Sum Where Userid = User.identity And Send To Label?
Feb 23, 2011
i have 10 columns, diffrence user insert (rows)many time, i want to display in page lick this :select Sum where userid=user.identity datetime =date.now and send sum of each columm to 10 labels on page.
i want to know how i can ReNew The Life Time Of Page.User.Identity.UserId Session, , how i can increase the Time Of this session ??
i want this scenario in case when the user LogOn for 15 minutes , then the page refreshed ,then renew the TimeOut Of Session by adding addtional 15 minutes and so on
note that im using Page.User.Identity.UserId Session
I have a FormView and the SELECT statement I have is as follows:
SelectCommand="SELECT [UserName], [Full_Name_1], [Full_Name_2], [Email], [Address], [City], [State], [Zip_Code], [Home_Phone], [Cell_Phone] FROM [Homeowners] WHERE ([UserName]='<%$ User.Identity.Name %>')"... but it results in the FormView disappearing from the web page. Note: at the top of the page, <%= user.identity.name %> displays the name fine, so user.identity.name does contain the info I'm looking for.I am trying to figure out how to correctly format the SELECT filter to feed user.identity.name to the SELECT statement as a filter. ... or if there is an alternative way.
i want to use dataset , or any thing ... to display Sum * where user= user.identity.name(not use gridvew, or formview) because i have more then 100 columns . i m newbie. realy , 1 month, it not solve, sometime , i want to give up
I am working on Scott Mitchell's ASP.Net in 24 hours book. I am running into what looks like a simple problem that is getting the best of me.
When a page loads, the UserId of the currently logged in user will be retrieved in the page Load event and placed into the Text value of a Label. But, when the page opens when I am running the app, I am getting an error in the lower left corner of the browser. When I open up the error message, I see this:
In IIS Manager center pane, there is an icon titled "Authentication" as follows: Clicking the icon, we get 3 items as follows: Right clicking the Anonymous Authentication and select edit, we have: Question: which one should I use? What is the difference?
I've been searching in all the forums, and websites for the last 4 hours without finding a solution for a problem that in the beginning I tought it was an easy one!!!This is my problem, I have a gridview with the following colums: select (link), Room Type (for hotels), and TotalThe total field Is a template field it has in the custom binding property a function: find_total(Eval("Room")) this function makes some calculation and returns the calculated Total value, and shows in the gridview without problems,The thing I cant do is: when the user clicks on the select link I want to get the text of the template field and put in a label control.
I tried, almost all the events of the datagrid, to reference the content of my template field but sometimes I receive a null value (seems that Im looking for the value before the find_total function has been executed) or I get an error "the index is out of range".I dont know how to approach this, I tought It has to be much easier, but Im very confused right now, if anybody knows how to do this
I was wondering how I could use user.identity in a where statement in sqldatasource to return results for a user profile. I already have a table that stores the username. Just need to return it's results.
To avoid going to the Databse to get the user Id, Id like to append userId to the Context.User.Idenity.name field. This way I can split the returned string to get the UserId without going to the database.
Where can I do this when using the login controls?
Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.
The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?
How Can Secure and Hide Image Url from Users because it is personal for each user but now it is easy for One User to change fUser_ID (for example from Inspect Element in FireFox Browsers) and access to Other Users Profile Picture.What is the best way for User Security in asp.net ?
I am trying to populate a gridview that returns only the logged in users' records. Specifically, I am getting a blank page when I load the page. To clarify, I get the blank page after successfully logging in to the ASP.Net Membership and do have data to return from the requested table.
I am reaching out to the online community after numerous failed attempts to research the solution and successfully return the desired results through trial and error variations.
I created a column named InputUserId for the purpose of saving the user's id upon inputing data using formview(so I know who inputed). I would like the user's id to be saved in the table (column InputUserId) and the table's Id (RId) to be saved in the user's profile.
I have Template fields configured for Gridview. The gridview is using an objectdatabsource to bind itself. I have the gridview configured to use Templatefields which then contain tables to display the information. This works fine.
My question is, is it possible to change the text of the label if certain criteria is reached. If "NumberOfDwellings" is 1 then change the label to read, "1 Dwelling". Where-as if NumberOfDwellings has more than one then it's "3 Dwellings".
Iīm a newbie at .NET and Iīm trying to solve how to run a datagrid with parameters. I know how to do where clauses with controls and today I managed to solve how to have a where clause at UserID within a SelectingEvent.BUT, I canīt run them both in the same time. I want to run a query based on the month in a dropdownlist and the UserID. Each one individually works.Why canīt this be done? Is the onselect statement ignoring the other parameter? I donīt get any errors.The ASPX (in VB.net) code is:
get the below error. My application was working fine until I probably modified something, but don't know what.
Server Error in '/' Application.
Method is only supported if the user name parameter matches the user name in the current Windows Identity.
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.Configuration.Provider.ProviderException: Method is only supported if the user name parameter matches the user name in the current Windows Identity.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ProviderException: Method is only supported if the user name parameter matches the user name in the current Windows Identity.] System.Web.Security.WindowsTokenRoleProvider.GetCurrentWindowsIdentityAndCheckName(String userName) +2195661 System.Web.Security.WindowsTokenRoleProvider.GetCurrentTokenAndCheckName(String userName) +36 System.Web.Security.WindowsTokenRoleProvider.GetRolesForUser(String username) +61 System.Web.Security.RolePrincipal.IsInRole(String role) +182....