Forms Data Controls :: How To Sort DataGrid Column

Oct 27, 2010

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();
}
}

View 5 Replies


Similar Messages:

Forms Data Controls :: Sort Static Text Of Hyperlink In Template Column Of Datagrid?

May 27, 2010

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 Replies

Forms Data Controls :: How To Change Sort Column Header Text And Retain The Sort Link

Jun 3, 2010

I have a simple dynamic gridview with following code -

GV = new GridView();

View 3 Replies

Forms Data Controls :: Sort The Datagrid (gridview) Programmatically

Dec 7, 2010

i want to sort the datagrid(gridview) programatically.

View 4 Replies

Forms Data Controls :: Inside The Datagrid Sort Command Want An IF Statement?

Mar 25, 2010

I have a datagrid that populates correctly and a drop down list.

I have a table with (below) and it popluates a drop down and works properly.

UploadFile -- UploadFileTypeID
-Select 0
Images 1
Spreadsheets 2
Documents 3

Inside the datagrid sort command I want an IF statement. But the IF statement I have now doesn't recoginze whats inside the SQL table ( == "Images").

I have this...

[Code]....

From my understanding this if (ddl_Upload.SelectedValue == .... Is only recognized if I would have listed -Select, Images etc as List Items for the drop down?

View 25 Replies

Forms Data Controls :: Datagrid With Column Choose To Choose Columns Dynamically Using DataGrid With Object Data Sour

Sep 30, 2010

I 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;
}
}
}
}

View 1 Replies

Forms Data Controls :: How To Sort Grid On Two Column

May 12, 2010

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]....

View 2 Replies

Forms Data Controls :: Multiple Column Sort In Listview?

Feb 25, 2010

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.

View 5 Replies

Forms Data Controls :: How To Sort A Gridview By A Calculated Column

May 25, 2010

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 Replies

Forms Data Controls :: How To Sort A Gridview Column By Last 4 Digits

Jan 6, 2011

I 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.

View 2 Replies

Forms Data Controls :: Sort A Gridview By A Column That's Not Displayed

Mar 22, 2010

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 Replies

Forms Data Controls :: Sort Gridview Column Without Going Back To First Page?

Mar 26, 2010

i 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 Replies

Forms Data Controls :: GridView Sort Column Header Underline?

Feb 17, 2011

AllowSoting is true on every column of my gridvieww.

i want to remove those underlines in everycolumn ...

how can i do that?

View 3 Replies

Forms Data Controls :: Gridview Doesn't Sort On A Specific Column After Updating

May 10, 2010

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>

View 11 Replies

Forms Data Controls :: How To Convert A Varchar Column To Int And Sort In Grid View

Jul 21, 2010

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]...

View 9 Replies

Forms Data Controls :: GridView Disappears When Click A Column Header To Sort?

Jul 28, 2010

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]....

View 9 Replies

Forms Data Controls :: Div Collapses Every Time Click On GridView's Sort Column Header?

Feb 8, 2010

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]....

View 6 Replies

Forms Data Controls :: How To Tell If The Event That Fired A Post Back Is The Gridview Column Click (to Sort The Grid)

Nov 17, 2010

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 Replies

Forms Data Controls :: Only Allow Editing Of One Column In Datagrid?

Mar 25, 2011

I have a datagrid which I only want the maintenance column to be editable (the other fields are only editable to admins at a different web page)

I've only just started messing with asp/SQL and would be very grateful for the help :)

Below is my code. I have tried messing with the update queries and it seems to mess up everytime some way or another. I'v

[Code]....

View 3 Replies

Forms Data Controls :: Need A Column Of Checkboxes In Datagrid

Feb 4, 2011

I've got a typed dataset that populates programmatically based upon dropdown selections from the user, and then is bound to a datagrid. One of the cols is a bit type (indicating whether or not that record is "active"). I would like that datagrid col to be exposed to the user as a bunch of checkboxes, which the user could turn on and off as needed, and then update the entire recordset according upon clicking Submit.

Is converting a dg column into checkboxes a straightforward thing to do?

View 3 Replies

Forms Data Controls :: Getting The Value Of A Button Column Of A Datagrid?

Apr 15, 2010

I have a datagrid that is supposed to display the list of uploaded word doc containing a specific word , this sort by the one having the greatest number of occurences(relevance).

It should allow the user to download one of the file by clicking on the button column .But im unable to get the text appearing in the datagrid nor the one in the button column

these are the table column

Firstname,Lastname,Path and Relevance

This is the code on item command:

[Code]....

the datagrid code:

<asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True"
BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"
CellPadding="4" ForeColor="Black" GridLines="Vertical" ShowFooter="True"
AutoGenerateColumns="False" onitemcommand="DataGrid1_ItemCommand"
Width="353px">
<FooterStyle BackColor="#CCCC99" />
<SelectedItemStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right"
Position="TopAndBottom" />
<AlternatingItemStyle BackColor="#6699FF" Font-Bold="False" Font-Italic="False"
Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
<ItemStyle BackColor="#F7F7DE" />
<Columns>
<asp:BoundColumn DataField="firstName" HeaderText="FirstName" ReadOnly="True">
</asp:BoundColumn>
<asp:BoundColumn DataField="lastName" HeaderText="LastName" ReadOnly="True">
</asp:BoundColumn>
<asp:ButtonColumn CommandName="getCv" DataTextField="Path" HeaderText="Cv"
Text="Path"></asp:ButtonColumn>
<asp:BoundColumn DataField="NumberOfOccurences" HeaderText="Relevance">
</asp:BoundColumn>
</Columns>
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
</asp:DataGrid>

May i know how to get the value of the button column been click?

View 2 Replies

Forms Data Controls :: Autosize Last Column In Datagrid?

Aug 2, 2010

I want to autosize the last column so it spans to the full width of the datagrid. I've messed about with the width and autosize but can't seem to get it right.

**figured it out with dataGrid_customer.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

View 2 Replies

Forms Data Controls :: Summing A Column In A Datagrid?

Jan 26, 2010

[Code]....

Summing a column in a datagrid

View 3 Replies

Forms Data Controls :: Hiding A Column In Datagrid?

Jun 24, 2010

I had a datagrid and I was hiding columns. This was working fine to show just the columns I wanted.

[Code]....

And then I realised I wasn't paging the data so I ticked that on then above code no longer worked. The Count was equalling 1 with the paging ticked on. Why would that be?

I also used the classic formatting and when I sort the columns the classic formatting goes funny, how can reapply the sorting to make it look classic?

View 2 Replies

Forms Data Controls :: Hyperlink Column On The Fly In Datagrid?

Jan 15, 2010

Is there a way to make a hyperlink column in datagrid on the fly... I have a search page and would like the user to be able to click a button to few full contents about the item for editing, etc.

View 11 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved