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 RepliesI have a grid with one itemtemplate field with autogenerated columns=true.I want to show the itemtemplate filed after autogenerated columns .
View 6 RepliesI 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.
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 RepliesI have a Gridview with autogenerated columns since the query structure keeps changing depending the dropdown list.
However for Jan-10 etc column I want to format it to #,##0 etc. I use Dataformatstring when hard code the column but for autogenerated column, what can I do ?
I know one way is in script databound event make it that format whenever header = Jan-10 etc.
What should be the code?
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 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 RepliesWhen 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.
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.
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 Repliesguide 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 RepliesI 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]....
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?
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">
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]...
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.
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]....
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]....
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 RepliesI have a HTML table with 5 rows and 2 columns.I have set the background color to gray, but I how do you eliminate the grid lines as they are displaying as white? I wish to remove/hide the grid lines and table border so that only the gray background color Gray shows.
View 4 Replieswhn 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]...
i have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view
View 5 RepliesI 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.
I have a boundcolumn that outputs string numbers. I have another column of checkboxes next to it. I need to have it so that when a user checks off a check box the value stored in the string column to the left is then plugged into a function on the server. How can I acheive this?Here is my code:
[Code]....
[Code]....
When creating a new column chart, by default a lot of space is inserted to the left of the first column in a series, and to the right of the last column. This means that a lot of space is wasted in the ChartArea.
How can I get rid of this spacing? In other words, how can I align the columns in a column chart so that the first column is all the way to the left of the chart area, and the last column is all the way to the right in the chart area?
Note: I have tried asking this question in the social.msdn "Chart controls" forum [URL], however there does not seem to be many people answering questions there.