whenever I sort on a column it resets all my toggled columns back to visible. Is there a way to resort and keep the toggled columns that were selected as hidden to stay hidden?
View 2 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 dataset like this:
BidID....DistributionMonth....LbsRemaining
1...........08-2010.................50,000
1........... 09-2010................25,000
1............10-2010................25,000
1............11-2010................100,000
I have a report that shows this data by pivoting on the month and giving the remaining amount, like this:
BID......Aug-2010 Remaining........Sep-2010 Remaining.......Oct-2010 Remaining........Nov-2010 Remaining
1..........50,000...............................25,000...........................25,000..............................100,000
This all works just fine. However now, I want to take a date that's given, and make a "Past Due" column for anything less than the first of the month of that date.
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 RepliesI know the back button always presents a problem, but this one doesn't make any sense.
I have a simple details view and a button on a page. The button sends the user to the homepage. I am trying to prevent the user from being able to use the detailsview if they click Back in their browser.
This is the button click event
[code]....
When the button is clicked...oddly the user is sent to the homepage then when they click the browser back button they are sent to previous page with the detailsview still visiible.
I know I am missing something, can someone fill me in?
Why is the detailsview still visible?
I am trying to arrange the report parameters in three columns instead of two columns. I have about 13 report parameters . Is there a setting anywhere to be done.
View 6 RepliesSituation: 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 have gridviwe having 2 columns:
1) DocNumber 2)Title
query select docnumber,title from tbl_docs.
BindwithGridviwe(sql);
Now the issue is that that every document doesn't has document number. I want to make invisible the docuNumber column of the grid viwe if all values in the docNumber retrieved are null.for example:
docnumber tite
null Document 1
null Document 2
null doucment 3
null document 4
if returned result match above where all docnumber are null then make the gridviwe docnumber column ivisible eslemake the greidviwe column visible.
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 the sorted column.
I have a textbox that is used for searching. upon clicking the ok button and posting back, the function is called, and gets matching results by using sql query in the aspx.cs file this information will be displayed in the div tag and set visible. initially div tag will not be visible. after the button posts back, then the div tag will be set visible.
View 1 RepliesFor the data obtained from data set, how to design Sorting headers for Data Columns in grid view in asp.net?
View 1 Repliesi have a gridview populated by a Web Service search function. some of the columns in the grid are templatefields, because the values coming back from the search (in a datatable) are ids - i then use these ids to lookup the values when the rowdatabound event is triggered and populate a label or some such.
this means that my sorting function for these id/lookup columns sorts by the ids rather than the textual value that i have looked up and actually populated the grid with (although i do put the ids in the grids datakeys).
what i want to do is top be able to sort by the looked up textual value rather than the codes for these particular columns.what i was going to do to get around this was to when the datatable comes back from the search, adding more columns the textual values and doing all the looking up then, thus being able to sort directly from the manually added columns.
is there another way to do this? as that approach seems like a bit of a bodge. although i guess it does remove having to do the looking up in the rowdatabound event....
my sorting function works by sticking the datatable in the session and on each bind grabbing the sort column and binding the gridview to a DataView with the sort attribute set to the column - and the direction.
is it possible to disable sorting on specific columns? 5 out of 7 columns have to be sortable, two not sortable. The columns are created dynamically in code behind, so I think doing this with mark up is out of the question. When I say disabled, I'm hoping that the underline wont show on the column header when you mouse over it.
View 1 Repliesexplain what the Dynamic Data team was thinking when they designed grid sorting in Dynamic Data scaffolded tables? Sorting defaults to using all columns, in the order the appear in the model, often arbitrary very counter-productive.We've just had a run in with the 'out-of-the-box' sorting, and solved it with a simple SortExpression attribute on MetaTables. Another, even simpler solution would have been for them to avoid any sorting, allowing the DB to provide a default order based on clustered index.
View 1 RepliesI'm using Visual Studio 2008 and SQL Server 2008 SP1. I want to design data to show two columns in list as below:
Annual Appraisal Probation Appraisal
Sepcial Appraisal Comment
i got a problem trying to keep header visible when scrolling in a report the thing is that i'm doing exactly what says in this page [URL] the thing is that i can't get it to work viewing the option, i realize that the option that i have to check according to the page says "Header should remain visible while scrolling" the one i got in the visual studio 2008 is "Keep Headers Visible When Scrolling"
View 4 RepliesI have a 3 column layout using table-less design.
[code]....
The CSS:
#left {width: 200px;float:left;display:inline;}
#content {width: 600px;float:left;display:inline;padding: 0 10px;}
#right {width: 160px;float:left;display:inline;}
I am using a web application, and I can't change the layout. By can't change, I mean the div's with left/content/right cannot be removed.
On some pages, both the left and right columns are completely empty. And I want the #content div to expand more than the 600px.
is this possible, without altering the HTML?
I have created gridview with list daatsource. I want apply sorting event for gridview to sort all columns.Here is my code:
protected void grduAdminSerservice_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable tbl = grduAdminSerservice.DataSource as DataTable;
[code]...
How to sort grid view rows by multiple column?
View 1 RepliesHow to implement sorting in gridview with datasource present as viewstate since paging is required,and with columns conatining alphanumeric characters( sorting as like of windows explorer)
View 1 RepliesIs there a way of getting the current column being used to sort a table on an rdlc report ?I'd like a way of remembering how the user sorted the table so they dont have to reset it every time they open the form.I know I could make them use an on screen control (eg dropdown list) to change the sorting and then capture the choice as the report is loaded.But I'd rather do it in the background I can.
View 1 RepliesI am creating report in winfrom. I am having three radio button and one button , when user click on any of those radio button and click on the button the report has to sort according to that. I am not asking about interactive sorting.
View 4 RepliesI've been asked to take over a project that's filled with a bunch of bugs. It's currently using MVC 1.0 and there's a view with Html Helper Data Grid that uses a DataGridHelper class. I'm not that familiar with all of MVC yet, and I was wondering if it is possible to have the sorting of the columns be a POST event rather than a GET.
Currently when a user clicks a column to sort, the controller for the view calls the GET action method. This I guess is all fine and good, but the problem is that this view has a search form (which is a model in it's own right) with some text boxes and some drop down lists. When the GET action method is called, I lose all of the information in the search criteria. So when ever someone searches for something, but then wants to sort the results, it requries the db for all records (because all of the search criteria is cleared).
I guess there could be two solutions:
1) Is there a way to access the items in the search form / model in the GET portion of the action method? I've tried using ViewData or adding a parameter for the search form model, but (and maybe I'm doing it wrong) both return null.
2) Is there a way to make the sorting event of a column call the POST portion of the action method? That way I'll have the search form / model information and be able to sort the search result content instead of query for all records.
Also, there is a stored procedure that currently can handel all of possible search parameters. So, no matter what sort column is selected, or search parameters are entered, it can properly setup the sql query.
can i implement multiple column sorting in an ASP.NET DataGrid.Datagrid contains Template columns.
View 5 RepliesThis is the format of my report and I am trying to get the rows sorted.I do know about interactive sorting but I do not want to use it because this report will be called by an external web application and I want this report sorted before it is rendered to the user.
[code]....
I want this to be sorted by the second column in a descending order 5.0,4.0,3.0,2.0,1.0. I rightclicked the matrix,selected the sorting option and chose the grouping name( "Index" in my case) and chose Z to A (Desc I presume), saved and deployed to the server and when the report rendered it was not sorted by the second column(grouping).
Is it possible to achieve this? Does the report always render based on the first grouping in the ascending order (like Agree,Disagree...)