Hi John,
Regrettably, there is no better way how to do this. Anyway, I would recommend you to use
custom transformation methods to achieve this aim.
You could use following custom method:
public static string getCountry(object CountryState)
{
string txtCountryState = (string) CountryState;
string country = txtCountryState.Split(';')[0];
return country;
}
public static string getState(object CountryState)
{
string txtCountryState = (string) CountryState;
string state = txtCountryState.Split(';')[1];
return state;
}
In transformation you could use following definition to resolve these methods:
<%# MyFunctions.getState(Eval("CountryState"))%>
<%# MyFunctions.getCountry(Eval("CountryState"))%>Best regards,
Michal Legen