Ive an page with listview.. i'm performing sorting in itemdatabound event like below:
[Code]....
and my listview looks like this:
[Code]....
I want to sort with multiple columns.
I have a simple dynamic gridview with following code -
GV = new GridView();
How to make a sort (asc / desc) in my ListView through a dropdownlist?
View 2 Repliesi would like to sort a listview. i don't have a datasourceID. i bind the datasource manually. i think of using jquery(tablesorter) but i don't know how to use it.
View 1 RepliesI have a button that I would like to click and will put my Listview list in Descending order. However; when I click on the button nothing happens.
[code].....
see the following code:
[Code]....
I have another 6-8 fields for the same listview. Due to the amount of fields, some of the field heads are wrapping and are not following the center alignment.
Is there a way I can center align the fields?Also, my listview does not sort. Is there something I am missing here?
I have a listivew that is assigned a datasource in the code behind based on query string options. From what i have found out, once there is no datasource assigned in listview html then the sort feature stops working automatically and you must put the code in the _Sorting event. I cannot find a good example of this logic.
good example of the listview manual sort logic?
I have a Listview control that DataBind programatically... ie I am NOT using SqlDataSource or such... I am attempting to sort a column... clicking on a link button that fires the "Sorting" event. So, after cliking on the column heading... I end up in this routine, where I hardcoded the .Sort = values (just for testing). The code is executed... but the RESULT show via Listview remains the SAME. No change!
How to fix this? I've seen some other posts examples that uses this event (ListView1_Sorting) and then sort via LINQ. I am not ready to try that...
Just want to know why dsPaymentList.Tables[0].DefaultView.Sort does not work?
I followed the example at: [URL]
protected void ListView1_Sorting(object sender, ListViewSortEventArgs e)
{
string sortExpression = e.SortExpression + " " + e.SortDirection;
DataSet dsPaymentList = new DataSet();
[Code]....
In gridview I am able to sort on 1 column as mentioned below, I want to add one more column in sorting, what is the best way to do this,
[Code]....
how to sort DataGrid column. (Say like FirstName) I have done snippet like: (see Bold text) For HTML :
<asp:DataGrid ID="dtgCustomerSearch" runat="server" AllowSorting="true">
<Columns>
<asp:BoundColumn HeaderText="CustomerID" DataField="CustomerID" />
<asp:BoundColumn HeaderText="First Name" DataField="FirstName"
SortExpression="FirstName" />
<asp:BoundColumn HeaderText="Last Name" DataField="LastName"
SortExpression="LastName" />
<asp:BoundColumn HeaderText="Phone No." DataField="Phone" />
<asp:BoundColumn HeaderText="Email ID" DataField="EmailID" />
</Columns>
</asp:DataGrid>
On Page_load I have wrote: this.dtgCustomerSearch.SortCommand += new DataGridSortCommandEventHandler(dtgCustomerSearch_SortCommand);
private void dtgCustomerSearch_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
SortExpression = e.SortExpression;
BindTheGrid();
}
string SortExpression
{
set
{
if (ViewState["SortExp"] == null || value != ViewState["SortExp"].ToString())
{
ViewState["SortExp"] = value;
}
else
{
ViewState["SortExp"] = value + " DESC";
}
}
get
{
return ViewState["SortExp"] == null ? string.Empty : ViewState["SortExp"].ToString();
}
}
Is there a way to Sort a Gridview by a Calculated Column? I have a gridview with template fields using lablels and a linq datasource. Those columns sort just fine. I can not get the Calculated column to sort, because there is no sort expression to use...
View 4 RepliesI have a gridview column named "Job Number" and the number is in this format: 01-04-11-3215, 01-04-11-3216 and so on...
Since the first few characters represent the date I need to sort on the last 4 digits.
I have a datatable as a datasource to a grid view, it has a column amtDue, i would like to be able to sort by this column,, while not displaying it.
View 4 Repliesi have a gridview that has the ability to sort by each of the columns, but suppose if i'm on page 2 of the results and sort any of the columns, it jumps back to page 1. is there a way to keep it on page 2, still have the sorted date work?
View 3 RepliesAllowSoting is true on every column of my gridvieww.
i want to remove those underlines in everycolumn ...
how can i do that?
I have been struggling with this problem for a long time. Does anyone have any clue about this problem? I created a gridview and set the allowsorting to true. This gridview has four columns: Name, Position, StartDate, and EndDate. I want the gridview to be sorted on the EndDate.
Inside of the save event, I called the BindGrid() function to rebind the datasource to the gridview. The changes will shown immediately, but the problem is that the records are not sorting on EndDate. I have to refresh the page manually to get the view sorted.
<asp:GridView ID="gvInfos" runat="server"
CheckBoxEnabled = "true"
ShowEmptyTable = "true"
AutoGenerateColumns = "False"
CssClass = "gv_white"
DataKeyNames = "Id"
GridLines = "None"
Width = "100%"
AllowSorting = "true"
>
<Columns>
<asp:ButtonField CommandName="Select" DataTextField="Name" HeaderText="Name" />
<asp:BoundField DataField="Position" HeaderText="Position" />
<asp:BoundField DataField="StartDate" HeaderText="Start Date"
DataFormatString="{0:Y}" />
<asp:TemplateField HeaderText="End Date" SortExpression="EndDate">
<ItemTemplate>
<%# (((DateTime)Eval("EndDate")).Year == (DateTime.MaxValue.Year) || (DateTime)Eval("EndDate") == null) ? "Present" : ((DateTime)Eval("EndDate")).ToString("y")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
I have a grid view with manual sorting. In some cells, the data are numeric and datetime. But due to some constrains, the data type on tables are varchar. The problem here is when I sorting those numeric data, it is treated as varchar.Eg: 1, 12, 13, 2, 23, 3, ...But I wanted the order to be: 1, 2, 3, 12, 13, 23, ...I have tried these method, but it doesnt works.
[Code]...
I have a page with a TextBox, a Button, a GridView, and a SqlDataSource. I click the Button to execute the SQL in the TextBox using the SqlDataSource. The SqlDataSource populates the GridView. Everything works as expected until I click a column heading to sort.
When I click a column heading, the GridView disappears and I have to click the Button to display the grid again. When I do, the grid is displayed in the order of the column I clicked.
I don't understand why the GridView is disappearing when I click a column header.
Does anyone know how to fix this so the GridView is sorted and displayed only by clicking the column header?
ASPX:
[Code]....
Code behind:
[Code]....
I have several grid views indide div's, and when I click the Sort header on an open div the div collapses and no sort happens. I believe it is just reloading the entire page but when I surround PageLoad with !ISPostBack then the page redraws as blank. Since the sort script is generated by the GV, I don't know how to stop it from creating side effects.
Here's my code:
<script type="text/javascript" language="javascript">
function toggleDisplay(id) {
var obj = document.getElementById(id);
obj.style.display = (obj.style.display == "none") ? "" : "none";
return false; // cancel the href
}
</script>
[Code]....
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 Replieswondering if someone can possibly help me out with a gridview. I have data coming into a grid and I know how to filter the data using one dropdown, I'm trying to get a little more advanced now. I'd like to filter using three dropdowns.
This is what I have so far: I don't know how to hook the downlists to the query?
<asp:DropDownList runat="server" id="DropDownList1" Width="90px">
<asp:ListItem Value="item_num">Item #</asp:ListItem>
<asp:ListItem Value="lot_num">Lot #</asp:ListItem>
<asp:ListItem Value="production_code">Production Code
</asp:ListItem>
<asp:ListItem Value="batchcode">Batch Code</asp:ListItem>
<asp:ListItem Value="inbound_no">Inbound #</asp:ListItem>
<asp:ListItem Value="recv_date">Received Date</asp:ListItem>
<asp:ListItem Value="location">Location</asp:ListItem>
<asp:ListItem Value="category">Category</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList runat="server" id="DropDownList2" Width="160px">
<asp:ListItem Value="=">is equal to</asp:ListItem>
<asp:ListItem Value="<=">is less than or equal to
</asp:ListItem>
<asp:ListItem Value=">=">is greater than or equal to
</asp:ListItem>
<asp:ListItem Value="<>">is not equal to</asp:ListItem>
<asp:ListItem Value="begins with">Begins With</asp:ListItem>
<asp:ListItem Value="Like">Ends With</asp:ListItem>
</asp:DropDownList>
<asp:TextBox runat="server" id="TextBox1" Width="150px">
</asp:TextBox>
<asp:Button runat="server" Text="Go" id="Button8" BackColor="Lime" />
<asp:Button runat="server" Text="Clear Filter" id="Button9" /><br />
<input name="Checkbox1" type="checkbox" /><label id="Label5">
Include Items containing "Zero on Hand" Quantity.<br />
Group by Fields: <input name="Checkbox2" type="checkbox" />
Item/Lot
<input name="Checkbox3" type="checkbox" /> Production Code
<input name="Checkbox4" type="checkbox" /> Batch Code</label><label id="Label4"></label><br />
<hr />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Font-Size="Small" BorderStyle="None" BackColor="White" GridLines="Vertical" BorderColor="#999999" BorderWidth="1px" CellPadding="3" Font-Underline="False"
AllowSorting="True" AllowPaging="True" PageSize="20">
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<Columns>
<asp:boundfield DataField="STATUS" HeaderText="Status" SortExpression="STATUS">
</asp:boundfield>
<asp:boundfield DataField="ITEM_NUM" HeaderText="Item #" SortExpression="ITEM_NUM">
</asp:boundfield>
<asp:boundfield DataField="LOT_NUM" HeaderText="Lot #" SortExpression="LOT_NUM">
</asp:boundfield>
<asp:boundfield DataField="LOT_EXT" HeaderText="Lot Ext" SortExpression="LOT_EXT">
</asp:boundfield>
<asp:boundfield DataField="RECV_DATE" HeaderText="Recv Dt" SortExpression="RECV_DATE">
</asp:boundfield>
<asp:boundfield DataField="PRODUCTION_CODE" HeaderText="Prod Code" SortExpression="PRODUCTION_CODE">
</asp:boundfield>
<asp:boundfield DataField="QTY_ONHAND" DataFormatString="{0:NO}" HeaderText="OnHand" SortExpression="QTY_ONHAND">
</asp:boundfield>
<asp:boundfield DataField="QTY_RESERV" HeaderText="Reserv" SortExpression="QTY_RESERV">
</asp:boundfield>
<asp:boundfield DataField="QTY_AVAIL" DataFormatString="{0:N}" HeaderText="Avail" SortExpression="QTY_AVAIL">
</asp:boundfield>
<asp:boundfield DataField="QTY_ADJUST" HeaderText="Adjust" SortExpression="QTY_ADJUST">
</asp:boundfield>
<asp:boundfield DataField="QTY_SHIP" HeaderText="Shipped" SortExpression="QTY_SHIP">
</asp:boundfield>
<asp:boundfield DataField="QTY_RECV" HeaderText="Recv" SortExpression="QTY_RECV">
</asp:boundfield>
<asp:boundfield DataField="PROD_DATE" HeaderText="Prod Date" SortExpression="PROD_DATE">
</asp:boundfield>
<asp:boundfield DataField="RELEASE_DATE" HeaderText="Release" SortExpression="RELEASE_DATE">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" ForeColor="White" Font-Bold="True" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
<asp:SqlDataSource runat="server" id="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:RemoteRooster %>" SelectCommand="SELECT * FROM [INVENTRY] WHERE OWNER = 'CompanyName' AND QTY_ONHAND > '0'">
</asp:SqlDataSource>
If the grid column is clicked to sort i dont want to retireve data agian, i can get it from viewstate, but i dont know if that triggered the post back or if the ImageButton on the page triggered it
View 5 Repliesi need to sort the gridview based on the radiobuttons. and i have 3 radiobuttons like dept,empcode,reporter..
if i click on any of radiobutton i need to show the gridview by sorting order..
I have read all kinds of great things about the new List View (well it was new when 3.5 was introduced). But I have not figured out how to set the width of a column. I have tried setting width in Layout, Item, Alternate, but none seems to affect the width.In related question, is there any way to hide a column?
View 4 RepliesI have the following ListView:
<asp:ListView ID="ListView1" runat="server" DataKeyNames="ListItemID"
DataSourceID="SqlDataSource1">
<LayoutTemplate>
<table id="ListItemsTbl" runat="server" style="width:460px; overflow: hidden">
<tr>
<th>
<asp:LinkButton runat="server" CommandName="sort"
CommandArgument="ItemDescription" Text="Description" />
</th>
<th>
<asp:LinkButton runat="server" CommandName="sort"
CommandArgument="ItemURL" Text="Link" />
</th>
<th>
<asp:LinkButton runat="server" CommandName="sort"
CommandArgument="ItemPrice" Text="Price" />
</th>
<th>
<asp:LinkButton runat="server" CommandName="sort"
CommandArgument="ItemBoughtBy" Text="Bought By" />
</th>
</tr>
<tr id="itemPlaceholder" runat="server" />
</table>
</LayoutTemplate>
<ItemTemplate>
<tr id="row" runat="server" class='<%= Container.DataItemIndex % 2 == 0 ? "row" : "altrow" %>'>
<td style="width: 10%; overflow: scroll;"><%# Eval("ItemDescription") %></td>
<td style="width: 10%; overflow: scroll;"><%#Eval("ItemURL")%></td>
<td style="width: 10%; overflow: scroll;"><%#Eval("ItemPrice")%></td>
<td style="width: 10%; overflow: scroll;"><%#Eval("ItemBoughtBy")%></td>
</tr>
</ItemTemplate>
</asp:ListView>
but the styles have no effect on the listview which just splats itself all over the screen!
What am I doing wrong? How do I control the appearence of the listview?