sorting with array.

Ankit Shukla

11y1.2kVisual Basic .NET

Hi,

I faced a question in interview..

Q: Suppose I have a table like this:

Name | E1 | E2

------------|-------|------------------------

A | 9 | 6

B | 5 | 7

C | 8 | 9

D | 5 | 9

E | 9 | 9

Arrange 'Name' sorted by assending order of 'E1'.

Name | E1 | E2

---------|-----|------------------------

A | 9 | 6

E | 9 | 9

C | 8 | 9

B | 5 | 7

D | 5 | 9

then if E1 is same so sorted by E2.

Name | E1 | E2

---------|-----|------------------------

E | 9 | 9

A | 9 | 6

C | 8 | 9

D | 5 | 9

B | 5 | 7

So how can we do this with array?

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Accepted answer
Hello use below code-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Data.OleDb;

public partial class TestPage2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!this.IsPostBack)

{

sortArr();

}

}

public void sortArr()

{

User[] users = new User[4] { new User("Upendra", 5, 5000), new User("Ashish", 3, 7000), new User("Gitendra", 1, 9000), new User("Surender", 5, 6000) };

Response.Write("USERS Record
");

Response.Write("
");

for (int i = 0; i < 4; i++)

{

Response.Write(users[i].Name+" ");

Response.Write(users[i].GradePoint+ " ");

Response.Write(users[i].Salary+" ");

Response.Write("
");

}

//sort array by name, by grade, by salary

users = users.OrderByDescending(x => x.Name).ThenByDescending(x => x.GradePoint).ThenByDescending(x => x.Salary).ToArray();

Response.Write("
");

Response.Write("USERs Record
");

Response.Write("
");

for (int i = 0; i < 4; i++)

{

Response.Write(users[i].Name+" ");

Response.Write( users[i].GradePoint+" ");

Response.Write( users[i].Salary+" ");

Response.Write("
");

}

}

}

class User

{

public string Name { get; set; }

public int GradePoint { get; set; }

public int Salary { get; set; }

//constructor

public User(string name, int gradepoint, int sal)

{

this.Name = name;

this.GradePoint = gradepoint;

this.Salary = sal;

}

}
Kindly mark as accepted answer.
+1
Upendra Pratap Shahi11y ago
thanks Ankit Shukla brother for appreciation.
0
Ankit Shukla11y ago
Thank you Upendra Sir. I get my result. I just change

users = users.OrderByDescending(x => x.Name).ThenByDescending(x =>x.GradePoint).ThenByDescending(x => x.Salary).ToArray();
to

users = users.OrderByDescending(x => x.GradePoint).ThenByDescending(x => x.Salary).ToArray();

. Now its working..
+1
Ankit Shukla11y ago
Sorry Upendra Sir. According to your code my output is:

E 9 9
D 5 9
C 8 9
B 5 7
A 9 6

your code sorted by only name. But I have some other limitations.
0
Upendra Pratap Shahi11y ago
Hello Ankit,

Kindly take a graph of my code. It may helped you dear.
0
Ankit Shukla11y ago
Guys,

This is not what I want.. Please understand my question. I am explaining again.

I have a table:

Stud | M1 | M2
--------|-------|------------------------
A | 9 | 6
B | 5 | 7
C | 8 | 9
D | 5 | 9
E | 9 | 9

student name is sorted by Marks 1 (M1) but if M1 of 2 students are same then sorted by M2.

If we sort this table by M1 then result:

Stud | M1 | M2
---------|----.-|------------------------
A | 9 | 6
E | 9 | 9
C | 8 | 9
B | 5 | 7
D | 5 | 9

but we can see marks(M1) of A and E are 9 so we consider M2 and last result will be:

Name | E1 | E2
---------|-----|------------------------
E | 9 | 9
A | 9 | 6
C | 8 | 9
D | 5 | 9
B | 5 | 7

I hop you can understand my problem now.
0
Rajeesh Menoth11y ago
Hi,
The following source code shows how to sort an integer Array in ascending order.
C#
int[] array = new int[] { 3, 1, 4, 5, 2 };
Array.Sort(array);
foreach (var str in array)
{
MessageBox.Show(str.ToString());
}
The following code shows how to sort an Integer array in reverse order.
C#
int[] array = new int[] { 3, 1, 4, 5, 2 };
Array.Sort(array);
Array.Reverse(array);
foreach (var str in array)
{
MessageBox.Show(str.ToString());
}
0
Saroj Kumar Sahu11y ago
Hi Ankit,
Please see the below code,how can be sort an array.it may help you.

class User
{
public string Name { get; set; }
public int GradePoint { get; set; }
public int Salary { get; set; }
//constructor
public User(string name, int gradepoint, int sal)
{
this.Name = name;
this.GradePoint = gradepoint;
this.Salary = sal;
}
}
class ArraySort
{
static void Main(string[] args)
{
User[] users = new User[3]{ new User("S", 5, 2000), new User("A", 3, 1000), new User("Z", 1, 3000) };
Console.WriteLine("USERS Record");
Console.WriteLine("---------------------------");
for (int i = 0; i < 3; i++)
{
Console.WriteLine("User Name: {0}", users[i].Name);
Console.WriteLine("Grade Point: {0}", users[i].GradePoint);
Console.WriteLine("Salary: {0}", users[i].Salary);
Console.WriteLine("---------------------------\n");
}
//sort array
users = users.OrderByDescending(x => x.Name).ThenByDescending(x => x.GradePoint).ThenByDescending(x => x.Salary).ToArray();
Console.WriteLine("USERs Record");
Console.WriteLine("---------------------------");
for (int i = 0; i < 3; i++)
{
Console.WriteLine("USER Name: {0}", users[i].Name);
Console.WriteLine("Grade Point: {0}", users[i].GradePoint);
Console.WriteLine("Salary: {0}", users[i].Salary);
Console.WriteLine("---------------------------\n");
}
}
}
0
Karthikeyan K11y ago
SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 20 05:31:00 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> CREATE TABLE TABLE1(NAME VARCHAR(1),V1 NUMBER,V2 NUMBER);

Table created.

SQL> INSERT INTO TABLE1(NAME,V1,V2) VALUES('&NAME','&V1','&V2');
Enter value for name: K
Enter value for v1: 78
Enter value for v2: 99
old 1: INSERT INTO TABLE1(NAME,V1,V2) VALUES('&NAME','&V1','&V2')
new 1: INSERT INTO TABLE1(NAME,V1,V2) VALUES('K','78','99')

1 row created.
SQL> /
Enter value for name: A
Enter value for v1: 99
Enter value for v2: 99
old 1: INSERT INTO TABLE1(NAME,V1,V2) VALUES('&NAME','&V1','&V2')
new 1: INSERT INTO TABLE1(NAME,V1,V2) VALUES('A','99','99')

1 row created.
SQL> SELECT * FROM TABLE1;

N V1 V2
- ---------- ----------
K 78 99
A 99 99

SQL> SELECT * FROM TABLE1 ORDER BY V1 DESC, V2 DESC;

N V1 V2
- ---------- ----------
A 99 99
K 78 99
0
Ankit Shukla11y ago
Sorry Sir, I need array not sql ..
0
Rahul Prajapat11y ago
Hello @Ankit You can sort by using order by on two column like this:

SELECT * FROM TableName ORDER BY E1 DESC , E2 DESC
0