Forms Data Controls :: How To Add Columns To A GridView Programatically
Jun 23, 2010
I need to create a grid where the users can see all the memberships, and have a line of checkboxes for each existing role, and be able to check/uncheck roles to allow access authority.
I managed to build a datatable that adds columns and displays them properly, but I have not been able to programatically add columns to the grid based on whatever roles are stored in the system.
I can display the users and their roles by just specifying AutoGenerateColumns="true" when I do that, the checkboxes are grayed out, and the users do not want to have to click a button to open them up.
Here is what I can't figure out.
How do I programatically add columns to the GridView? I have some code in Pageload, but it doesn't work, so it is commented out?How do I turn on all the rows for the entire GridView to edit mode? How do I access the column name for the role they just checked so that I know what to add with the ystem.Web.Security.Roles.AddUserToRole(UserName, Role)?
[Code]....
View 14 Replies
Similar Messages:
Jul 7, 2010
I am displaying the output of a LINQ query in a Detailsview control. I have a Detailsview called DetailsCaAb and a DropDownList called DropDownList2, when the use makes a selection from DropDownList2 the Linq query fetches the data CatAbstract from the table CatagoryTables. e.g.
[code]....
Unfortunately I cannot seem to control what is displayed by the DetailsView, I only want to display CatAbstract, but the details view generates another column called Items. How do I ensure only the data I want is displayed? I need a way of controlling the columns generated programmatically.
View 7 Replies
Jul 31, 2010
I have a gridview and I would like to be able to programatically change the HeaderText of it's columns (probably in the DataBinding event). I know this can normally be achieve with something like this:
myGrid.Columns[0].HeaderText = "My Header Text";
However, the gridview in question is actually nested within another gridview (via template column). So I can't access it directly. I'm trying to use the FindControl method to access it, but so far that isn't working.
View 2 Replies
Mar 26, 2010
i need to replicate or add one more row to the present row in a gridview on clicking a button in template field....am able to add a new row which is having controls not only text....but the entire grid is resetting...i dont want to reset the gri and want to add new row to grid...
View 1 Replies
Feb 27, 2010
I have a gridview which has an image specified for the selectimageurl property.
Can someone advise how I can programatically change the image on a row per row basis?
I would ideally like to only change the image depending on the value of another column within the gridview.
View 2 Replies
Apr 16, 2010
How can we programmatically select a row in GridView control based on the datakey.That means, I know the Primary key of the row which I want to select. So how would I select that particular row?P.S. I dont want to select it based on Index.
View 4 Replies
Mar 18, 2010
in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]
View 1 Replies
Sep 21, 2010
I have a grid view that is bound from my code behind. If the text of a label is equal to the value of a querystring, I want to apply a specific class/style that is in my .css. I've tried this, but doesn't seem to have any affect... How can I set the class for a column in the gridview if the two values match?
[Code]....
View 3 Replies
Mar 4, 2011
I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and
rows as columns like below:
EMP1 1 2 3 4
EMP2 1 2 3 4
View 3 Replies
Feb 20, 2011
I have a GridView with 5 fields. Only two of the fields are edittable (the others are READONLY).
I have an UpdateCommand as follows
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NHLPOOL %>"
SelectCommand="SELECT [PlayerID], [Firstname], [lastname], [Goals], [Assists], [Goals]+[Assists] as Points, [AsOfDate] FROM [PlayerStats], [Player] where [PlayerStats].[PlayerID] =[Player].[ID] ORDER BY Points DESC"
UpdateCommand="UPDATE PlayerStats SET Goals =@GOALS, Assists =@ASSISTS, AsofDate=GETDATE() WHERE PLAYERID = @PLAYERID">
</asp:SqlDataSource>
The issue is I want the PLAYERID GV column to be READONLY but I get a runtime error when updating if the PLAYERID is READONLY.
I get the error "
Must declare the scalar variable "@PLAYERID"."
View 1 Replies
May 4, 2010
Currently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).
[Code]....
View 5 Replies
Jun 10, 2010
I am trying to sort Columns in Gridview. In case, I set AutoGenerateColumns="true" and code the gridview as under:
<asp:GridView ID="GridView1" runat="server" AllowSorting=true onsorting="GridView1_Sorting">
</asp:GridView>
And in .cs:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ViewState["sortOrder"] = "";
[Code]....
ie if I set AutoGenerateColumns=false and define Template Field, Sorting is not done. Can Anyone tell me how to sort a Gridview when AutoGenerateColumns is set to false and Template Field is defined?
View 3 Replies
Oct 9, 2010
I am using Visual Studio 2010 where I have a gridview that displays many columns and because of that the user has to scroll horizontally in order to view the rest of the columns. Is there a way to split the columns so that each row will contain some columns and some columns underneath them? For example, I have 10 columns where each row will show 5 columns with their headers and the other 5 columns below with their headers.
View 2 Replies
Feb 9, 2010
I want to get the values from a cell in a gridview so can I do that without selecting a row. Its something like this I have a drop downmenu and based on the value selected in the dropdown menu I have to change the presentation of gridview without going to the database.
View 3 Replies
Jan 15, 2010
I've created a DataTable by programming and I'v inserted a new DataRow into it, I binded it with a gridview (It's ok), but that new row has many columns, how can I merge all columns of that new row and set the value will be show of that row.
Here is my snipet:
Store1
row [Column1],[Column2],[Column3]
row [Column1],[Column2],[Column3]
Store2 (new row I've created and I want to merge all columns and show the value is Store2)
row [Column1],[Column2],[Column3]
row [Column1],[Column2],[Column3]
View 2 Replies
Aug 20, 2010
After clicking "edit" button gridview gets resized (stretched). How to keep it always the same width?
View 5 Replies
Oct 11, 2010
I have a gridView that returns 12 columns / Fields. I want to only allow 6 columns per row and on the 7th have the 7th column move below the first 6. Example: ...
View 2 Replies
Feb 18, 2011
I have a gridView that I want to only show 5 columns per "Row". To explain, lets say I have a gridView that has a total of 20 columns. Normally this would mean that the grid would show all 20 columns in a single row side by side:col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 ... etcI want it to instead show the columns underneath each other like so:
col1 col2 col3 col4 col5
col6 col7 col8 col9 col10
col11 col12 col13 col14 col15
col16 col17 col18 col19 col20
of course the prespective data associated with the columns would show below each column header.I have read some posts and they are pointing me to a repeator but I am not sure how I would impliment a method like that. Any suggestions / examples of ways you have done so or read about?
View 4 Replies
Nov 5, 2010
I have a gridview. In my RowDataBound handler I'm doing some things to columns, and accessing them like this for example,
e.Row.Cells(7).BackColor = System.Drawing.Color.Salmon So, of course when I rearrange the order of my columns everything breaks.
Isn't there some way to give an ID to a column, and say e.Row.Cells("TotalColumn_ID") ?
Will this work? Do columns have IDs?
View 2 Replies
Feb 2, 2011
I have 12 columns in a grid i want sort 3 of them when user clicks on Header, how can i do this.
U want these columns to be sort WOnumber,DD,PO.
View 1 Replies
Oct 6, 2010
If I have two two columns: Date1 and date2,I would like to display in GridView1 than one column.
Example:
Date1 = 10/06/2010
Date2 = 07.10.2010
GridView1 (date1 + date2) = 06.10.2010 - 07.10.2010
View 2 Replies
Jan 21, 2011
I have gridview which auto generate column is false, and I add some template columns, databind with a class ClassA . it works fine. now, I need add some columns to this gridview. the problem is: I do not know the # of columns that will be added (it is dynamic), and the data with these columns is in ClassA, but it is a array (or list). so, there is no public property for these data, only the array.
now, what I did is: I dynamically add template column to the gridview (column header ...), so, it shows the correct columns in the gridview, but how can I bind the data? I found some example, i.e.
[URL]
but it is for aleady know the data field (which is a public property in the class). all I have is just a array, and I need bind them to the newly created columns in sequence.
View 2 Replies
Mar 9, 2010
i am having a gridview in which all columns get dynamically added, i applied sorting in it, all column added as boundcolumn get sort properly but two column which are added as templated column do'nt get sort. Though my dataview have these column as it is.
View 2 Replies
Oct 1, 2010
want to merge the columns into gridview example SELECT b.TableName,c.ColumnName,a.DataProfileAction,(a.ForeignTable+'/'+a.DataProfileAction) As MergeRecords From DataProfiling As a Inner Join TableList As b ON a.TableId= b.TableId Inner Join MetaDataTable As c ON a.ColumnId=c.ColumnIdquery working.. suppose if any one column empty while binding times it come as empty..
View 2 Replies
Jan 24, 2011
I have a GridView and check box in one of the columns.what i need to do is, if the checkbox is checked i need to replace it with a Tick Mark image instead of checkbox, otherwise leave the column blank.
View 13 Replies
