C# - Sorting Specific Column In A GridView After A DataBound?
Feb 9, 2010
I have given an access to stored procedure, which i'm not able to edit. This Stored Procedure returns a Table with 2 Column, what I did is set a GridView's DataSource using SQLDataSource in this stored procedure. but I want this GridView to Sort an specific column to descending whenever this GridView Loads.
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource2" ForeColor="Black"
Width="58%" Height="125px" AllowPaging="True" AllowSorting="True"
PageSize="5" >
<Columns>
<asp:BoundField DataField="DateOccur" HeaderText="Login Date"
SortExpression="DateOccur" />
<asp:BoundField DataField="TotalMinutesPlayed" HeaderText="Total Minutes"
SortExpression="TotalMinutesPlayed" />
</Columns>
<AlternatingRowStyle BackColor="#EFEFEF" />
</asp:GridView>
View 2 Replies
Similar Messages:
Jan 10, 2010
I want to created a messaging system and to display the messages. I want to use a gridview. My problem is how can I display the new messages in BOLD rows and the readed messages in normal text.
View 7 Replies
Apr 6, 2010
I have a data bound column in grid view. When a particular value in a cell is getting processed I want to display an image in the cell.
View 2 Replies
Jun 10, 2010
i have a GridView bound to a DataView. Some columns in the DataView's table are foreignkeys to related tables(f.e. Customer). I want to enable sorting for these columns too, but all i can do is sorting the foreignkey(fiCustomer) and not the CustomerName.
I have tried this without success(" Cannot find column ERP_Customer.CustomerName "):
<asp:TemplateField HeaderText="Customer" SortExpression="ERP_Customer.CustomerName" >
A tried also the DataViewManager, but i've a problem to detect the table to sort:
[code].....
I have to apply the sort on a distinct table of the DataViewManager, but this table would differ on the related tables.
I have bound the TemplateColumns in Codebehind in RowDataBound-Event f.e.:
Dim LblCustomer As Label = DirectCast(e.Row.FindControl("LblCustomer"), Label)
LblCustomer.Text = drCharge.ERP_CustomerRow.CustomerName 'drCharge inherits DataRow
What is the recommended way to sort a GridView on columns related to other tables? I could build a custom datatable with the customername instead of the foreignkey and bind this column to the TemplateField. But then my huge dataset in the model makes no sense anymore.
EDIT: I have a model with a Dataset. I'm binding one Datatable(ERP_Charge) from it to my GridView(actually i take a Dataview from that Table). In this Datatable are columns that are related to other Datatables in the Dataset(relations are defined). When i want to make the grid sortable its no problem on the columns that belong to ERP_Charge.
But the columns with foreign keys to other table could not be sorted because the Gridview shows f.e. not the CustomerID but the Customername. I get the Customername in RowDataBound. Normally i would join the tables and add a Datacolumn for the Customername.
View 1 Replies
Aug 18, 2010
I have a Gridview, which I bind to a Dataview programtically. My Gridview has 11 columns. Sorting works fine as long as I do not remove any columns programtically.
In certain cases I remove 2 of the columns from the Gridview. Still not a problem. All the data is properly displayed however the problem occurs when I sort one of the columns. I sort the Dataview and bind to the Gridview again. Data from two of my columns just vanishes. Both of these columns are based on ItemTemplates. The columns are still displayed but just empty cells.
View 1 Replies
May 10, 2010
I have a stored procedure (For Eg: sp_GetAvlData) that accepts a number of parameters, 3 of which are TimeFrom, TimeTo (as varchar) and TimeInterval (as int), formulates a Dynamic query and executes itself. So for instance, if I call the proc as follows:
[code]....
dtAvl is the datatable containing the results of my stored procedure.
The next step for me is to make each of the cells (except the cells in the first column) as a Hyperlink so that when clicked upon a cell, it populates 2 textboxes with the selected Timeslot and Name or ID (ID field is not displayed in Gridview). The textboxes are located on the same page but outside of the Gridview control.
The Challenge that I'm facing out here are:
1) As you can see, the field names being generated are not fixed and I have no control over them.
2) Because the field names are not fixed I'm not sure I can implement this using the Templatefields or BoundFields of Gridview.
Is there any way to achieve the Hyperlinking of these cells within the Gridview?
View 3 Replies
Apr 19, 2013
I have a gridview with 10 columns , i want sort the gridview column and im using bound field and template field
How can i make a sorting in grid in ASP.Net using VB.Net?
View 1 Replies
Jun 16, 2010
i want to sort a gridview column which is a template field with a repeater control in it. this column has multiple links and i would like to sort using the first link. how can i achieve this.
here is my code:
<asp:TemplateField HeaderText="Groups">
View 2 Replies
Mar 19, 2010
In gridview columns im displaying date and time, as below.
23/02/2010 11:19:52
Im also doing sorting on these columns.
But the issue is during sorting its only sorting on "day (dd)"....
for example....these 3 values are from column, Date.
23/02/2010 11:19:52
18/02/2010 10:25:10
17/03/2010 09:30:51
when I click for "Ascending" sort....it should get "17/03/2010 09:30:51" on the top (because of month 03) others have 02, but it doesnt, it gets in the above order, its just sort on day (dd).Below is my code for boundfield....
<asp:BoundField
DataField="Date"
HeaderText="Date" [code]...
View 6 Replies
Jul 7, 2010
Dear all; I have the following gridview
Type Cost
BENZ 40,000
TOYOTA 20,000
Now, I would like a situation if either TYPE or Cost is clicked on, it would sort things in ascending order. see example below.
if Cost is clicked on, we will have the following sorting order.
Type Cost
TOYOTA 20,000
BENZ 40,000
I am still new to visual studio.net.
View 13 Replies
Feb 21, 2011
I am trying to change the text in the header column when the GridView is sorted by checking the SortedDirection of the GridView.
problem: The text in the header column gets changed after i have clicked three times to sort the GridView.
i don't understand my problem. it seems really simple to get it work...this is what i done on each databound
[Code]....
View 15 Replies
Jun 21, 2010
I have a auto column generated GridView in a page, I have a dynamically binded column in that gridview, when page loads then sorting option is available on all other columns except that dynamically created column.
[Code]....
View 1 Replies
May 14, 2010
I have a gridview control bound to a sqldatasource in c#. In the rowdatabound event I look at a value in a cell and use a function to evaluate the value and depending on that value I populate an added unbound column in my bound datagrid to show an excalmation point. I now want to sort by the column with the excalmation point.
View 2 Replies
Jun 2, 2010
whn i click edit button on grid before sorting on any column it is working properly...but once i click on any column for sorting n thn click on edit then the rows get sorted again and edit is set on some other row... plz help me...herez my code..
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
gv_photo.EditIndex = e.NewEditIndex;
bindgrid("album_id");
public void bindgrid(string sort)
string str = "select * from tbl_Album";
[code]...
View 2 Replies
May 7, 2015
How to disable editing the data in the cells of datagridview in c#?
View 1 Replies
Apr 4, 2011
how can i write a selector for specific column of GridView ?
i want to do something on mouseover of a GridView Column. and i want to do it once.
Here is my gridview :
<asp:GridView AutoGenerateColumns="False" Width="100%" ID="grvUsers" runat="server">
<Columns>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# eval("ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Html Output :
<table cellspacing="0" rules="all" border="1" id="grvUsers" style="width:100%;border-collapse:collapse;">
<tr>
<th scope="col">Delete</th>
</tr><tr>
<td>
<span id="grvUsers_Label1_0">23</span>
</td>
</tr>
</table>
GridView DataBound
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dr As DataRow
Dim dt As New DataTable
dt.Columns.Add("id")
dr = dt.NewRow
dr(0) = "23"
dt.Rows.Add(dr)
grvUsers.DataSource = dt
grvUsers.DataBind()
End Sub
View 1 Replies
Dec 17, 2010
I have column in database
ID From To s1from s2to s2price fare
1 Delhi Manali 17-Dec-2010 19-Dec-2010 $900 $600
2 USA Canada 18-Dec-2010 20-Dec-2010 $500 $800
3 Newyork salinas 19-Dec-2010 22-Dec-2010 $760 $1000
I want when any user search For: Delhi to Manali on between 17-Dec-2010 to 19-Dec-2010 then the price would be automatically changes to $900 in gridview else the default price wold be displayed in fare is $600 if he search for DelHi to Manali after 19-Dec-2010.
I m confused how to implement this logic ... using vb.net ...
View 1 Replies
Jun 23, 2010
get the specific column value from gridview.
View 5 Replies
Feb 16, 2010
How do you get a value in a specific row and column of a gridview assigned to a variable ?
View 2 Replies
Jun 25, 2013
I have 5 column, in first two column read only id in hidden field, but in UI first two column shows empty,this two column in UI does not show only show remaining three column, then how to hide first two column using css ...
View 1 Replies
Jan 14, 2010
I 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 Replies
Sep 26, 2010
Situation: 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 Replies
Mar 15, 2011
I want to set specific width size of a column inside grid view i tryed following things butit did not work:
I tryed through css through C# and to set properties for gridview like itemstyle/itemcontrol width = 150px
View 7 Replies
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
Feb 24, 2010
.NET with VB I have a simple Gridview written with bound columns that gives a summary of all projects assigned to the user viewing the page.
I am struggling with passing the value of my project_ID column of a row that is clicked. I have looked around all day at different things, one involved using TemplateField with and ItemTemplate instead to fill my coloumns in stead of BoundField. This worked nicely to draw my Grid with the correct data from my datasource. I still struggled with two things.1. Selecting the row either button or ondoubleclick like event that runs VB code on my .aspx.vb page 2. Then the code to set a variable to the value for my project_ID columnThis is so frustrating, this was soooo simple in MS Access that was an on doubleclick event. That I simple set up set the project_ID.value = gblproject_ID and then called the new forum with the datasouce of that form filtered on the gblproject_ID. I am starting to think moving my MS Access DB online to .NET is far over my head.
View 2 Replies
