protected void btnSubmit_Click(object sender, EventArgs e)
    {
        HttpResponse.RemoveOutputCacheItem("/StateProvinceList.aspx");
        string    strCityText = txtCityText.Text.Replace(Environment.NewLine, "<br />");
        DataTable dt          = VADBCommander.CityTextByStateInd(stateprovinceid.ToString());

        try
        {
            if (dt.Rows.Count > 0)
            {
                VADBCommander.CityTextByStateEdit(stateprovinceid.ToString(), strCityText);
            }
            else
            {
                VADBCommander.CityTextByStateAdd(stateprovinceid.ToString(), strCityText);
            }
            lblInfo.Text = "Data saved.";
            DataTable dt4 = VADBCommander.CityTextByStateInd(stateprovinceid.ToString());
            if (dt4.Rows.Count > 0)
            {
                if (dt4.Rows[0]["cityText"] != null)
                {
                    lblcityInfo.Text = dt4.Rows[0]["cityText"].ToString();
                    txtCityText.Text = dt4.Rows[0]["cityText"].ToString().Replace("<br />-ipx-", Environment.NewLine);
                }
                if (dt4.Rows[0]["cityText2"] != null)
                {
                    lblInfo2.Text = dt4.Rows[0]["cityText2"].ToString();
                    if (string.IsNullOrEmpty(dt4.Rows[0]["cityText2"].ToString()) || dt4.Rows[0]["cityText2"].ToString() == "")
                    {
                        OrangeTitle.Visible = false;
                    }
                    txtCityText2.Text = dt4.Rows[0]["cityText2"].ToString().Replace("<br />", Environment.NewLine);
                }
                else
                {
                    OrangeTitle.Visible = false;
                }
            }
        }
        catch (Exception ex)
        {
            lblInfo.Text = ex.Message;
        }
    }