.net - Sorting Defaults To Using All Columns, In The Order The Appear In The Model?
Feb 11, 2010
explain 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 Replies
Similar Messages:
Feb 6, 2011
I have a repeater using paging (see code below) I want to be able to offer a button that sorts the results by price and one for alphabetical order. I'm not sure how to achieve this with my current system. Would it just be a case of altering the sql select statement on click?
Private Sub BindRepeater()
Dim dv As DataView
dv = CType(SqlDataSource3.Select(DataSourceSelectArguments.Empty), DataView)
PagedResults.DataSource = dv
PagedResults.AllowPaging = True
PagedResults.PageSize = 9
PagedResults.CurrentPageIndex = CurrentPage
lnkBtnNext1.Visible = Not PagedResults.IsLastPage
lnkBtnPrevious1.Visible = Not PagedResults.IsFirstPage
Repeater1.DataSource = PagedResults
Repeater1.DataBind()
doPaging()
End Sub
[Code...]
View 4 Replies
Jan 8, 2011
I have a column TimePeriod with values in mmm-yyyy format. ex. Jan-2010, Apr-2010,Nov-2010, Dec-2010, Jan-2011
How can I wirte query so result will be in order by Jan-2010, Feb-2010,..... Jan-2011.
I tried to cast, convert but i couldnt figured it out. I did googling... can't find solution.
View 3 Replies
Aug 14, 2010
i m using asp.net 2005 with access 2003. i need a code using vb.
how can i sort the record in descending order?
View 3 Replies
Feb 6, 2011
I have a photo album gallery within my website and would like to allow users to sort the order of their photos within an album. After looking at very different ways I came across this example http:[URL]Admin=true which is exactly what I need.
The photo are stored in the uploads directory and details in the database. The images are displayed using the ListView as shown below:
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1" GroupItemCount="15">
<LayoutTemplate>
<table id="groupPlaceholderContainer" runat="server" border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse; width: 100%;">
<tr id="groupPlaceholder" runat="server">
</tr>
</table>
</LayoutTemplate>
<GroupTemplate>
<tr id="itemPlaceholderContainer" runat="server">
[Code]....
View 1 Replies
Feb 16, 2012
Here's my gridview when it comes it it's sorts on Age. Sorting is available for all columns/headers. How do I make the sort order to change on the ddsrpt sort to desc order when it's clicked?
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource7" EnableModelValidation="True" Width="789px"
CaptionAlign="Top" Height="126px" BackColor="White" BorderColor="#DCBE68"
BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
HorizontalAlign="Center" CellSpacing="2" Font-Names="Arial"
AllowSorting="True" EmptyDataText="No Records" DataKeyNames="FO,CLMSSN">
[Code] ....
I got this error message - Gridviewsortdirection is not declared
View 1 Replies
Jul 6, 2010
With my model, I have one view model using another as its base. In my case, BaseUserModel is inherited by CreateUserModel, in order to share common properties such as Username and Password. My CreateUserModel adds to that by having ConfirmPassword, Email, SecurityQuestion, etc.
My problem is, when using the ValidationSummary() Html helper, the validation is obviously in order of the properties in my model. Basically, because of the inheritance I have going on here, the errors are not in the correct order.
Is it possible to control when or how these validation rules are added to the list? The only attribute I'm using is Required.
View 2 Replies
Sep 26, 2010
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.
View 1 Replies
May 3, 2010
I've got a tough one (at least for me!). I have a gridview control which is actually from ComponentOne but most is the same as the normal gridview. It has a feature that lets me move columns around so they are in different order. I want to be able to click a button and see the order of these columns and which ones are visible. This is to be used for a custom report I am generating.
Does anyone know how to find out what columns are visible and in what order? I'm doing it in VB coding for asp.net.
View 3 Replies
Apr 12, 2010
For the data obtained from data set, how to design Sorting headers for Data Columns in grid view in asp.net?
View 1 Replies
Jun 15, 2010
i 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.
View 1 Replies
Sep 30, 2010
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 Replies
Mar 31, 2010
How is it possible to change the displayed order of columns from a DataTable?
For example, dataTable "dt" contains two columns "a" and "b". I bind it to a GridView like this:
gridView.DataSource = dt;
gridView.DataBind();
But I'd like the GridView to display "b" first (leftmost).
Important point: I'm using this to export to Excel and there's no actual output to screen, using:
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridView.RenderControl(htw);
View 2 Replies
Oct 8, 2013
how to change order of grid view column,after binding it through database in asp.net web application
View 1 Replies
Oct 29, 2010
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]...
View 1 Replies
Jul 23, 2012
How to sort grid view rows by multiple column?
View 1 Replies
May 7, 2015
How 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 Replies
Jul 22, 2010
I'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.
View 6 Replies
Mar 4, 2011
can i implement multiple column sorting in an ASP.NET DataGrid.Datagrid contains Template columns.
View 5 Replies
Feb 6, 2011
I have a photo album gallery within my website and would like to allow users to sort the order of their photos within an album. After looking at very different ways I came across this example
http://www.west-wind.com/rick/photoalbum/demoMaui2006/Default.aspx?Admin=true which is exactly what I need.
The photo are stored in the uploads directory and details in the database. The images are displayed using the ListView as shown below:
[Code]....
I would like to rearrange the order of the photos; change the captions and/or delete the photos just like as in the example.
So could someone please provide the steps that I need to follow in order to achieve the following:
Firstly to display the photos from the Photo table in the database (can use the above listView) Rearrange the order; change caption and/or delete the photo(s) Final to update the changes in the Photo table
I am new to programming, especially jQuery so could you kindly provide/explain the steps that I need to follow.
View 8 Replies
Dec 15, 2010
How to change GridView columns order or index during runtime.
View 2 Replies
Dec 21, 2010
In gridview boundedField, some Departments are listed like:
CIT
Customer Change Mind
Customer Issues
Logistics
Regional Engineering
Regional Sales
Can I change the order like:
Regional Sales
Regional Engineering
CIT
Logistics
Customer Issues
Customer Change Mind
I mean to say the list will not be on Asc or Desc. May I change order as per my own list order?
View 6 Replies
Mar 3, 2010
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 Replies
Aug 13, 2010
I have a gridview to which I am binding a database values. My requirement is to bind the values to the gridview by sorting 3 columns as a default sorting with ASC order in one column and descending order in other two.. Can I do it in my .Net code or should I do that in Stored Procedure? If it can be done in .net code Can you tel me how it can be done.
View 2 Replies
Jan 3, 2011
I 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.
View 5 Replies
