Forms Data Controls :: Fill Gridview Based On Rights?
Oct 10, 2010
I have a master table that will hold the information for publications for my company. Not all of the publications can veiwed by all users. What I am trying to figure out is how can I load all of the publications that the user is allowed to see into one grid view table. For example: If Mary logs in she will only be able to see Accounts publications; if Sally logs in she can see General and Legal publications and if John logs in he can see IT, Legal and General publications.
I figured out how to do it with separate gridview tables on a page based on the roles. I would make a gridview viewable if the user was in that role. But I would really like to put all of this in one gridview if that is possible.
View 8 Replies
Similar Messages:
Feb 3, 2011
I want to show columns in gridview based on access rights/roles.That is i want to show parents column if there is parents login or else i want to show students column if there is students login.
View 2 Replies
Apr 5, 2010
I have 2 GridViews, the InnerGridView is nested inside a TemplateField of my OuterGridView.
Each GridView has an ObjectDataSource (ODS). I want the InnerGridView to display data that is unique
to the GroupName that is listed in the OuterGridView. I have been Googling this for weeks, seeing various based around RowDataBound and the ODS Selecting event.
I don't think RowDataBound is the answer, because the Selecting event for the InnerGridView ODS
has already been called when RowDataBound is called for the OuterGridView.
So, I need to send a parameter to the ODS for the InnerGridView:
[code]...
Note: This method is assigned to the Selecting event of the InnerGridView ODS.
How do I access the GroupName from the OuterGridView... while I am processing the InnerGridView.
Here is an example of something that does not work:
OuterGridView.SelectedRow.FindControl( "GroupName" ).ToString();
I have heard that one can find any control from inside the Selecting event by searching a certain hierarchy.
But I don't know how to access that hierarchy using the "e" or "sender" parms.
View 1 Replies
Dec 16, 2010
I have a Grid and it is filled with a list of objects... the problem is that in one column i want to show the name of one of his proporties... the problem is that this property is other object... I mean, my object medication has inside other object called producer.. so i want to show the name of this producer..
[Code]....
on the column Producer the thing that appears is : Entities.Producer.... but i want to show the name.. I tried with Producer.Name but in this way i have a error.
View 3 Replies
Jan 20, 2010
Below is my HTML:
[Code]....
I get a message saying 'Error Creating Control -SqlDataSource3'. . . .does not match anyroperties within a 'System.web.UI.WebControls.SqlDataSource'. This was working just fine until a couple daysago and I don't know what changed to cause this to no work any longer. Can anyone tell me what is causing thiserror?
SelectCommand="SELECT ID, Pub,
Street, Neighborhood, City, State, RelativeAddress, Crawl FROM ListofPubs WHERE
(Neighborhood = @Neighborhood1) OR (Neighborhood = @Neighborhood2) OR
(Neighborhood = @Neighborhood3) _
[code]...
View 1 Replies
Jul 23, 2010
I want to fill a gridview with data from a database table..But, I have to avoid the column names from the database..I had already specified header text for the gridview.. i had already selected two column names 'name' and 'number' from a database table, then I had created two columns for the gridview( with header text's name and number)..Now i want to select the all the data from columns 'name' and 'number'..and then fill the respective columns.
View 11 Replies
Dec 13, 2010
Here is what am trying to accomplish...I want to have a DropDownList that is populated by a field from a table. Then once a user selects one of the enteries, he/she then enters a value for that selection in a textbox, then clicks enter or add....now upon doing this, I want to have a GridView that tabulates all the entries the user adds, and keep a total of all entries as the bottomline in the GridView. I can't seem to wrap my head around how to get it done.Does anyone know how I can get this done, or are there examples out there that my searches have missed cause I haven't really seen any examples I could look at. I would think this should be a common solution that is used all over
View 4 Replies
Sep 16, 2010
I have a gridview which gets its data from a database tablenow i ghave added a dropdownlist to this gridview but this dropdown should get the data from another table and should set its value automatically with a foreign key from the gridviewi have added the code like below in my rowDatabound but it just loads 1 field and then how should i get the selectedValue according to the gridview id field??
Protected Sub Friends_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
Dim conn As New SqlConnection(HttpRuntime.Cache("con"))
[code]...
View 3 Replies
Oct 16, 2010
I have a gridview in a windowsform.
View 9 Replies
Dec 27, 2013
I am working in asp.net 4.0(VS2010)
I have two values 1. Maximum Amount 2. Reached Amount
I have to show a box with two colors(Dark Green and Light Green) and based on the % of reached amount i have to increase the reached amount color. Also inside the box i have show the label with reached amount.
Let us take an example of Max Amount : $50 and Current Reached Amount : $25. So now my box should be filled with Dark Green color half the size of box and Light Green filled with half size of box and have to show the label as "Reached amount: $25" inside the box.
Then tomorrow if reached amount is $35 then Dark green color should be increased and light green should be reduced based on the % of increase. as like this based on increased and decreased calculation the colors have to filled.
View 1 Replies
Jan 4, 2011
I'm new with programming. I have a GridView that have the specific user data. When the user log in I retrieve the data for that specific user. All I need is; How do I make the gridview get the data of the logged user using a datatable that has a query. Just bind it with the datatable.This is some code that other programmer made, I continue his work.
[Code]....
View 3 Replies
May 26, 2010
I need to create a scheduler for a hospital appointment screen.. i am taking a time interval value and doctor schedules from MyDb. I want to fill the gridview based on the doctor's schedule timings and interval....
for Ex;
if Doctor A .
Time schedule is 09:00 Am - 09:40 AM && 10:00 Am - 11:00 AM
time interval is 20 minutes
i need to show the grid like this ....
09:00 AM
09:20 AM
10:00 AM
10:20 Am
10:40 AM
11:00 AM
View 6 Replies
Dec 16, 2010
I have string taskID[texbox],string projectID[texbox],,string description[texbox],,int totalHrs[texbox],,int billableYN[CheckBox],int activeYN[CheckBox]
outside the grid view .
I have gridview with edit button with bound columns taskID,projectID,description,totalHrs,billableYN,activeYN.
I want when i click on edit button this taskID,projectID,description,totalHrs,billableYN,activeYN should populate outside the grid view on string taskID[texbox],string projectID[texbox],,string description[texbox],,int totalHrs[texbox],,int billableYN[CheckBox],int activeYN[CheckBox]
View 6 Replies
Jan 27, 2010
[Code]....
[Code]....
View 1 Replies
Jan 25, 2011
I am trying to populate a GridView with some data that I'll grab from a MySQL Database. I googled and found some code ! But it is giving the following error:[IMG]http://i56.tinypic.com/15foy78.jpg[/IMG]
View 7 Replies
Apr 27, 2010
Is there an easy way to color-code a GridView row based on whether a value in the assigne Datasource is above or below a fixed amount?
View 6 Replies
Mar 20, 2011
I want to develop some reports using RDLC and for that i am trying to make a DATASET using a sqlserver stored procedure which is based on dynamic SQL. and ends the procedure like this.
[Code]....
As you can see at the end its executing a sql at the end so my dataset is not coming up with the columns this procedure is returning.. populate these dynamic columns in dataset so i can build a report based on it.
View 4 Replies
Dec 18, 2010
I have created a gridView control and have successfully bound DataTable (dt) to it using
[Code]....
However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.
View 4 Replies
Jan 12, 2010
How do i show the available data based on the dates? Something like the show only FUTURE dates data.
View 4 Replies
Jan 22, 2010
I have a Data Table which Populate from the Stored Procedure which is below
[Code]....
and iam binding the Gridview with Data Table it is working .Now i have to make some thing visible and Invisible based upon some Value like below
Datatable dtTable = (Viewstate)["StatusData"]; // Same Data Table which is Data Source of Gridview Control
[Code]....
Where Status.Open is an integer Enum value like Open = 1 and Close = 2 .row["Status"] is the Text Open and i want to compare with integer valueHow i compare the Values ? i have to use the same Data table or not?
View 2 Replies
Dec 30, 2010
I have a gridview.In Header of gridview i added dropdownlist.
[Code]....
Here the problem is, i am getting selected value in temp variable(if i change to 20,50,100) in dropdown selection event but it is not binding the pagesize for the gridview and also dropdownlist showing the value "10" only after the pageload.
View 6 Replies
Nov 9, 2010
I have a Transport Detaisl in DB , i want to dispay data on gridview with marquee scrolling up. Cabs are scheduled for drop every hour. So if drop is at 7pm i hav to dispaly on data of that hour from 6:30 to 7:15 later after 7:15 i have to display next hour data ie 8:00 pm drop data. I am able to get scrollin g data on gridview but how to schedlue it to scroll for such timings
View 1 Replies
Feb 11, 2010
I have a Gridview with two columns name and email.
Now if the employee does not have an email address then I would like to highlight that row.
How can i achieve that?
View 1 Replies
Aug 15, 2010
As the post subject I have a gridview;
the question is how can I select the row (not change bg color) during page load dedect a session value ?
View 8 Replies
Mar 18, 2011
I am trying to clear a gridview of text if it equals "12:00 AM". I am using the following RowDataBound code:
[Code]....
View 3 Replies
