Forms Data Controls :: Displaying All Users In A Grid Along With Profile And Membership Info?
Mar 24, 2010
I am developing a website in asp.net that user asp.net membership, users and profile tables.I am trying to display all the users that are registered in a grid along with their first name, last name, email and other profile information . unfortunately all this information is scattered in various tables in the database ( aspnet_users, profiles, membershipsetc)... Can you please tell me how to configfure the datasource & columns of my datagrid (control) to achieve what I am trying to do .. ?????
View 3 Replies
Similar Messages:
Jul 6, 2010
I am trying to create a second grid in the same page with detailed info for a given record of the first Grid, but when I press select in the first grid nothing happens. I follwed everything I read.
<asp:GridView runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" style="margin-right: 0px" Width="659px"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AllowSorting="True" DataKeyNames="accession_num,organ"
EnablePersistedSelection="True" EnableSortingAndPagingCallbacks="True" onselectedindexchanged="Unnamed1_SelectedIndexChanged"
>
<Columns>
<asp:BoundField DataField="organ" HeaderText="organ"
SortExpression="organ" />
<asp:BoundField DataField="weight" HeaderText="weight"
SortExpression="weight" />
<asp:BoundField DataField="unit" HeaderText="unit" SortExpression="unit" />
<asp:BoundField DataField="accession_num" HeaderText="accession_num"
ReadOnly="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:pdmstestConnectionString %>"
SelectCommand="GetGrossOrgan" SelectCommandType="StoredProcedure"
UpdateCommand="UpdateGrossOrgan" UpdateCommandType="StoredProcedure"
DeleteCommand="DELETE FROM [Pathology_Gross_Organ] WHERE [accession_num] = @accession_num AND [organ] = @original_organ"
OldValuesParameterFormatString="original_{0}"
> <SelectParameters>
<asp:ControlParameter ControlID="accession_num" Name="accession_num"
PropertyName="Text" Type="String"/>
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="accession_num" Type="String" />
<asp:Parameter Name="original_organ" Type="String"/>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="accession_num" Type="String"/>
<asp:Parameter Name="organ" Type="String"/>
<asp:Parameter Name="weight" Type="Int16" />
<asp:Parameter Name="unit" Type="String"/>
</UpdateParameters>
</asp:SqlDataSource>
View 8 Replies
Aug 11, 2010
I want to send out an email to all users where their birthday is today. i am using the built-in asp.net (3.5) membership. All users have a profile (stored in aspnet_Profile) which contains a date/time property called 'birthday'. I need to get a list of users email addresses from the 'aspnet_Membership' table where a users birthday is today, along with the users 'firstname' which is string property in the aspnet_Profile table. i would like a list returned preferrably using C# LINQ. i am not sure how to access the birthday property in the profile table, based on the way it is stored in the db table i.e name/value columns
View 3 Replies
Feb 22, 2010
I have created a web based form which has a drop down list (DDL) that lists various company names. I want to create a box in the form which displays the contact info for that particular company which is chosen in the DDL. Also, I want this info to be in a greyed area so that user cant modify (can just copy it).
what asp tool i should use for this (I am guessing textbox wont be good enough since user can modify the info that populates in it)
View 2 Replies
Apr 8, 2010
i have an admin page that displays membership info, like email, usename, lastactivity....., i need to add the telephone number from profiling.
i use this to get current but i dont need current i need it for the user whos ID is i a query string
[code]....
View 1 Replies
Jul 13, 2010
I have developed my application using ASP.NET with Visual Basic. I have a table that contains 3 fields. The name of the table is "Customer" and the names of the fields are "Name", "Address", and "Amount". I have a gridview that displays these three columns. I want to summarize the value in the "Amount" column for each record and display the summarize value in the footer of the "Amount" column.
I added some code to the "ItemTemplate" and "FooterTemplate" of the template for the "Amount" field and wrote two functions One function adds the value of the "Amount" field to a variable called "TotalAmount" and the second function 'gets' the value stored in the "TotalAmount" variable.
I am not getting any error messages and all of the items are displayed in the gridview but I am not displaying anything at the bottom of the "Amount" column. What more do I need to do?
This is my code for the "Amount" template:
<asp:TemplateField
HeaderText="Amount"
SortExpression="Amount">
<EditItemTemplate>
<asp:TextBox
ID="TextBox1"
runat="server"
Text='<%# Bind("Amount") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Bind("Amount", "{0:c}") %>'>
<%#SumAmount(Eval("Amount")) %></asp:Label>
</ItemTemplate>
<FooterTemplate>
<%#GetTotalAmount() %></FooterTemplate>
<FooterStyle
BorderColor="Black"
BorderStyle="Solid"
/>
</asp:TemplateField>
This is the code in my .vp file
Dim TotalAmount as decimal 0.0
Function SumAmount(ByVal Amount
As
Decimal)
As
Decimal
TotalAmount = TotalAmount + TotalAmount
End
Function
Function GetTotalAmount()
As
Decimal
Return TotalAmount
End
Function
View 3 Replies
Jul 16, 2010
i have ending date comming from sqldatabase and other is current ,now i want to show in a column of gridview days left i.e.(ending date - current date)
View 2 Replies
Jun 11, 2010
I'm using:
[Code]....
to format the currency values and on my local machine everything works correctly displaying the currency in £ (pounds).
I moved my code onto the server that it will be run from and it's displaying in $ (dollars).
Our technical team that look after the server (Development aren't allowed access to the admin side of things) say that the server is set up for UK.
Where should they be looking to be able to set the server to display the data correctly?
View 2 Replies
Mar 20, 2010
i want to change , the displaying items in a grid view and on the way the text value of a lable at the same click on a link ... ? it means that i need the connectionstring or somthing in the properties to change with the link click
View 5 Replies
Aug 23, 2010
I have a problem displaying data in a Grid View control when set a row to visible = false when a certain condition is true.
For example, if a DataRowData value has a condition set to true (custom in table) I set the visible property to false, so the data row will not be visible at run time.
The problem is that I'm using paging (10 rows per page) and if 8 of those rows fall into the true condition that won't show the row, that grid view page will only show two rows of data in page 1. The worst scenario is that if I go to page 2 of the grid view and all the rows (10) fall into the true condition, that grid view page will not show any data at all.
How can I show 10 rows of data at all times in a gridview? In other words, I would like to just show the visible rows at all times.
View 4 Replies
Mar 29, 2010
I want to display values aligned with a header grid. An employee might start from 7:00 a.m. to 9:00 a.m. for their first break. I am trying to display the values 7:00 and 9:00 aligned with the header.
View 1 Replies
Jan 8, 2011
How would I go about displaying a databound dropdown list in a property grid, i.e. a dynamic list that can be used to set the value of an individual property?
View 1 Replies
May 13, 2010
I'm creating a site that will offer several different services (blogs, videos, images..), all under the same site.
Each service will use a separate database and all services must use the same membeship info. Users will only need one login to access all these services.
For the membership database i will use the default aspnetdb database.
There are two ways i can think of:
1) Use a join-query between two databases, each time i want to show some service records per user.
2) Create a custom membership-info table in each service's database, and keep it in sync with the master membership table in aspnetdb database.
The custom membership table will be like this:
Id - int, primary, identity
UserId - uniqueidentifier (of aspnetdb database)
What is the best way to do this in the long run, when i will have six or seven or more services ?
View 2 Replies
Jun 12, 2010
how can we write a code for displaying a files and folders of server directory using Grid View in asp.net?
View 3 Replies
Sep 23, 2010
I'm using the CreateUserWizard and it's working great. I do have a "step2" that asks the newly created user their first name and last name. Seems simple enough, but I'm getting an error on the Profile.Save(): "This property cannot be set for anonymous users". I'm assuming this is due to the fact that I have DisableCreatedUser="true" for the CreateUserWizard, which is what I NEED to do. Does this mean that until we enable this user, they can't add these few columns? Since the site I am updating requires matching a newly registered user to an already existing "Artist" table, it's important that the administrators are given the first and last name of the user. The aspnet_User table doesn't have that, so I thought I'd give the profile a try.
View 3 Replies
Aug 3, 2010
I have done the following: Added additional data to the profile table. However, the information is in a string. I am not sure how to extract the information using SQL so that I have the additional data separated. Additionally, I am not too sure how to call this information back into the webpage, once the customer log ins.
View 2 Replies
Feb 23, 2010
I want to access membership and profile objects and wants to access profile properties that I have defined in my web app web.config file, from a windows service. I have used this code
foreach (MembershipUser user
in Membership.GetAllUsers())
{
ProfileCommon userProfile = profile.GetProfile(user.UserName);
}
But its giving the followin errors The type or namespace name "ProfileCommon" could not found (are you missing a using directive or an assembly reference?) The type or namespace name "MembershipUser" Could not found (are you missing a using directive or an assembly reference?)
View 6 Replies
Apr 26, 2010
I'm using the GetOleDbSchemaTable to get column info from an access db, column_name and description, but getting an error that the bind statement can't get the properties. I know its there because I can response.write it from its table, schemaTable.Rows(i)!DESCRIPTION.ToStringdo I have to bind it differently than when binding actual data from a table using the column name for reference?System.Web.HttpException: DataBinding: 'System.Data.Common.DataRecordInternal' does not contain a property with the name 'DESCRIPTION'.
View 2 Replies
Jan 16, 2011
i have one grid and one button when i click on that button then it expand and showing another grid under the row of parent grid how to do that.
View 2 Replies
Nov 16, 2010
New users can register on my site by completing a basic form that has the create user wizard control with some additional information i am collecting using a CheckBox List. They can then log in to the site and and view "MypProfilePage.aspx" where I display the information with the CheckBoxList boxes already ticked based their selections which they can update. My problem is I have two levels of User and each one has a different registration form.
Registration Form A
Has 20 Items in the CheckBox List
Registration Form B
Has 10 items in the CheckBox List
On the Profile Page, I just want to show the CheckBox which is relevant to the Registration form A or B and with selections by the registered user. So therefore the User who registered on B will not be able to see the selections checkbox list for A.
View 6 Replies
Aug 4, 2010
I have a user control which, when pressing a command button, sets a property for the Profile (which has been marked as allowanonymous=true), then save it using Profile.Save().
Now, in IE this works fine - no problems at all. I then go to the page where the value is used - and it's there and can be used.
However, exactly the same routine when running in Safari or Firefox doesn't work - although when you're on the same page where the value is set it will immediately state that the value is ok, do a postback and it's gone!
Here's some very simple code to show the problem. Whilst IE will always dump 'plop true/false' to the screen (yes, I know - very juvenile!), FF and Safari will the first time, but on postback will just dump True to indicate it's a postback. (oh, and autosaveprofile is set to true in this example - otherwise there'd be a Profile.Save() below the set property).
[Code]....
I can't use Cookieless session states as the CMS I'm using won't allow it. I've also used Fiddler to try and track the issue, but no joy.
I'm guessing it's related to the way FF and SF handle cookies - but both are set to accept anything. Could it possibly be anything to do with the ASP.Net Development Server? (ie. the address is[URL]The fact that it never manages to save the value
View 1 Replies
Oct 8, 2010
I'm trying to build the chat (it is already built here - [URL] The only thing I want to change is: remove login control. Instead of login I want to assign random usernames to people who open my webpage. Also, when somebody closes page and reopens it again in, say 10 minutes, I want this user to have the same username and data.
View 3 Replies
Mar 26, 2011
I am a senior developer in an ISP company.
We developed a software which we want to require it for all ours users to have installed on there PCs before getting internet from us.
We built our own proxy server, and we are forcing all our users to view a aspx webpage before surfing the internet.
Now, we want this aspx webpage to check the PC if it have our software installed or not, and the mechanism will deny them to surf internet before install the software on there PCs.
How can we get special info from there regystry or something like that to know this?
Example: like flash player or silverlight player, where the requested page check if the PC have the right plugin installed or not. if not, it redirect to the installation page, if yes, the flash or silverlight movie run.
View 1 Replies
Jun 7, 2010
Is there an easy way to select a specific user that is already logged in and bind all the users info to a detailsview for edit and saving back to the tables?The tabels were generated in AWAT of VS 2010
View 1 Replies
Feb 18, 2011
I'm trying to use both the default Membership and Profile Providers and can not for the life of me get both to work at the same time. I'm using MS Visual Web Developer 2010 Express and when I create a new Project I get access to the Membership but not the Profile. When I create a new Website I get just the opposite i.e. access to Profile and not Membership. What do I need to do to get access to both?
View 2 Replies
