protected void StateAdd_Click(object sender, System.EventArgs e) { EnterState.Validate(); InvalidState.Validate(); if (!EnterState.IsValid || !InvalidState.IsValid) { return; } DataRow newrow = StateProvincesSet.Tables["StateProvinces"].NewRow(); newrow["StateProvince"] = NewState.Text; try { newrow["CountryID"] = Convert.ToInt32(CountryList.SelectedValue); StateProvincesSet.Tables["StateProvinces"].Rows.Add(newrow); //lock (CommonFunctions.Connection) StateProvincesAdapter.Update(StateProvincesSet); Finish(); } catch (Exception) { } }