Forms Data Controls :: Splitting GridView Column Into Multiple Columns?
Jan 10, 2011
I have a gridview that is being populated by an oracle DB. The gridview have 2 columns now one shows years and the other is a checkbox column. What is happening is my years column is very long and I wanted to know if I could split the column in half. I want say from 1970-1990 in the first column. The second column will have the checkboxes for the first. I want the third column to have 1991-present day and the fourth column to have the checkboxes for the third column. Can the grid view do this or is this something I have to do in oracle and have the gridview just display it?
I have a question in gridview, I want to combine my two or more records into a single cell with two rowsfor Example i have a ID, Name, Year Start, and Year End for Column name in database and i want call it into my gridview that the Year Start and Year End will combine to Year like:
Select tbl_name.name,tbl_midname.midname,tbl_last.lastname As name From tbl_name inner join tbl_midname on tbl_midname.id=tbl_name.id inner join tbl_last on tbl_last.id=tbl_name.id where tbl_name.id='1'
I am retrieving a column from a table using an SqlDataSource in ASP.NET/C#, which contains multiple 'values' separated by commas. I'd like to be able to separate this values into multiple columns in my GridView, and also allow them to update them. Is this easy to accomplish?
what I would like to do is to only show the AuthorFirstName and AuthorLastName columns for the first row of each author. I am easily doing this with:
[Code]....
However the issue that I'm seeing now is the formatting what happens is that after the first row that the Author names are hidden but then the BookTitle and YearPublished become the new cell(0) and cell(1) respectively which means that book and year are displaying underneath the author names columns. so my goal is to do 2 things:
1 have BookTitle and YearPublished render under the correct headers and
2. For the second row and after I would like the cell to appear the same as the background, I dont want the user to be seeing what looks like an empty cell or textbox there.
I want search with multiple names in Name coloumn. example I have pass the criteria to Name cloumn is 'Atul', 'Mayur', 'Suraj' this three names how to pass in a query.
I have a GridView with bound columns, for which I am manually setting the ItemWidth and HeaderWidth to 500px, and nothing happens. Is there some trick to getting this to work?
This is a column a large amount of text in it, and it keeps sizing to the width of the header text, which is simply "note". I don't want to set Wrap to false, becuase then the colummn could be thousands of px wide in cases.
i have a gridview which is populated from a stores proc using pivot tables. The column are created dynamically apart from a total column which is created as a template field. the gridview looks like below:
CPW EE Foh H3G IND O2 ORG P4U T-M TSC VIR VOD Total
Stores Visited
70 0 0 12 0 16 18 7 11 1 2 8 145
i need to add a hyperlink to each gridview cell and when that cell is clicked pass the header text through the querystring to another page. I can access the cells value ok and pass that through but i cannot seem to access the cells column header text. when i response.write out a count of the gridview.columns it brings back 2 which is the template fields but not the dynamic fields i have tried this on the rowdatbound, rowcreated, page_load and page_unload. the count should be 12 its like it cannot find the dynamic columns at all. ?
here is my code for populating the gridview
[Code]....
and here is my gridview:
[Code]....
i am also moving the total column in this code
[Code]....
and calculating my total in this code and adding my link to the total colum (which works fine)
[Code]....
now i just need to somehow add a link to the other cells and somehow get the value of the header text for that cell clicked.
I have a couple of things that are not working with my Gridview:
1) I've managed to display 3 columns in one column (see code above) but the data is separated by commas, how can I display each data item in separate rows.
2) How can I make the data unique, as I have added the distinct command which I configured in my SQL data source
3) I need the rows to not display nulls, but at the moment it isn't displaying the row if one of the columns is null?
I want to display my data from sql in a grid view. Here the problem is how do I display more than one columns under one column. For example, I have A, B, C, D, E, F columns in sql and then when displaying in Grid, I want to display as 3 columns A, B, C and under column "B" I want to Display D, E, F.
I'm just wondering if anyone can assist me with this gridview problem
I have this Sql statement that outputs a gridview like this
Job Location Activity 1 Activity 2 Activity 3
Job1 Location1 0 0 1
Job2 Location2 1 0 1
Job3 Location3 0 1 0
* These columns are placeholders
I want to include a footer total that looks like
Job Location Activity 1 Activity 2 Activity 3
Job1 Location1 0 0 1
Job2 Location2 1 0 1
Job3 Location3 0 1 0
Final Total 4
Im not binding the database to the gridview via design view I'm binding it programatically in the default.aspx.cs file
So far the only tutorials I've encountered are ones the have the database bound through design view and gridviews with only one column that can be added. In my particular example I have multiple columns that need to be added and I have already bound the data to the gridview.
I have a GridView which is databound and I added two columns which are checkboxes. There is no link between the two columns. On a check box click , I need to check to see any other check boxes on the same column checked, if so, show a javascript confirmation . If click ok, need to do postback to update the database.if cancel, no change. The goal is ,I need to make sure that only one check box is checked in a check box column.
I have 5 textboxes in my webpage for entering address, i.e,
door no, village, city, district, pincode.
These are concatenated by comma (,) and stored into the database field address. at the time of retrieving, the concatenated address, should be separated and assign to each textboxes.
I've been trying for the past few hours to add mutliple headers to my grid view but keep failing to get it to show. There's plenty of examples online that I found but can't seem to get the most simplest to work. Below is the code I've been using with no success. I even tried changing the "TableCell" o "TableHeaderCell" but still yields no headers as expected. Anyone know what I could be doing wrong?
I need to make a link for all the rows in one column of a gridview(VB .Net) where the grid has been auto-created from the data source. The link would simply point to another ASP details web page. The examples I have found have all been in C# and I don't quite follow them.
I have a requirement to create multiple hyperlinks dynamically in a single GridView Column. The number of hyperlinks are not not known in advance and will depend on the results brought up by a query. How do I create the same?
i have one grid which have 5 columns 1 for subject,2,3,4 for marks which have textbox to insert obtained marks,and last column have one lable to display total of (2+3+4),now i want total value on textbox event,when user enter any value to any column of textbox i need to display total of all three columns in total column.
