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(); }