sort table in webservice

IGotYourDotNet

I have a service that calles a SP and I need a column sorted for one
application.. Can I do the sorting via the web service or no? I'm not using
straight SQL for the call, i'm calling a stored procedure

Nov 18 '05 #1

Subscribe Post Reply

945

Ben Lucas

If you're retrieving the results into a DataTable or DataSet, you can use
the DataView object to sort. For example, given a DataTable dt with 2
columns ("ID" and "Column_To_Sort"), the following code could sort it:

DataView dv = new DataView(dt);
dv.Sort = "Column_To_Sort";

Now as you iterate through the rows in the DataView, it will be sorted on
the column "Column_To_Sort".

--
Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com

"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message
news:2F**********************************@microsof t.com...

I have a service that calles a SP and I need a column sorted for one
application.. Can I do the sorting via the web service or no? I'm not using straight SQL for the call, i'm calling a stored procedure

Nov 18 '05 #2

Similar topics

Dataview will not sort

by: Raymond Lewallen | last post by:

I have a dataview in which the sort property will not sort the dataview. Here's is a simple scenario similar to what I am doing: Class Foo Private Function Retrieve() As DataView ' Returns a...

.NET Framework

Table Sort

by: jeffsal | last post by:

I am using sorttable.js to sort a table which works fine which allows a user to sort the table by clicking on the column header. Is there some code I could add to the page (onload or something) to...

Javascript

code to sort a table

by: xah | last post by:

i'm just starting out on javascript. can anyone show me how to go about writing a code to sort a table column? something like the following: <table border="1"> <tr> <td>

Javascript

How to return table alias from MS SQL

by: Roman S. Golubin | last post by:

Hi, I found strange problem, when I use SQL server via proxy to sqlxml webservice... I create procedure: ---------- CREATE PROCEDURE TestConnection AS

C# / C Sharp

Possible bug using arraylist.sort IComparer and .net webservices and .net framework 1.1

by: Grant Wickman | last post by:

Our team has just fixed a really nasty problem that appears to be caused by an obscure bug in the sort method of Arraylist and daisy-chained webservice stubs. We've fixed the bug so I'll not...

.NET Framework

for each\create table\webservice

by: gah | last post by:

I am getting an array of records from an asp.net webservice and wanting to display them in a dynamically created html table in the php page. I am new to php and not sure how to get the values from...

PHP

ajax updating a table not using updatepanel?

by: soni2926 | last post by:

hi, we currently have a site done using asp.net 2.0, one of the pages has a datagrid, which displays some information. currently there is a refresh button, but we want to change this so that every...

ASP.NET

Is there an easy way to sort a list by two criteria?

by: neocortex | last post by:

Hello! I am a newbie in Python. Recently, I get stuck with the problem of sorting by two criteria. In brief, I have a two-dimensional list (for a table or a matrix). Now, I need to sort by two...

Python

Best way to transfer whole SQL table data to end user's C# app

by: Mark B | last post by:

We've got a table with around 50,000 rows. Periodically we want our Outlook Add-in (C#) app to automatically download it as XML for reference look-up use. Is the best way to use write a...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA