sorting with array.

Question

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?

Upendra Pratap Shahi · 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 { 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 { 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 .

Ankit Shukla · Answer

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..

Upendra Pratap Shahi · Answer

thanks Ankit Shukla brother for appreciation.

Ankit Shukla · Answer

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.

Upendra Pratap Shahi · Answer

Hello Ankit Kindly take a graph of my code. It may helped you dear.

Ankit Shukla · Answer

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.

Rajeesh Menoth · Answer

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()); }

Saroj Kumar Sahu · Answer

Hi Ankit Please see the below codehow 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 { 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(---------------------------
); } //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 { 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(---------------------------
); } } }

Karthikeyan K · Answer

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 NUMBERV2 NUMBER); Table created. SQL> INSERT INTO TABLE1(NAMEV1V2) VALUES('&NAME''&V1''&V2'); Enter value for name: K Enter value for v1: 78 Enter value for v2: 99 old 1: INSERT INTO TABLE1(NAMEV1V2) VALUES('&NAME''&V1''&V2') new 1: INSERT INTO TABLE1(NAMEV1V2) 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(NAMEV1V2) VALUES('&NAME''&V1''&V2') new 1: INSERT INTO TABLE1(NAMEV1V2) 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

Ankit Shukla · Answer

Sorry Sir I need array not sql ..

Rahul Prajapat · Answer

Hello @Ankit You can sort by using order by on two column like this: SELECT * FROM TableName ORDER BY E1 DESC  E2 DESC