Try our conversational search powered by Generative AI!

How to save new state for country using StateProvinceRow ?


Is there any eg. how to save add/modify StateProvinceRow of the country?

Jun 27, 2016 11:53


You can simply load the CountryDto, then add new row to the StateProvince table. Here's an example:

CountryDto.StateProvinceRow spRow = (from reg in CountryDto.StateProvince
where reg.RowState != DataRowState.Deleted && 
String.Compare(reg.Name, name, StringComparison.CurrentCultureIgnoreCase) == 0
select reg).FirstOrDefault();
if (spRow == null)
spRow = CountryDto.StateProvince.NewStateProvinceRow();
spRow.CountryId = CountryId;

spRow.Name = name;
spRow.Ordering = Int32.Parse(e.Item[_GridOrderingString].ToString());
spRow.Visible = Boolean.Parse(e.Item[_GridVisibleString].ToString());

if (spRow.RowState == DataRowState.Detached)


Jul 01, 2016 9:38


thank you for reply.

It helped partially. Although I used the code above, I had to update country Id for all existed stated and the next code was used before saving:

countryDto.EnforceConstraints = false;

if (countryDto.HasChanges())


if (countryDto.Country.Rows.Count > 0)


var countryId = countryDto.Country[0].CountryId;

foreach (CountryDto.StateProvinceRowstateProvinceRow1in countryDto.StateProvince.Rows)


stateProvinceRow1.CountryId = countryId;




countryDto.EnforceConstraints = true;

Jul 01, 2016 9:44
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.