ASP.NET: change label text based on changing numbers

Question

ASP.NET: change label text based on changing numbers

mashed potato 0

I am trying to write a program where the output of text of label changes based on sequence of changing numbers.

I have 4 labels that print out the designation of an approver based on ids from the database.

for example:

1=head of college (HOC)

2=head of department (HOD)

3=head of section (HOS)

if the sequence from the table from the database is (1,2,3)

then the labels will be (HOC,HOD,HOS,None)

if the sequence (1,2)

then the labels will be (HOC,HOD,None,None)

and so, on.

the table:

Capture

please notice that there are up to 8 approvers and the sequence changes every time the levels of approvers are edited.

any idea how to implement that? thanks.

AgaveJoe 30,406 Reputation points

2023-09-17T11:51:30.83+00:00

Creating a comma separated string is trivial. But, you have to understand, it's hard to answer this question with out the code and table schema. Does the sequence logic work? Are you able to query the database and return an ordered data set?

Is there any way you can how us some code or a sample that illustrates the issue?

Lan Huang-MSFT 30,206 Microsoft External Staff

Hi @mashed potato,

What project are you using? It's best to provide your code so we can help you better.

You can use the Replace method to change the number to the desired text.

You can refer to the following code:


            DataTable dt = new DataTable();
            SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);
            con1.Open();
            SqlCommand cmd1 = new SqlCommand("select Approvers from Test", con1);
            SqlDataAdapter ada1 = new SqlDataAdapter(cmd1);
            ada1.Fill(dt);
            for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
                string data = dt.Rows[i][0].ToString();
                var length = data.Length;
                string newData = "";
                if (length == 1)
                {
                    newData = data.Insert(length, ",None,None,None");

                }
                if (length == 3)
                {
                    newData = data.Insert(length, ",None,None");

                }
                if (length == 5)
                {
                    newData = data.Insert(length, ",None");

                }


                dt.Rows[i][0] = newData.Replace("1", "HOC").Replace("2", "HOD").Replace("3", "HOS").Replace("0", "None");

            }

User's image

Your answer

AgaveJoe 30,406 Reputation points

2023-09-17T11:51:30.83+00:00

Creating a comma separated string is trivial. But, you have to understand, it's hard to answer this question with out the code and table schema. Does the sequence logic work? Are you able to query the database and return an ordered data set?

Is there any way you can how us some code or a sample that illustrates the issue?
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff

2023-09-18T09:39:28.3666667+00:00

Hi @mashed potato,

What project are you using? It's best to provide your code so we can help you better.

You can use the Replace method to change the number to the desired text.

You can refer to the following code:

DataTable dt = new DataTable(); SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString); con1.Open(); SqlCommand cmd1 = new SqlCommand("select Approvers from Test", con1); SqlDataAdapter ada1 = new SqlDataAdapter(cmd1); ada1.Fill(dt); for (int i = 0; i <= dt.Rows.Count - 1; i++) { string data = dt.Rows[i][0].ToString(); var length = data.Length; string newData = ""; if (length == 1) { newData = data.Insert(length, ",None,None,None"); } if (length == 3) { newData = data.Insert(length, ",None,None"); } if (length == 5) { newData = data.Insert(length, ",None"); } dt.Rows[i][0] = newData.Replace("1", "HOC").Replace("2", "HOD").Replace("3", "HOS").Replace("0", "None"); }

Share via

ASP.NET: change label text based on changing numbers

Your answer