question

KwebenaAcquah-9104 avatar image
0 Votes"
KwebenaAcquah-9104 asked ·

how to convert series of integers into ordinals in C#

i am having a texbox1 with series of integers i would like to know if their is any way i can apply the conversion of these integers into ordinals. below is what i have tried:
73469-capture44.png

when my button convert is clicked with code:

private void btnconvert_Click(object sender, RoutedEventArgs e)
{
foreach (int num in txtresults.ToString())
{
string[] parts = txtresults.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
double[] numbers = parts.Select(p => double.Parse(p)).ToArray();
double maximum = numbers.Max();
int position = Array.IndexOf(numbers, maximum);
parts[position] = AddOrdinal(num);
txtresults.Text = string.Join(" ", parts);
}
}


this is my method of conversion

public static string AddOrdinal(int num)
{
if (num <= 0) return num.ToString();

     switch (num % 100)
     {
         case 11:
         case 12:
         case 13:
             return num + "th";
     }

     switch (num % 10)
     {
         case 1:
             return num + "st";
         case 2:
             return num + "nd";
         case 3:
             return num + "rd";
         default:
             return num + "th";
     }
 }


Update:

please TimonYang-MSFT your answer is absolutely close enough for me but please i have some question "can i be able to change does largest values that will be having th added to them to different values like
74022-captuvvre.png

we have 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 19th. in your Result ;

NOW: here is my question and exact want (Can i be able to change the highest value to be 1st and the next largest value will be 2nd, 3rd and 4th continuously within this series wherever we have similar integers we will have similar position say 19th and 19th will have 1st, 1st because they are both the largest values. but the positioning will continue as 3rd for 18th; 4th for 17th ; 5th for 16th; 6th for 15th; 7th for 14th; 8th for 13th; 9th for 12th; 10th for 11th; 11th for 10th; and 12th for 10th; 13th for 8th; etc.


is just like having 13 student in a class who took an examination and had different scores in a subject like English, when we want to rank them or say give them their result we need to calculate their position in the subject examination in such a way that we will definitely end up having some one in the class with the last position 13th even when we have student with similar position. this is what i want my button1_click event to do

thank you sir (for your help) and more help

UPDATE
please one more help; i was trying to save these positions to there respective columns in the database so i tried the following code can you preview and see if i can be corrected of most error committed please

  private void btnsavegraderecord_Click(object sender, RoutedEventArgs e)
         {
             SqlCommand cmd = new SqlCommand ("INSERT INTO tbl_grade VALUES @ENGLIS, @MATH, @SCIENCE", conn);
             con.Open();
    
             if (txtresults.Text.Contains(','))
             {
                 string[] arryval = txtresults.Text.Split(',');//split values with ‘,’  
                 int j = arryval.Length;
                 int i = 0;
                 for (i = 0; i < j; i++)
                 {
                     cmd.Parameters.Clear();
                     cmd.Parameters.AddWithValue("@ENGLISH", arryval[i]);
                     cmd.Parameters.AddWithValue("@MATH", txtresults.Text);
                     cmd.Parameters.AddWithValue("@SCIENCE",txtresult.Text):
                     cmd.ExecuteNonQuery();

                      cm.ExecuteNonQuery();
             }

(i.e. trying to update the database table with the positions rather the scores again please can you help on that too)

can i be thought how to do it right please (thanks in advance) (am using c# in wpf)




dotnet-csharp
capture44.png (5.9 KiB)
captuvvre.png (8.9 KiB)
captuvvre.png (8.9 KiB)
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Help !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! please Help me out to solve this problem please !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

0 Votes 0 ·

please can some one help me on this section of problem please !!!!!!!

0 Votes 0 ·

1 Answer

TimonYang-MSFT avatar image
1 Vote"
TimonYang-MSFT answered ·

I try to point out a few pieces of code that I found inappropriate.

 foreach (int num in txtresults.ToString())

textbox.ToString() will get this result:

73545-1.png

A string composed of Type and Text property, and you are converting it to int in the foreach loop, so it will be the value corresponding to the current letter in the ASCII table, for example, the first letter S corresponds to 83. I believe this is not you want.

 double[] numbers = parts.Select(p => double.Parse(p)).ToArray();

Linq is generally used for filtering and query work, try not to use it for modifying data.

Although it does not produce exceptions, it does not conform to general coding standards and may confuse people at some point. It is better to use general loops.

 double[] numbers = parts.Select(p => double.Parse(p)).ToArray();
 double maximum = numbers.Max();
 int position = Array.IndexOf(numbers, maximum);

I don't understand why we need to find the position, using parts[position] will always only add th after the largest number, no matter how many times it loops.
I made some changes to the code, the current code is as follows:

                private void button1_Click(object sender, EventArgs e)
     {
         string[] parts = textBox1.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
         double[] numbers = new double[parts.Length];
         for (int i = 0; i < parts.Length; i++)
         {
             numbers[i] = double.Parse(parts[i]);
         }

         double[] sortedNums = numbers.OrderByDescending(n => n).ToArray();

         int[] positions = new int[numbers.Length];

         for (int i = 0; i < positions.Length; i++)
         {
             positions[i] = Array.IndexOf(sortedNums, numbers[i])+1;
         }
         for (int i = 0; i < numbers.Length; i++)
         {
             parts[i] = AddOrdinal(positions[i]);
         }
         textBox1.Text += Environment.NewLine;
         textBox1.Text += string.Join(" ", parts);

          DataTable dataTable=  ToDataTable(parts, numbers);
         InsertIntoDataBase(dataTable);
     }
    public static void InsertIntoDataBase (DataTable dataTable)
     {
         string connString = @"your connection string";
         using (SqlConnection sqlConnection = new SqlConnection(connString))
         {
             sqlConnection.Open();
             using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(sqlConnection))
             {
                 sqlBulkCopy.DestinationTableName =
                     "dbo.rangkingTable";
                     sqlBulkCopy.WriteToServer(dataTable);
             }
         }
     }
     public static DataTable ToDataTable(string[] ranks,double[] scores)
     {
         DataTable dataTable = new DataTable();
         dataTable.Columns.Add("ID", typeof(int));
         dataTable.Columns.Add("score", typeof(double));
         dataTable.Columns.Add("rank", typeof(string));
         for (int i = 0; i < ranks.Length; i++)
         {
             dataTable.Rows.Add(i + 1, scores[i], ranks[i]);
         }
         return dataTable;
     }

Result:
74484-capture.png

Is this what you need?

If not, please describe what the final result you need is.

Update(2021.3.10):

To create a new table as an example.

First, create a new table in the database.

 CREATE TABLE [dbo].[rangkingTable]
 (
  [Id] INT NOT NULL PRIMARY KEY, 
     [score] FLOAT NULL, 
     [rank] NCHAR(10) NULL
 )

Then refer to the two new methods I added in the code above.

Update(2021.3.11):
Take the rankingTable I created yesterday as an example, suppose it looks like this now:
76666-2.png
We can update it in batches through SqlDataAdapter, like this:

         public static void UpdateTable(string[] ranks)
         {
             string connString = @"your conn string";
             using (SqlConnection connection = new SqlConnection(connString))
             {
                 connection.Open();
    
                 SqlDataAdapter dataAdpater = new SqlDataAdapter(
         "select * from rankingTable",
         connection);
    
                 dataAdpater.UpdateCommand = new SqlCommand(
                 "UPDATE rankingTable SET rank = @rank " +
                 "WHERE id = @id", connection);
    
                 dataAdpater.UpdateCommand.Parameters.Add(
                    "@rank", SqlDbType.NVarChar, 15, "rank");
    
                 SqlParameter parameter = dataAdpater.UpdateCommand.Parameters.Add(
                   "@id", SqlDbType.Int);
                 parameter.SourceColumn = "id";
                 parameter.SourceVersion = DataRowVersion.Original;
    
                 DataTable dataTable = new DataTable();
                 dataAdpater.Fill(dataTable);
    
                 for (int i = 0; i < dataTable.Rows.Count; i++)
                 {
                     dataTable.Rows[i]["rank"] = ranks[i];
                 }
                 dataAdpater.Update(dataTable);
             }
         }

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1.png (4.3 KiB)
2.png (1.3 KiB)
capture.png (2.1 KiB)
2.png (3.8 KiB)
· 9 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

please can you check the my updated question please am begging you please

0 Votes 0 ·
TimonYang-MSFT avatar image TimonYang-MSFT KwebenaAcquah-9104 ·

@KwebenaAcquah-9104
I updated the answer, please check it out.

1 Vote 1 ·

THANK YOU VERY VERY MUCH you just gave me exactly what i wanted God Bless you i have learnt quit enough from you, your a Genius.

but i would like to know if saving these position back to the database and not the numbers is it possible ? if it is can you write me a code to help me out please thanks in advance

0 Votes 0 ·
Show more comments