Solved

Sort a gridview

Posted on 2014-02-24
6
255 Views
Last Modified: 2014-02-26
Hi
I have a gridview that sources its data from various sources..
For example...
The first two columns, Username and a date, are populated from a query that is coded inline...

Then, in the rowDataBound event for the gridview, I grab the username and perform further queries/Calculations using this username as a key to provide information I populate the rest of the columns with... (by modifying template fields in the gridview that hold label controls).

This all works fine, but I now am thinking that I might like to be able to sort this gridview on some of the fields that aren't populated by the inline query...

So, I was thinking that all I needed to do was pull the data out of the gridview into some sort of list or array, sort it there, then re-populate the gridview from this list/array...

Is this the right way to do this, or am I missing something obvious??

The issue is that the fields in the gridview aren't populated from the same query (and can't be), but I need a way of sorting the data and re-populating the gridview should the user wish to..

Any help would be appreciated..

thanks in advance..
0
Comment
Question by:jcm4101
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 16

Expert Comment

by:SriVaddadi
ID: 39883941
Not sure what are you using as DataSource but if it could be converted to DataView then you could use Sort expression on DataView and re-assign the sorted data source to grid view
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 39883977
If I was still working with ASP.NET Web Forms (and not MVC), then I would be choosing the ObjectDataSource, which can coordinate with the GridView to handling paging and sorting.  

ObjectDataSource Class
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdatasource.aspx

An ObjectDataSource control works with a class that you create. You create methods that retrieve and update data, and you provide the names of those methods to the ObjectDataSource control in markup. During rendering or postback processing, the ObjectDataSource calls the methods that you have specified.
0
 

Author Comment

by:jcm4101
ID: 39884928
Thanks for the responses... Let me re-phrase the question, and approach the problem from a different angle....

I want to end up with a gridview that has several (40+) rows of data.
Each row pertains to an employee, so for example....
Column 1 = username (unique)
Column 2 = Accrued Leave Entitlement
Column 3 = Annual Salary
Column 4 = something else
Column 5 = something else again
etc.....
There are 13 columns in the actual table...

The information to populate each column comes from several different SQL data sources, so can't be queried for in a single query...

Is there a way of populating some sort of collection, keyed on the unique username, and then populate each of the "columns" for that user so that I can sort it on any particular column, then bind it to a gridview already sorted?

Thanks again for your help..
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 96

Assisted Solution

by:Bob Learned
Bob Learned earned 250 total points
ID: 39885599
ObjectDataSource Strongly Typed Source Object Example
http://msdn.microsoft.com/en-us/library/ms227562(v=vs.100).aspx

In the example, you can see that the ObjectDataSource has properties that identify a method in a class to perform the CRUD operations.  These methods can perform any functions necessary to complete the operation, including complex steps of getting data from different sources.

<asp:ObjectDataSource
        ID="EmployeeDetailsObjectDataSource"
        runat="server"
        TypeName="Samples.AspNet.ObjectDataSource.NorthwindEmployeeData"
        DataObjectTypeName="Samples.AspNet.ObjectDataSource.NorthwindEmployee"
        SelectMethod="GetEmployee"
        InsertMethod="InsertEmployee"
        UpdateMethod="UpdateEmployee"
        DeleteMethod="DeleteEmployee"

        OnInserted="EmployeeDetailsObjectDataSource_OnInserted"
        OnUpdated="EmployeeDetailsObjectDataSource_OnUpdated"
        OnDeleted="EmployeeDetailsObjectDataSource_OnDeleted">
        <SelectParameters>
          <asp:Parameter Name="EmployeeID" Type="Int32" />  
        </SelectParameters>
      </asp:ObjectDataSource>
0
 
LVL 16

Accepted Solution

by:
SriVaddadi earned 250 total points
ID: 39885980
I can think of two approaches

1.  Write a database view which could pull data from different sources and use that view in your code

2. In the code, call different sources and populate a data table which you would use as a data source

In both the cases you could use sort expression to sort the data.
0
 

Author Closing Comment

by:jcm4101
ID: 39888188
Hi..
I accepted both of these as the solution because I'm sure they were both correct, but actually only implemented the solution presented by SriVaddadi re the database view...

This fixed my issue and I learned something in the process (ie, database views!!) so was well pleased..

Thanks

D
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Telerik RadEditor Control Save 8 39
Need to find a web event on the IIS server 4 52
How does this modal gets closed? 6 41
Manage big list of parameter list 8 21
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question