I need to use a grid that allows for filtering in the column headers. I know there are some third-party components out there that cost money. I am looking for something that is free / open-source that can be used on a project. Is anyone aware of a GridView that can do this?
View 2 Replies
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?
[Code]....
I have boundfiled column inside gridview and made the column as invisible by setting visible="false".
But while exporting the gridview to excel I am getting the Header text alone exported. Wherever the column's visibility is set to false the header text should not be exported. After binding the gridview I have set the column's visiblity to false so it won't export the column values.
The problem is to stop exporting the header text to excel. Let's say column index is 10
public class GridViewExportUtil
{
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
[CODE]...
I recently applied a javascript code from article "Dynamically freeze ASP.net Gridview header using Javascript" found here, ASP Snippets Article, to my page. The javascript works great, but somehow, it's overriding my CSS code for the headers. When I refresh the page, I can see the headers with my CSS in place for just a fraction of a second before it is replaced with generic styling. I am not a javascript person, so really can't troubleshoot the problem. I have a style sheet with the following code.
.dGrid {
width: 983px;
background-color: #ffffff;
[Code]......
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.
Scrollable GridView with Fixed Headers inside ASP.Net UpdatePanel using jQuery Plugin. I have one more question in that. How to adjust the width of the columns headers because for some of my gridviews the headers not showing the proper format. in the gridview I gave HorizontalAlign="Left" and in the columns I gave
<asp:BoundField DataField="XXX" HeaderText="XXX" ItemStyle-Width="150px" HeaderStyle-HorizontalAlign="Left" />
It's not showing in the correct fomart. header is coming to the left side and data is coming to the right side...
Please let me know if there are any sample code to introduce filtering column values in gridview, similar to telerik and devexpress controls. I have sample code for dropdown box filtration. But I am looking for one based on textbox entered values
View 1 Repliescant find any post about filtering multiple strings in 1 column.
<asp:SqlDataSource ID="SqlDataSource8" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"
SelectCommand="SELECT [ID] FROM [Aaden] WHERE ([Choice] = @Choice) ">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownListChoice" Name="Choice"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
this is does search selected string.How can i search multiple strings in one column. for example my dropdownlistchoice.items ("a","b","a+b")
When i choose "a+b" in my drobdownlistchoice i like to display items "a" and "b" how to do it?
I just hit the same problem as described here: [URL] - GridView paging with ObjectDataSource. I see the column headers but no data, and I know for a fact my method returns a DataTable with data in it.
View 1 RepliesI have in my code a gridview that I redirect to excel, it works fine when I have data in the data set. waht I want is to show column headers when there is no data right now what i get is empty sheet.
View 7 RepliesI have a Car class that I'm trying to display in an MVC 3 view using the WebGrid helper. Below are the Car and it's metadata class.
Car class:
[MetadataType(typeof(CarMetadata))]
public partial class Car
{
// car implementation
}
Car metadata class:
public class CarMetadata
{
[DisplayName("Car Name")]
[StringLength(100, ErrorMessageResourceType = typeof(ValidationText), ErrorMessageResourceName="CarNameDescriptionLength")]
[Required]
public string CarName { get; set; }
}
View contents:
@model List<Car>
...
var grid = new WebGrid(Model, canPage: true, rowsPerPage: 10);
grid.Pager(WebGridPagerModes.NextPrevious);
@grid.GetHtml(
htmlAttributes: new { id = "grid" },
columns: grid.Columns(
grid.Column("CarName", ?????)
));
GOAL: I'd like to figure out how to use the DisplayName data annotation as the column header text in the WebGrid (?????). Does anyone know how this is accomplished?
I want to make a filtering table. It will be a table where below each column it will have a textbox. I want to, while the person type a word in the filter textbox, the table refresh, displaying only the items (rows) with that word. I think AJAX is a good idea. Just put the table and the textbox in a UpdatePanel, and then write a code to refresh the table on textbox_changetext event. The problem is that you have to take the cursor out of textbox to have the event fired, and I want the table update while text typing.
View 4 RepliesI have the following gridView and I would like to add a 'free format textBox' to 3 of the column headers, to allow filtering. Much like here If I could/somehow achieve this that would be amazing. I can't use dropDown lists like many of the examples I have found as these lists would be too populated and proving too unfriendly to use.
[Code]....
I am trying to filter a column for when the text matches "True" in the column. I am using the following syntax, don't get an error, but it isn't working.
Select ContactID,FirstName,LastName,Officer,Title
from Contacts
Where officer
=
"True"
I have never work with a repeater and after a lot of research I got to the conclusion that this is the control I need to use for what I have to do. I need display data but I will need 2 headers and after some sort of amount of records the headers will repeat again. In this page you will find an example of what I'm trying to do http://ratings.fide.com/view_source.phtml?code=45276 I don't know if a repeater is the right control but i thin it is.
View 3 Repliesexplain to me the concept of Request.Headers and Response.Headers in ASP.NET? Under what scenarios you use Request.Headers and Response.Headers?
View 1 Replies I have a standard gridview, with the standard paging and sorting interface enabled.The application holds appointments for three organisational units, with a maximum of 3000 appointment records being returned across all three units. The appointment records are quite small.
The choice I am faced with is to:
1. Have an Org Unit dropdown which returns to the datasource on change of selection and at inital databind, and returns appointment records for one org unit at a time i.e. approx 1000 records.
2. Have the objectdatasource return all 3000 appointment records for all org units at initial databind, and filter the objectdatasource by org unit on change of selection, thereby saving a trip to the datasource.
I guess the question boils down to identifying the point at which querying the datasource by org unit is more efficient than filtering the records returned by org unit.
Is 3000 records a lot for a gridview to be paging and sorting etc.
Given all the research I've done, I don't think this is possible - am I correct? I've been all over the web looking for ways to do this. My grid needs to scroll vertically, horizontally, sort, and go into edit mode. I've been able to do the "cheap" solution where a table sits above the grid to hold the column names, but this does not work well with putting the grid into edit mode or scrolling horizontally. In both cases, the columns become out of synch with their headers. My organization will not pay for a grid, so JQGrid is out. So, since the 'expression' capability has been removed from IE8, we are left with no possibilities for fixed column headers?
I'm not advanced enough in JQuery to do this...but wouldn't it be possible to create a JQuery function that copies the grid header row to a div that sits above the grid, so that the headers are always visible? (And hide the original grid header row). Anyone want to take a crack at it? Maybe I'll try but it will probably take me too long.
I changed a gridview's header to ... with
Sub MakeAccessible(ByVal grid As GridView)
If grid.Rows.Count > 0 Then
grid.UseAccessibleHeader = True
grid.HeaderRow.TableSection = TableRowSection.TableHeader
grid.HeaderRow.CssClass = ""
'grid.FooterRow.TableSection = TableRowSection.TableFooter
End If
End Sub
Now I need to add attributes to the th tags like th xyz=boom.
I need to display the column headers to the left within ASP.NET? how to do that?
View 1 RepliesI want the headers of my gridview to be hyperlinks, without the "SortExpression"...I searched the net, but I've been not very succesful.
For example: when clicking on the header of a simple gridview, the site navigates to a webpage. Is it possible?
I want to freeze GridView headers.
View 1 RepliesI have a GridView with a SQL query bound to it. The query uses "Group By" to group together rows which have a particular "person" in the "Tech" column. E.g.
Fred - 01/12/10 - Rebooted machine
Fred - 02/12/10 - Cleared printer jam
Fred - 03/12/10 - Reset password
Susan - 02/12/10 - Changed permissions
Susan - 02/12/10 - Restarted machine
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
View 4 RepliesI wanted to have fixed headers in grid view. I came across multiple solutions but none worked with IE 8 and Chrome. One of the best solutions is following:
<style type="text/css">
<!--
.DataGridFixedHeader {background-color: white; position:relative; top:expression(this.offsetParent.scrollTop);}
-->
</style>
