How to sort Column A, then sort Column B grouped under the same value in Column A?

[mickeydibs48 (Michael de Borja)]

Given:
Datatable with 2 columns:
CA | CB
1 | B
2 | B
2 | A
1 | C
1 | A

Problem:
Sort the two columns like below:
CA | CB
1 | A
1 | B
1 | C
2 | A
2 | B

Please help!

Thank you!

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

(From x In datatablevariable.AsEnumerable()
Order By convert.ToInt16(x("Column Name ")),convert.ToString(x("Column Name "))
Select x).CopyToDataTable

[mickeydibs48 (Michael de Borja)]

@Vijay_Tulsalkar

(From x In datatablevariable .AsEnumerable()
Order By convert.ToInt16(x(" Column Name “)),convert.ToString(x(” Column Name "))
Select x).CopyToDataTable

worked like a charm! thanks Vijay!!

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

Glad it Worked . Cheers
Happy Automating