public string GetAddress() => StringUtil.ConcatNonEmpties(", ",
Details.Address.Line1,
Details.Address.Line2,
Details.Address.Line3,
Details.Address.CityOrTown,
CountyName.Replace("Not recorded", string.Empty),
Details.Address.PostCode,
CountryName.Replace("Not recorded", string.Empty));
public void Update()
{
string strsql = "update Country set " + "CountryName= '" + CountryName.Replace("'", "''") + "', " + "Status= '" + Status.Replace("'", "''") + "' " + " where ID =" + Id;
SqlConnection ObjConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyJobPortal"].ConnectionString);
ObjConnection.Open();
SqlCommand ObjCommand = new SqlCommand(strsql, ObjConnection);
ObjCommand.ExecuteNonQuery();
ObjConnection.Dispose();
ObjCommand.Dispose();
}