} // Done... Tested...
private void cboCity_SelectedIndexChanged(object sender, System.EventArgs e)
{
//if (AppMode)
// clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]);
//else
// clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]);
//string strSQL = "SELECT State as Abbrev, State FROM States INNER JOIN Cities ON States.State = Cities.StateID WHERE Cities.CityID = '" + txtCity.Text + "';";
//SqlDataReader rState = clsUtility.GetDataReader(strSQL);
DataTool dbTool = new DataTool();
DataTable dtState = dbTool.getStateAbbrev(Int32.Parse(txtCity.Text));
// select the correct state
if (dtState.Rows.Count > 0)
{
txtState.Text = dtState.Rows[0]["Abbrev"].ToString();
}
}