RE: ASP DataGrid Sorting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steven Cheng[MSFT] (v-schang_at_online.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 10:47:53 GMT

Hi Mark,

As for the sorting problem you mentioned, I don't think the problem is on
the DataAdapter or Stored procedure. I've also done test on my side.
Retrieving datas from sqlserver via StoreProcedure and the DataAdapter
generated via thte Wizard in VS.NET. And bing onto a webform datagrid with
sorting, it works well. I think we can check the following things first:
1. What's the SortExpression you set for the columns in the DataGrid? The
expression should noramally be the columns name in the datatable. If
they're not idential, the sorting won't take place.

2. What's the columns's datatype you're sorting on? Some particular column
type such as binary data dosn't support simple sorting. If the column's
data type is normal string or numeric type, I think it should work.

Please have a further check and feel free to post here if you have any
other findings. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

Relevant Pages

  • Re: basic query regarding NP Complete...
    ... Max Vertex Cover can be converted into a sorting problem. ... I should have said Maximum Independent Set. ... let's forget about max vertex cover and look at max independent set. ...
    (comp.theory)
  • RE: group but not sort
    ... i follow your instructions to solve my sorting problem on my group and now it ... the name and the sort value. ... report's record source field list so you can use it to sort in the report. ...
    (microsoft.public.access.reports)
  • Re: LINK WORKSHEETS
    ... > relative formulas have solved the sorting problem only in the actual ... when i sort the original worksheet and the ...
    (microsoft.public.excel.programming)
  • Re: give me some advice
    ... Why do you insist on using a stack for sorting in Pascal? ... Perhaps because his/her instructor asked for a solution to a sorting ... sorting problem written in Pascal and using a stack. ...
    (comp.programming)
  • Re: Challenge; set directory sorting fixed on descending
    ... Ken Zhao ... Microsoft Online Support ... set directory sorting fixed on descending ...
    (microsoft.public.windows.group_policy)