Idea needed: switching text on labels

I have a user control with some textboxes and lables. I have a a dropdownlist with countries in it. Now, in US, "last name" is used. In UK, "surname' is used.

When user changes ddl from US to UK or to any other country, I want the text on label to change from "Last Name" to "Surname".

Right now, I have the label hardcoded to Last Name. Any ideas on how to do this? It's not US and UK. I will have more countries.  I thought about XML but not sure.
LVL 7
CamilliaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Muhammad Ousama GhazaliConnect With a Mentor Solution Analyst & ArchitectCommented:
Sorry I posted my last solution in a hurry. Consider this instead:
Let's say your Countries table has these columns:
  • CountryID
  • CountryName
  • LastNameString
Use the following SQL to query Countries for binding them to DDL:
SELECT CountryID + ',' + LastNameString AS CountryCode, CountryName
And use the code below in Data Binding routine:

//ddl - DropDownList object name
//Data binding routine
ddl.DataSource = cmdSql.ExecuteReader();
ddl.DataTextField = "CountryName";
ddl.DataValueField = "CountryCode";
ddl.DataBind()
 
//put this code in SelectedIndexChanged event of DDL
lblLastName.Text = ddl.SelectedValue.Split(",")(1);
 
//the code below will give you CountryID if you need it any where else in code
ddl.SelectedValue.Split(",")(0)

Open in new window

0
 
Muhammad Ousama GhazaliSolution Analyst & ArchitectCommented:
You have to employ some JavaScript code if you wish to have the required fucntionality without posting back. However, for server-side you can very easily acheive it.
Set the AutoPostBack property of your DropDownList control to True. Then use the sample code below in its SelectedIndexChanged event.

switch (DropDownList1.SelectedValue)
{
  case "US":
  case "Canada":
	  lblLastName.Text = "Last Name";	  
	  break;
	  
  case "UK":
  case "Asia":
      lblLastName.Text = "Surname";
      break;
      
  default:
  	lblLastName.Text = "Last Name";
  	break;
}

Open in new window

0
 
CamilliaAuthor Commented:
No, this is good solution if I only had , for example 2 countries. As I posted, I might have 20 countries, migth have 50 countries. This is not an efficient, elegant solution.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Muhammad Ousama GhazaliSolution Analyst & ArchitectCommented:
Have two lists of the countries in either database or web.config file in two fields/custom configuration elements. Try the code snippet below:
//Create these Values in web.config if you wish to use web.config instead of database fields
<appSettings>
	<add key="LastNameCountries" value="US,Canada,Mexico"/>
	<add key="SurnameCountries" value="UK,Japan,Pakistan,India"/>
</appSettings>
 
//put this line on top of page
using System.Configuration.ConfigurationManager;
 
string strLastNameCountries = AppSettings("LastNameCountries");
string strSurnameCountries = AppSettings("SurnameCountries");
 
//make sure SelectedValue data type of values match with the values in appsettings
string strSelectedCountry = DropDownList1.SelectedValue; 
 
if (strLastNameCountries.IndexOf(strSelectedCountry))
{        
  lblLastName.Text = "Last Name";
}
else if (strSurnameCountries.IndexOf(strSelectedCountry))
{       
  lblLastName.Text = "Surame";
}
else
{
  lblLastName.Text = "Last Name";
}

Open in new window

0
 
Muhammad Ousama GhazaliSolution Analyst & ArchitectCommented:
There was a mistake in last part of the above code. Please use the following:
if (strLastNameCountries.IndexOf(strSelectedCountry) >= 0)
{        
  lblLastName.Text = "Last Name";
}
else if (strSurnameCountries.IndexOf(strSelectedCountry) >= 0)
{       
  lblLastName.Text = "Surame";
}
else
{
  lblLastName.Text = "Last Name";
}

Open in new window

0
 
CamilliaAuthor Commented:
I might have 50 countries. This is an OK solution but will get hairy when I add more countries.

I'm looking for a class or something. I send it the country and it gives me back a list of labels.
So, in the class...maybe have something your code, I call it with "US" for example and then i get back a list of labels. I parse it in aspx page and assign to corresponding labels.
0
 
Muhammad Ousama GhazaliSolution Analyst & ArchitectCommented:
You can populate the list of countries with appropriate last/sur name from the database on the start of each request and place them in Session. This would also allow you to add more countries easily in your list and provide dynamic and accurate display in future.
Hope this helps.
0
 
CamilliaAuthor Commented:
You mean have the labels in the database and read the labels from there, keep in session?

So with this solution, the lables will be in DB?
0
 
CamilliaAuthor Commented:
thanks, will try tomorrow.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.