C# - Sorting A Template Column In A Datagrid?
Aug 5, 2010I have a datagrid and a template column which is bound. I don't understand how to set the sortExpression to make sorting on that column work.
View 2 RepliesI have a datagrid and a template column which is bound. I don't understand how to set the sortExpression to make sorting on that column work.
View 2 Repliescan i implement multiple column sorting in an ASP.NET DataGrid.Datagrid contains Template columns.
View 5 RepliesI have 5 bound columns to be retrieved from the database but I want that on page load event the retrieval of data should be sorted according to that column only
View 1 RepliesI have a GridView that exports to .csv just fine with the code below. The problem is that I have a TemplateColumn with a TextBox which isn't wrote to the .CSV at all!
<asp:GridView ID="GridView1" runat="server" DataSourceID="as400"
AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333"
GridLines="None">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="IMSKU" HeaderText="SKU" />
<asp:BoundField DataField="IMDESC" HeaderText="Description" />........
I have a datagrid with two columns ( File Name, and Date Created ). I want them to be sorted when clicked (ASC or DESC). I went into the design view and added the allow sorting feature and added the column names, so they are clickable in the header of the data grid. I also already added the onsortcommand as well.
My datagrid is named dgFileList and the onsortcommand method is named dgFileList_SortCommand.
The procedure that is already loading on page load is a DataSet. (where I think my problem is)I dont have anything in the back end beside the dgFileList_Sortcommand method. From what I have read, it seems like I can't use a DataSet to be sorted...I'm using visual studios 2005, C#, not VB.
In Datagrid if we are using template column and we have hyperlink and this will have only view or edit whether we can sort it. If so how.
View 4 RepliesI am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesSituation: SQL database, Linq to SQL class a ASP.NET page with a LinqDataSource and a gridview. The table has a ID field, a date field and a Serialnr field. In my Grid I like to Page on the datefield but to sort on the serialnr field ( or a selectable other field). Is that possible? Standard the paging is always done on the sort field and when you select a different sort field the page jumps back to the first page., and paging is then done over that sorted column.
View 2 Repliesis it possible to disable sorting on specific columns? 5 out of 7 columns have to be sortable, two not sortable. The columns are created dynamically in code behind, so I think doing this with mark up is out of the question. When I say disabled, I'm hoping that the underline wont show on the column header when you mouse over it.
View 1 RepliesI have a datagrid that is displaying data that is being returned from a stored procedure. That works fine. The problem is that I want to do sorting. I know that there is sorting functionality in the grid, however, I don't want to go back to the server and get a new set of data. What I want to do is just re-sort the data that is already being displayed.
Basically, I couldn't not find an easy solution to this issue. I tried updating my dataGrid to a gridView control and even that (for my particular issue) was difficult. I wound up un-doing all the changes and just adding another grid that had just the data I wanted for the requirement. If anyone else has an issue like this I would recommend taking it out of a datagrid and writing it in jQuery. I could of written a table that had the data I wanted (and fully sortable using a plug-in mentioned below) in 15 minutes compared to the hours I spent trying to jam a square peg into a round hole.
how does it work when i have a data grid that i want page able and sortable, do i use view state? does the data get pulled once and then the view state keeps all the data and grid working, sortable, page able? or do i need to go to the db server each time i page and sort?
View 2 RepliesI have a datagrid with some data in three datacolumns. I have to apply sorting to two of the datacolumns. Is it possible without any datasource..
View 2 RepliesI have datagrid and inside this grid have template field. I add Header text progr. like this
gvData.HeaderRow.Cells(8).Text = "Hi" But when I do this I can not sort this column when add SortExpression="Hi", i not have clickable header. How can I do this
what I am trying to do;I want it so that when the user clicks on the datagrid column headers to sort the records, or when they go to page the datagrid, that a confirmation pop-up appears first, confirming that their changes are going to be lost (unless they click "Cancel").I have the confirmation pop-up scripted in Javascript and is added to the controls on the page using
[Code]....
How do I attach this to a datagrid header and to the pager?Do the columns need to be Template columns and the header text being hyperlink? If so, how do I set it up so it will, if the user clicks "OK" in the confirmation pop-up, still sort?
I have my data grid and sort on a column but the row formatting stops working. I simply selected a format using the autoformat option and picked classic. Am I meant to reapply the row formatting after the sort? And if so how?
View 1 RepliesI have tried several different approaches .SOMEONE PLEASE sow me how to sort on template field with a calculated value.Basically i have half the data i need in the DB and the other half comes from textbox1.textI take the text in textbox1 and pass it along with a value from the DB (Orig) to a function that returns miles.
[Code]....
Whit the above method everything displays correctly but i cannot sort on that column .I also tried using the miles() function in my select statement for my datasource but that was a nightmare and couldn't get that to work i either got "undeclared function "miles()" or when i fixed that i got "orig" not declared.Sorry code is so jumbled , entire code is below:
[Code]....
Would it be possible to do Sorting and Paging in a DataGrid, My dataGrid is place inside an asp:wizard which is inside an Update Panel.
[Code]....
I have a gridview control set up like so:
[Code]....
I am using an IComparer to do the sorting of the gridview and binding it to a list of objects. It used to be that the linkbutton in the first template field was being done like this:
[Code]....
The sorting worked just fine when it was like this, but I would prefer not to use a querystring value. The problem with using the linkbutton is that the sorting appears to work (there are only two rows in my test case and they change places), but when the linkbutton is clicked on it is in the same order before the sort took place. After each sort the gridview's datasource is reset to the newly sorted list of objects and the databind method is called.
I have an item template field retrieving a date field from an Oracle 11g database that can be null. The date is converted to a string before binding to the gridview. When the column is sorted is is being sorted as a string. I have read in several places if you add a formatting string to the eval statement in the item template that the sort operation will then sort the string as a date. However, I cannot get it to work. I also tried a bound column, but the column is still being sorted as a string.Code from the aspx page:
<asp:TemplateField HeaderText="Comp Date">
<HeaderTemplate>
<asp:LinkButton ID="sortDatea" runat="server" CommandName="Sort"
[code]...
I have datagrid and inside this grid have template field. I add Header text progr. like this
gvData.HeaderRow.Cells(8).Text = "Hi"
But when I do this I can not sort this column when add SortExpression="Hi"
I have a grid containing images loaded from database. the images are displayed in the order as they are stored in the database. Is there any way to change the order of the images manually once after they are uploaded to the database.. the admin before publishing the images to front end, should be able to arrange the images as he/she wish and then finally stores them in database.
View 5 Repliesi want to create dynamically inside a datagrid templatecolumn some buttons and i wonder how can i refer to them from the vb code..
View 9 RepliesI have a datagrid and there is a checkbox which is template in each row. Suppose I am in CheckedChanged event of one of the checkboxes. Is there any way I can tell in which row of the datagrid that check box is in?
View 3 RepliesI have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
i have textbox in a datagrid template and i want to read each of textbox data and save to database by clicking the button not in a datagrid under the datagrid. what i must to do?
View 6 Replies