ger's questions

What is needed is that the user enters the month in Number (without using any date controls); where you must validate that it is a positive number and that it accepts 1 to 9 and 0 to 2; only that they do not require month 01 or month 09 to be entered, if not 9 or 1; What I have done so far is this

^[+]?(0[1-9]|1[0-2])

The problem is that this must use the month 01 and that is what the user does not want.

var re = /^[+]?(0[1-9]|1[0-2])/;

console.log(re.test('') + ' No cumple' ); 
console.log(re.test('1')+ ' No cumple deberia Cumplir'); 
console.log(re.test('01'));
console.log(re.test('12'));
console.log(re.test('13') + ' No cumple');
console.log(re.test('9') + ' No cumple deberia Cumplir');

What I need is to have something like this,

<button (click)="onClick($event)">Aca <app-Recibos></app-Recibos></button>

You can see that I am a newbie with angular I do not know if it can be done or any suggestion to perform this action.

what I want is to bring the component in the html where I have the buttons and close it again, it would be something like a modalwindow.

I have defined the following imports in an Angular 7 project, which was being done in other components in products.module.ts

import { NgModule } from '@angular/core';
import { CommonModule } from '@angular/common';
import { FormsModule } from '@angular/forms';
import { NgSelectModule } from '@ng-select/ng-select';
//*****Implementacion NgX boostrap
import { DatePickerModule } from '../Helpers/DatePicker/DatePicker.module';

import { BsDatepickerModule } from 'ngx-bootstrap';
//*************************************
//Implementacion Datepicker ng-boostrap
import { NgbModule } from '@ng-bootstrap/ng-bootstrap';
import { NgbdDatepickerPopup } from '../Helpers/DatePicker/DatePickerNgB/DatepickerPopup.component';

As the error message I get that something is not registered in the tsconfig.json I expose it since I do not understand if the project was working without registering anything in the json

{
 "extends": "../tsconfig.json",
 "compilerOptions": {
  "outDir": "../out-tsc/app",
  "module": "es2015",
  "types": [ "node" ]
},
"exclude": [
 "src/test.ts",
 "**/*.spec.ts"
]
}

Is there something I omitted when creating the module?

I'm somewhat new to angular and I think I've been missing something. the specific error when I do ng build is:

\src\app\products\products.module.ts is missing from the TypeScript compilation. Please make sure it is in your tsconfig via the 'files' or 'include' property.

UPDATE The angular.json file is exposed...

{
  "$schema": "./node_modules/@angular/cli/lib/config/schema.json",
   "defaultProject": "co.ProInvestigacion.Web",
   "newProjectRoot": "projects",
   "projects": {
   "co.ProInvestigacion.Web": {
       "root": "",
        "sourceRoot": "src",
       "projectType": "application",
       "prefix": "app",
       "schematics": {},
        "architect": {
    "build": {
      "builder": "@angular-devkit/build-angular:browser",
      "options": {
        "progress": true,
        "extractCss": true,
        "outputPath": "dist",
        "index": "src/index.html",
        "main": "src/main.ts",
        "polyfills": "src/polyfills.ts",
        "tsConfig": "src/tsconfig.app.json",
        "assets": [
          "src/assets"
        ],
        "styles": [
          "node_modules/datatables.net-dt/css/jquery.dataTables.css",
          "node_modules/bootstrap/dist/css/bootstrap.min.css",
          "node_modules/bootstrap/less/bootstrap.less",
          "src/styles.css",
          "node_modules/jquery-ui-dist/jquery-ui.css",
          "node_modules/@fortawesome/fontawesome-free/css/fontawesome.css",
          "node_modules/@fortawesome/fontawesome-free/css/all.css",
          "node_modules/@fortawesome/fontawesome-free/css/brands.css",
          "node_modules/@fortawesome/fontawesome-free/css/regular.css",
          "node_modules/@fortawesome/fontawesome-free/css/solid.css",
          "node_modules/@ng-select/ng-select/themes/default.theme.css",
          "node_modules/ngx-bootstrap/datepicker/bs-datepicker.css"
        ],
        "scripts": [
          "node_modules/jquery/dist/jquery.js",
          "node_modules/jquery-ui-dist/jquery-ui.js",
          "node_modules/datatables.net/js/jquery.dataTables.js",
          "node_modules/bootstrap/js/dropdown.js",
          "node_modules/bootstrap/js/modal.js",
          "src/styles.js"
        ]
      },
      "configurations": {
        "production": {
          "fileReplacements": [
            {
              "replace": "src/environments/environment.ts",
              "with": "src/environments/environment.prod.ts"
            }
          ],
          "optimization": true,
          "outputHashing": "all",
          "sourceMap": false,
          "extractCss": true,
          "namedChunks": false,
          "aot": true,
          "extractLicenses": true,
          "vendorChunk": false,
          "buildOptimizer": true
        }
      }
    },
    "serve": {
      "builder": "@angular-devkit/build-angular:dev-server",
      "options": {
        "browserTarget": "co.ProInvestigacion.Web:build"
      },
      "configurations": {
        "production": {
          "browserTarget": "co.ProInvestigacion.Web:build:production"
        }
      }
    },
    "extract-i18n": {
      "builder": "@angular-devkit/build-angular:extract-i18n",
      "options": {
        "browserTarget": "co.ProInvestigacion.Web:build"
      }
    },
    "test": {
      "builder": "@angular-devkit/build-angular:karma",
      "options": {
        "main": "src/test.ts",
        "polyfills": "src/polyfills.ts",
        "tsConfig": "src/tsconfig.spec.json",
        "karmaConfig": "src/karma.conf.js",
        "styles": [
          "styles.css"
        ],
        "scripts": [],
        "assets": [
          "src/assets"
        ]
      }
    },
    "lint": {
      "builder": "@angular-devkit/build-angular:tslint",
      "options": {
        "tsConfig": [
          "src/tsconfig.app.json",
          "src/tsconfig.spec.json"
        ],
        "exclude": [
          "**/node_modules/**"
        ]
      }
    },
    "server": {
      "builder": "@angular-devkit/build-angular:server",
      "options": {
        "outputPath": "dist-server",
        "main": "src/main.ts",
        "tsConfig": "src/tsconfig.server.json"
      },
      "configurations": {
        "dev": {
          "optimization": true,
          "outputHashing": "all",
          "sourceMap": false,
          "namedChunks": false,
          "extractLicenses": true,
          "vendorChunk": true
        },
        "production": {
          "optimization": true,
          "outputHashing": "all",
          "sourceMap": false,
          "namedChunks": false,
          "extractLicenses": true,
          "vendorChunk": false
        }
      }
    }
  }
},
"co.ProInvestigacion.Web-e2e": {
  "root": "e2e/",
  "projectType": "application",
  "architect": {
    "e2e": {
      "builder": "@angular-devkit/build-angular:protractor",
      "options": {
        "protractorConfig": "e2e/protractor.conf.js",
        "devServerTarget": "co.ProInvestigacion.Web:serve"
      }
    },
    "lint": {
      "builder": "@angular-devkit/build-angular:tslint",
      "options": {
        "exclude": [
          "**/node_modules/**"
        ],
        "tsConfig": "e2e/tsconfig.e2e.json"
      }
    }
  }
  }
},
 "version": 1
}

the path of that file is this: src\app\Products\products.module.ts

We have the following dictionary...

    Dictionary <int,string> dCits = new Dictionary<int, string>();
    dCits.Add(1,"London");
    dCits.Add(2, "London");
    dCits.Add(3, "Paris");
    dCits.Add(4, "Berlin");
    dCits.Add(5, "Paris");
    dCits.Add(6, "Madrid");
    dCits.Add(7, "Berlin");
    dCits.Add(8, "Madrid");
    dCits.Add(9, "Madrid");
    dCits.Add(10, "Atenas");
    dCits.Add(16, "London");
    dCits.Add(62, "Paris");
    dCits.Add(63, "Roma");

the idea is to take the cities that are only repeated N times if N is 2 London will be taken one and up to 2 times, or if N is 3 take the three london or 3 madrid including those of 2 and 1. if only 1 is required I mean N=1 would be like a Distinct... (as I indicate in the code below) the problem is when there are more than 1 that the distinct does not look good

foreach(var value in dCits.Values.Distinct())
{
  // aca indicar cuantas veces se necesitan dependiendo de N. 
 }

any ideas, be it with linq, a select or another command to solve this?

UPDATE The result of the new dictionary would be something like this:

if N=2

1,"London"
2, "London"
3, "Paris"
4, "Berlin"
5, "Paris"
6, "Madrid"
7, "Berlin"
8, "Madrid"
10, "Atenas"
63, "Roma"

if only at least 2 repeated are required and also selecting those that have one. for example rome

I need to compare the date only those that are in the month of the system and for this I make the following query:

                        var lstConcepto = (from m in context.SMT_CONCEPTOBASICO
                                       where m.CODIGOENTIDAD.Contains(getCodEntidad) 
                                       && m.FECHAINICIAL == ConceptoTo.FechaInicial 
                                       && m.FECHASISTEMA == ConceptoTo.FechaSistema.Month
                                       && !m.VALORALFANUMERICO.Contains("Total")
                                       select m).ToList();

I can't find a way to make m.SYSTEMDATE.MONTH the date of the object.

&& m.DATESYSTEM == ConceptTo.DateSystem.Month Here I get an error comparing datetime and int... how do I convert m.DATESYSTEM In month??

UPDATE the option of m.SYSTEMDATE.Month throws error as indicated in the image

I am starting with Angular and I need to convert an application from Silverlight to Angular, and when I check some checkboxes, some selects or comboboxes appear.

Having reference to this page where they place how to add or modify controls (textboxes)

The code that I think is to add select or comboboxes is the one that I indicate:

  private addCheckboxes() {
this.orders.map((o, i) => {
  const control = new FormControl(i === 0); // if first item set to true, else false
  (this.form.controls.orders as FormArray).push(control);
});

} but how do I indicate that they are selects?

I have the following statements to Modify an Entity Framework object that is linked to an oracle database:

        using (BASEntities context = new BASEntities())
            {
        //Este método comprueba que exista en caso de existir modificar
        string RespuestaValidacion = ExisteConcepto(context, ConceptoTo);
             CONCEPTO objConceptoBasico = new  CONCEPTO
               {
                  CODIGOCTO = ConceptoTo.CodigoConcepto,
                  CODIGOENTIDAD = ConceptoTo.CodigoEntidad,
                   demas codigo..... 
                };

         if (string.IsNullOrEmpty(RespuestaValidacion))
                {
                    context.CONCEPTO.Add(objConceptoBasico);
                    context.SaveChanges();
                }
                else 
                {
                  context.CONCEPTO.Attach(objConceptoBasico);
                 context.CONCEPTO.System.Data.Entity.EntityState.Modified(objConceptoBasico);
                  context.SaveChanges();
                }

the method to Find if the record exists is as follows:

   private string ExisteConcepto(BASEntities context, ConceptoTO ConceptoTo)
    {
        try
        {
            var qRegistro = context.SMT_CONCEPTOBASICO.Where(k => 
                                    k.CODIGONEG == ConceptoTo.CodigoNegocio
                                    && k.CODIGOCTO == ConceptoTo.CodigoConcepto
                                    && k.IDAPLICACION == ConceptoTo.IdAplicacion
                                    demas codigo......).FirstOrDefault();                    


            return qRegistro == null ? "" : qRegistro.ESTADO;
        }
        catch (Exception error)
        {
            throw error;
        }
    }

And the mentioned error comes out:

Error 'An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key.'

make the change from entity 5 to entity 6

I have an application that uses WPF using MVVM with a ComboBox. When a certain value is selected, a textbox must be disabled, the XAMl has it like this: this is the textbox that is required to be enabled

          <TextBox Name="TCRM" Grid.Row="11" Grid.Column="1"
               Width="100" Height="18" 
               HorizontalAlignment="Left" 
               VerticalAlignment="Center" 
               helpers:TextFilterService.TextBoxFilter="Money" 
               FlowDirection="RightToLeft" MaxLength="4" 
               Margin="10,2,0,1" IsEnabled="{Binding ElementName=cbAgregarManual, Path=IsChecked}"
               Text="{Binding Path=Concepto.TCRM, ValidatesOnNotifyDataErrors=True, ValidatesOnExceptions=True, Mode=TwoWay}"/>

The combobox that determines whether to enable or disable:

        <ComboBox Name="ComboTipoPpa" Grid.Row="10" Grid.Column="1"
                  Height="26" Width="177" 
                  HorizontalAlignment="Left" 
                  Margin="10,1,0,1"
                  IsEnabled="{Binding ElementName=cbAgregarManual, Path=IsChecked}" 
                   ItemsSource="{Binding Path=TipoPpaTos, ValidatesOnNotifyDataErrors=False}" 
                  SelectedItem="{Binding Path=SelectedTipoPpaTO, Mode=TwoWay, NotifyOnValidationError=True}" DisplayMemberPath="Nombre"
                  SelectedValuePath="ValoresPPA"/>

if you select STR or TR (Representative Rate) the control enable must be triggered. THIS IS THE PART I can't find to perform, in MVVM.

Something like if TR is selected in the combobox, the TextBox Name="TCRM" is enabled, otherwise it is not enabled

There is a function created from the core/business layer, which performs calculations and the value of the result needs to appear in a textbox of the view...

This is the text box:

<TextBlock Text="{Binding Source={StaticResource ResourceWrapper}, 
        Path=RecursosControles.EtiquetaValor, 
        ValidatesOnNotifyDataErrors=False}" VerticalAlignment="Center" Grid.Row="4" />

in my action method where you called the function it looks like this:

    private void CalcularAction(object obj)
    {
        if (!string.IsNullOrEmpty(this.DocumentoID))
        {// aca enviar al textbox del view txtValor.text = 
           CalcularConceptoPPA(this.DocumentoID, this.concepto.DiasMes, this.concepto.DiasAtraso, this.concepto.Porcentaje, this.concepto.TipoPPA, this.concepto.TCRM);
        }//.... demas codigo

UPDATE this method calls the action to the service but does not bring the value

private void CalcularConceptoPPA(string conceptoIDConceptoSTN, int diasMes, int DiasAtraso, double Porcentaje, int tipoPpa, decimal TCRM)
    {
        App.Current.ServicioCalculos.CalcularConceptoPPA(conceptoIDConceptoSTN,  diasMes, DiasAtraso, Porcentaje, tipoPpa, TCRM,
            Calculation =>
            {
                if (Calculation.HasError)
                {
                    this.RiaCallError = Calculation.Error.Message;
                    Calculation.MarkErrorAsHandled();
                }
                if (Calculation.IsComplete)
                {
                    CalcularConceptoPPA_Complete(Calculation.Value);
                }
            }, null);
    }

The function in the business layer is defined like this:

 public decimal CalcularConceptoPPA(string conceptoIDConceptoSTN, int diasMes, int DiasAtraso, double Porcentaje, int tipoPpa, decimal TCRM)
    {


        if (String.IsNullOrEmpty(conceptoIDConceptoSTN))
        {
            return 0;
        }

        try

I'm new to wpf, any help is appreciated

I have the following action that is returning an Ilist, when returning data it results in an Empty Json:

[
    {}
]

the apicontroller method is like this;

[HttpGet]
public IHttpActionResult ConsultaPuertos([FromUri] string id, 
[FromBody] List<PuertosGP> lstPuertosGP, [FromUri] DateTime fecha)
{

     var resultList1 = puertosGPRepository.ConsultaPuertos(id, lstPuertosGP, 
    fecha);
  return Ok(resultList1); 
 });

Is it feasible to send a Json(resultList1)? or make the action return not an IList but a JsonResult?

UPDATE In the step by step it is observed that at least one record returns from the portsGPRepository(...)

in the POSTMAN the json is empty

UPDATE 2

I have changed in my WebApiConfig.cs

I have this line:

    public static class WebApiConfig
{
    public static void Register(HttpConfiguration config)
    {
        // Configuración y servicios de API web
        // Web API configuration and services
        config.Formatters.JsonFormatter.SupportedMediaTypes.Add(new MediaTypeHeaderValue("application/json"));//text/html

I get that error when trying to access the route defined in my controller

which is in a post method that sends and receives parameters as indicated in the following code:

 [HttpPost]
    [Route("api/ConsultasGP/ConsultasPuertos")]

    public async Task<IList<PuertosGP>> ConsultasPuertos([FromUri]string id, 
         [FromBody] List<PuertosGP> lstPuertosGP, [FromUri]DateTime fecha)
        { ..... demas codigo

When doing a test in POSTMAN, the following message appears: "No HTTP resource was found that matches the URI of the request " http://localhost:24175/api/ConsultasGP/ConsultasPuertos "

In my WebApiConfig.cs it is configured in this way:

public static void Register(HttpConfiguration config)
    {
        // Web API routes
        config.MapHttpAttributeRoutes();

        config.Routes.MapHttpRoute(
            name: "DefaultApi",
            routeTemplate: "api/{controller}/{action}/{id}",
            defaults: new { id = RouteParameter.Optional }
        );
    }

Could you explain to me what is the mistake I am making?

I don't understand what the error is.

UPDATE I missed adding the [FromUri] and [FromBody] since this requires sending the Id which is a string

A Web API project needs to be backported from Core 2.2 to .Net framework 4.6 and is developed in codefirst ; in the class of dbContext there is OnModelCreatingsome initial data but an error appears in the "hasData" line:

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);
    modelBuilder.Entity<Generador>().**HasData**(
        new Generador { Nombre = "xm324", Capacidad = 1000000 },
        new Generador { Nombre = "Bee344", Capacidad = 3000000 },
        new Generador { Nombre = "DCM445", Capacidad = 5000000 }
        );
}

How is .NET Core 2.2 different from 4.6?

I have the following line of code in my GET method:

    // GET: Areas/Edit/5
    public async Task<ActionResult> Edit(int? id)
    {
        var Str = areas.NOMBRE;

and capture strin the POST method:

    [HttpPost]
    [ValidateAntiForgeryToken]
    public async Task<ActionResult> Edit([Bind(Include = ....)] Areas areas)
    {
        string StrPost = Str; //str que debe venir del get

I don't know if using a viewbag(I don't want it to be taken to the View) or what variable to use... I've already had it stras a global variable but whenever it enters the POST method it deletes the content of str.

I have several Classes generated by the entity framework and they need to be serialized like this;

 string OldVersion = JsonConvert.SerializeObject(foo);

but I get the message:

Self referencing loop detected with type 'System.Data.Entity.DynamicProxies

I have consulted and found that there must be a WebApiConfig class that does not exist in the project that I am modifying, and place the following lines of code to avoid the error

 var jsonFormatter = config.Formatters.OfType<JsonMediaTypeFormatter>().First();
    jsonFormatter.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();

Is there another way to add those lines directly in the web.config or another way to avoid this error?

I use Newtonsoft.json

You are trying to migrate from entityframework to core a base Repository class where you have a property that defines the dbset like this:

protected DbSet dBset
    {
        get
        {
            return Context.Set<TObject>();
        }
    }

by implementing the filter method

protected IQueryable Filter(Expression<Func<TObject, bool>> predicate)
    {
        return dBset.Where(predicate).AsQueryable();
        // TODO: Control de excepciones
    }

throws error:

'DbSet' does not contain a definition for 'Where' and the best overload of the extension method 'Queryable.Where(IQueryable, Expression>)' requires a receiver of type 'IQueryable'

I don't understand why it doesn't assume the dBset that I defined as a property in this class but when I put the line with

return Context.Set<Tobject>();

with this line the error does not appear, what is happening?

I have the following code in my html page with angular 7

<i class="fa fa-pencil"></i>

All other icons and buttons are displayed fine showing trash can and others but the pencil does not show it? what can happen?

I am reading an xml where I need the code of the received message, for this I did this in a part of the code:

 string responseValue;
  while (reader.Read())
    {
     if (reader.Name == "ns2:Response")
        {
          if ((reader.NodeType == XmlNodeType.Text) && (reader.HasValue))
           {
              responseValue = reader.Value;
            }
         }
    }

when I put a breakpoint on the if; does not show any value. Why can this happen??

The xml is like this (or the part where I want to get the value):

<SOAP-ENV:Body xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="id-14799">
  <ns2:SendInvoice xmlns:ns2="http://www.zadrwan.com/services/" xmlns:ns3="http://www.zadrwan.com/services/DocumentSendTo" xmlns:ns4="http://www.zadrwan.com/services/VersionRequest">
      <ns2:Response>200</ns2:Response>
      <ns2:Comments>Ejemplar recibido exitosamente pasará a verificación. </ns2:Comments>
  </ns2:SendInvoice>
</SOAP-ENV:Body>

I'm trying to understand why it doesn't execute a method from a non-static public class ( public class DatosHandler), even a static method:

public class DatosHandler
{

    public static DataTable ConsultaFacturasAll()
    {

        //*** cadena de texto de consulta de las facturas detalle*** 
        string ConsultaEncabezado = "SELECT " +
                                    "facturaNumero, " +
                                    "DATE_FORMAT(facturaFecha, '%Y-%m-%d') as FacturaFecha, " +
                                    "DATE_FORMAT(facturaFechaVencimiento, '%Y-%m-%d') as FacturaFechaVencimiento, " +
                                    "facturaOrdenCompra, " +
                                    "clienteNombre, " +
                                    "clienteIdentificacion, " +
                                    "clienteTelefono, " +
                                    "clienteEmail, " +
                                    "FORMAT(facturaSubtotal, 2)  as facturaSubtotal, " +
                                    "FORMAT(facturaValorTotal, 2) as facturaValorTotal FROM Encabezados";

        return Conexion.EjecutarConsulta(ConsultaEncabezado, CommandType.Text); // ACA SALE EL ERROR

    }

The Class that is invoked by the ExecuteQuery method is internal and Static methods as I place it in the box:

public static DataTable EjecutarConsulta(string cadenaComando, CommandType tipocomando)
    {
        MySqlDataAdapter adaptador = new MySqlDataAdapter();// aca he colocado punto de interrupcion pero no llega el debuger en este punto
        adaptador.SelectCommand = new MySqlCommand(cadenaComando, conexion);
        adaptador.SelectCommand.CommandType = tipocomando;

        DataSet resultado = new DataSet();
        adaptador.Fill(resultado);

        return resultado.Tables[0];
    }

The error it shows me is:

An exception occurred in the initializer of type 'co.InfrastructureData.Connection'

I have well referenced the dll to mysql, the query is fine (I did test)

but debugging return Conexion.EjecutarConsulta(ConsultaEncabezado, CommandType.Text);on this line throws the exception in the type initializer.

Could you explain to me why it does not enter the call of the Connection class execute query??? It is defined as static!

public static DataTable EjecutarConsulta

Both the class Conexiónand DatosHandlerare in the same project or namespace namespace co.InfraestructuraData

If possible explain with code Thanks! ;) ;)

Update

this is the code of the internal Connection class, and they are in the same namespace namespace co.InfraestructuraData

internal class Conexion
{

    private static string cadenaConexion= ConfigurationManager.ConnectionStrings["sqlConexionApp"].ConnectionString;
    private static MySqlConnection conexion = new MySqlConnection(cadenaConexion);

    public static bool Conectar()
    {
        try
        {
            conexion.Open();
            return true;
        }
        catch (Exception)
        {

            return false;
        }
    }

    public static void Desconectar()
    {
        conexion.Close();
    }

    public static void EjecutarOperacion(string cadenaComando, List<MySqlParameter> listaparametros, CommandType tipoComando)
    {
        if (Conectar())
        {
            MySqlCommand comando = new MySqlCommand();
            comando.CommandText = cadenaComando;
            comando.CommandType = tipoComando;
            comando.Connection = conexion;

            foreach (MySqlParameter parametro in listaparametros)
            {
                comando.Parameters.Add(parametro);
            }
            comando.ExecuteNonQuery();
            Desconectar();
        }
        else
        {
            throw new Exception("No se pudo establecer conexion");
        }
    }

    public static DataTable EjecutarConsulta(string sentencia, List<MySqlParameter> listaparametro, CommandType tipocomando)
    {
        MySqlDataAdapter adaptador = new MySqlDataAdapter();
        adaptador.SelectCommand = new MySqlCommand(sentencia, conexion);
        adaptador.SelectCommand.CommandType = tipocomando;
        foreach (MySqlParameter parametro in listaparametro)
        {
            adaptador.SelectCommand.Parameters.Add(parametro);
        }
        DataSet resultado = new DataSet();
        adaptador.Fill(resultado);

        return resultado.Tables[0];
    }

    public static DataTable EjecutarConsulta(string cadenaComando, CommandType tipocomando)
    {
        MySqlDataAdapter adaptador = new MySqlDataAdapter();
        adaptador.SelectCommand = new MySqlCommand(cadenaComando, conexion);
        adaptador.SelectCommand.CommandType = tipocomando;

        DataSet resultado = new DataSet();
        adaptador.Fill(resultado);

        return resultado.Tables[0];
    }
}

the question is how can I update the value of a specific column in SQL without having to send data from the other fields, I explain myself with the code.

I have the following Stored Procedure

ALTER PROCEDURE [dbo].[spUpdateCredito]
 @CreditoID int,
 @PersonaID int,
 @NumeroCuotas int,
 @EstadoCredito int,
 @MontoAprovado decimal (18,2),
 @Plazo int,
 @FechaCredito datetime,
 @Tasa decimal (4,2)
AS
 BEGIN
  UPDATE Credito SET
      PersonaID = @PersonaID,
      NumeroCuotas = @NumeroCuotas,
      EstadoCredito = @EstadoCredito,
      MontoAprovado = @MontoAprovado,
      Plazo = @Plazo,
      FechaCredito = @FechaCredito,
     Tasa = @Tasa
  WHERE
   CreditoID = @CreditoID
  END

in a routine you need to change ONLY CreditStatus but I don't want to update the other columns.

If I run it from sql manager it would be like this:

EXEC    @return_value = [dbo].[spUpdateCredito]
    @CreditoID = 3,
    @PersonaID = NULL,
    @NumeroCuotas = NULL,
    @EstadoCredito = 5,
    @MontoAprovado = NULL,
    @Plazo = NULL,
    @FechaCredito = NULL,
    @Tasa = NULL

 SELECT 'Return Value' = @return_value

but I don't want it to leave me columns in null

If I only want the specific column to be updated, I run the script

EXEC    @return_value = [dbo].[spUpdateCredito]
    @CreditoID = 3,
    @EstadoCredito = 5


SELECT  'Return Value' = @return_value

I get the following error

Msg 201, Level 16, State 4, Procedure spUpdateCredito, Line 0 [Batch Start Line 2] The procedure or function 'spUpdateCredito' expected the parameter '@PersonaID', which was not specified.

Requesting the other columns, how would it be to update the specific column

UPDATE IS NOT CREATE Another routine or script is to use this one.

I have the following code that I am working on in MVC 5 Bootstrap and Razor

       @Html.TextBox("Agno", String.Format("{0:d}", DateTime.Now.ToString("yyyy")), new { @class = "form-control", type = "date", @required = "required" }) 

But it only shows me the control DatePickerand what I want is just to select the year, Select! not Edit! Can this be done?