CODEWITHSUNDEEP
c#-4.0sortingdatatable
RAMARAJ.M
RAMARAJ.M

Reputation: 129

sort datatable columns basesd particular column?

if my datatable like this

    city       area            areanumber

    chennai    choolaimedu         565

    chennai    nungambakam         323

    trichy     K.K nagar           989

    trichy     D.nagar             801

    sivakasi   firenagar           253

am using below code

        dt.DefaultView.Sort = "areanumber";
        dt = dt.DefaultView.ToTable();
        dt.DefaultView.Sort = "area";
        dt = dt.DefaultView.ToTable();
        dt.DefaultView.Sort = "city";
        dt = dt.DefaultView.ToTable();
        dataGridView1.DataSource = dt;

the output is like this 

        city       area            areanumber

       chennai    choolaimedu         565

       chennai    nungambakam         323

       sivakasi   firenagar           253

       trichy     D.nagar             989

       trichy     K.K nagar           801

in above table area name also get sort based on city column eg:

trichy D.nagar 989

trichy K.K nagar 801

but the areanumber did'nt get sort like area

i want output like below table

        city       area            areanumber

       chennai    choolaimedu         323

       chennai    nungambakam         565

       sivakasi   firenagar           253

       trichy     D.nagar             801

       trichy     K.K nagar           989

Thanks

Upvotes: 1

Views: 123

Answers (1)

gzaxx
gzaxx

Reputation: 17600

Try to sort your DataTable in one call:

dt.DefaultView.Sort = "city asc";
dt = dt.DefaultView.ToTable();
dataGridView1.DataSource = dt;

Upvotes: 2

Related Questions