How to Change order of Column of List in WCF Service?

Prakash Chotaliya

Mar 15 2011 2:32 AM

3.6k

Hi All,

    I have one table with Column say D,B,C,A in Database. Now when i am creating a list in WCF service using Sql Connection, it   returns a list in alphabetical order of column say A,B,C,D.
    My problem is, I want to display column order as it is present in Database i.e D,B,C,A.
How to solve this problem??

   Note : 1. DataGrid columns are Auto Generated, which is not going to change to (AutoGenerateColumns="False")
            2. Also there are 16 columns in my table, i know using DisplayIndex its possible but dnt want this too.

Thanks in Advance