How to sort data in ascending order in data table on particular column

[Paresh]

Hi All,

How to sort data table in ascending order on particular column. There may be a possibility that this column contains a blank value. I don’t want to remove this blank value and neither its position (index).
Can you guys please help me achieving this.

Regards,
Paresh Borole

[Divyashreem (Divyashree Muddagangaiah)]

if it is in excel Just pass you datatable and column you want to sort ascending or descending.

else you can write inDataTable.Select(your column list)order by column name

[dkollyns (Diógenes Kollyns)]

Hello @Paresh

You can try as @Divyashreem have suggest for you, or as example below:

dt.DefaultView.Sort = “[Column1] ASC, [Column2] ASC”
dt = dt.DefaultView.ToTable

[Paresh]

Hi @Divyashreem and @dkollyns,

Thanks for your reply. I am preferring to go with -

dt.DefaultView.Sort = “[Column1] ASC, [Column2] ASC”
dt = dt.DefaultView.ToTable

I want to Pass Column1 As integer in this. How can i get that?

Thanks,
Paresh Borole

[Divyashreem (Divyashree Muddagangaiah)]

dt.DefaultView.Sort = “[Column1] ASC, [Column2] ASC”
dt = dt.DefaultView.ToTable

in this [Column1] is a column name-> Convert.Toint32(iDataTable.Item(“Column1”).ToString) this will convert your column data to int format

[Paresh]

Hi @Divyashreem,

Please help me with this syntax error.

Thanks,
Paresh Borole

[dkollyns (Diógenes Kollyns)]

Hello @Paresh

Try this:

dt2 = dt.clone
dt2.Columns(“Column1”).DataType = Type.GetType(“System.Int32”)
For Each dr As DataRow In dt.Rows
dt2.ImportRow(dr)
Next
dt2.AcceptChanges
dt = dt2.DefaultView.ToTable