Forms Data Controls :: Grid Sorting When Column Is Determined During RowDataBound?
Mar 3, 2011
I have a Gridview with a templated column which contains just a label.
I set the Label1.text during GridView1.RowDataBound based on doing a DataBinder.Eval(e.Row.DataItem,"myColumn") and a calculation off that.
When the user clicks the header I want it to sort based on what's in the Label but instead if seems to be sorting on the contents it was bound to, "myColumn", even though that's not what appears in the grid.
View 2 Replies
Similar Messages:
May 10, 2010
I have autogenerated columns some columns come from db and some are virtual columns what i am adding to a dataset that consist of columns from db.i want to disable sorting for the virtual columns which i add to dataset
View 2 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
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
May 27, 2010
Am using the following 2 events for child grid.
1. RowDataBound
2. RowEditing
I enable AutoGenerateEditButton = "true", which can show me edit button in the child grid. Also i have tried to use the event rowediting which can return e.NewEditIndex too. for the master i use sqlDatasource design time. for the child grid am confusing how to do the edit/delete/add.
following link good enuf for master grid
[URL]
for child grid datasource if am not mistaken, guess need to assign the datasource during runtime. am not sure how to do this?
Following is the link for my so far trial
[URL]
[Code]....
[Code]....
View 4 Replies
Feb 3, 2010
I would like to ask how can i make the gridview just underline the first column by using the rowdatabound.
Currently my code using as below:
protected void gvResult_RowDataBound(object sender, GridViewRowEventArgs e)
View 3 Replies
Mar 24, 2010
I have an internal web application which uses a custom encryption class to convert strings to varbinary(50) columns in SQL. When I display the table in a GridView, I want to use the RowDataBound event to decrypt the encrypted column back to a string to display.
Currently I have the following in my RowDataBound event:
[Code]....
This throws an exception when I try to load the page: TransformFinalBlock - Length of the data to decrypt is invalid.
I have tried just fetching the data from SQL in my query but the e.Row.Cells(3).Text evaluates to System.Byte[], so I tried using CAST([EncrytedColumn] AS varchar(50)) to convert the varbinary(50) to varchar(50), but this still resulted in the same exception being thrown.
My only solution so far has been to manually fetch the SQL data into a DataTable and decrypt the column before displaying it in the GridView, but I prefer the automated method of binding the SQLDataSource to the GridView.
View 2 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
Feb 27, 2011
i have a gridview and dynamically creating columns and bounding using datareader source.
HyperLinkField hFld = new HyperLinkField();
hFld.DataTextField = dataReader.GetValue(1).ToString();
hFld.HeaderText = "Doc No";//dataReader.GetValue(2).ToString();
i want to to replace the hyperlinkfield with a template field that contains a hyperlink WITH ID where hyperlinkfield does not have ID and be bound to the same datasource above because i want to make the abililty to set the navigate url attribute using rowdatabound
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink hFld = (HyperLink)e.Row.FindControl("hyperlinkID");
lnkTicket.NavigateUrl =
"javascript:w=window.open("+e.row.cells[2].text+".pdf','','width=400,height=400')";
}
}
View 4 Replies
Aug 4, 2010
I know that variations of this same question have been posed numerous times - but I can't quite seem to find the exact solution.
I would like any row in my gridview where the boolean field "Approved" is True to be shaded gray. Here is the code that I'm using, but every row ends up being gray, regardless of the value in that "Approved" field. My guess is that I'm not correctly evaluating the boolean value in this field (which is actually a yes/no field in MS Access), Not sure if I should be reading that value as "-1", "Yes" or "True" or "NotNull"? Anyway, here is the code:
[code]....
View 4 Replies
Mar 7, 2010
I have database status field Bit(0/1) this values binding to gridview column. i want to show record status instead of 0 and 1 display open or close
View 5 Replies
Apr 28, 2010
I have a nested GridView with id grd_inner. i have to find a linkbutton in template field of grd_inner and add some attributes to it. but its giving me error.
[code]....
This code is giving me error that
grd_inner doesnot exists in the current context.
View 5 Replies
Jun 21, 2010
When i try sorting in the database, it sorts the numbers:
1
102
2
304
305
4
4 Rev 01
etc....
but i want to have it sorted like:
1
2
4
4 Rev 01
102
304
305
What must i do to make it so? I just use a normal datagrid with sorting capabilities enabeld. Data type is varchar.
View 13 Replies
Feb 2, 2011
I have an entity "Order", which contains a set of states. Every state has date and name.
I want show grid with all orders and in grid one column with last state of order. But I dont understand how to do it.
View 1 Replies
May 13, 2010
how to implementing sorting in grid view..... iam using allowsorting=true property.... bt it sorting will not perform on boundedfileds..then i implement Onsortingevent.. bt what is the code for that.... and code for changing sort direction..
View 3 Replies
Feb 3, 2010
guide how I can sort grid data when header is not shown. Actually In my page I have set visibility of header to false and have placed headings in table above the grid (it was done because requirment was to fix header and make grid with scrollable).how I can give sorting functionality with headings in table above the grid
View 2 Replies
Jul 20, 2010
I go this code that can so a manual sorting on grid view. The code works fine for "ASC", when I wanted to sort the field to DESC, it never works. Second, it also failed when I switch to another page. Case 1: By default, the column is sorted DESC, then I switch to ASC, works fine, then I switch to DESC, it failed (remain at ASC).Case 2: By default, the column is sorted DESC, then I switch to ASC, works fine, then I switch to other page, it failed (remain at DESC on new page).
[Code]....
View 6 Replies
Dec 1, 2010
Split off from http://forums.asp.net/t/1595139.aspx:
I have an additional column called 'KPI %' in my gridview that calculates the percentage of two template fields and thus I cannot use the sortexpression on it. How can I sort the contents of the 'KPI %' column in ASC or DESC format?
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
Aug 17, 2010
In my application binding list is used to to bind the Data to Grid view. Now the requirement is to sort on 3 columns when I bind the data to the Grid View . How can I do this?
View 4 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
