private void txtcodcalle_Validating(object sender, CancelEventArgs e)
 {
     if (!String.IsNullOrEmpty(txtcodcalle.Text.Trim()))
     {
         txtcalle.Text = Ctool.nomdir("Dir.Calles", $" id = {txtcodcalle.Text.Trim()} and idparaje = {txtcodparaje.Text.Trim()} and idsector = {txtcodsector.Text.Trim()} and idmunicipio = {txtcodmunicipio.Text.Trim()} and idprovincia = {txtcodprovincia.Text.Trim()} and idpais = {txtcodpais.Text.Trim()}");
     }
     else
     {
         txtcalle.Text = string.Empty;
     }
 }
 private void txtcodprovincia_Validating(object sender, CancelEventArgs e)
 {
     if (!String.IsNullOrEmpty(txtcodprovincia.Text.Trim()))
     {
         txtnomprovincia.Text = Ctool.nomdir("Dir.Provincias", $"id = {txtcodprovincia.Text.Trim()} and idpais = {txtcodpais.Text.Trim()}");
     }
     else
     {
         txtnomprovincia.Text = string.Empty;
     }
 }