Franco Torres's questions

I am trying to create a new client, in case it is successful, it should return to the main screen where all the clients are. But when trying to do it I get the error screen with the following error

The model element passed to the dictionary is of type 'System.Collections.Generic.List`1[SegurosDeVida.Models.DTO_Cliente]', but this dictionary requires a model element of type 'SegurosDeVida.Models.DTO_Cliente'.

This is the code for the create view, which I use to create the new client:

@model SegurosDeVida.Models.DTO_Cliente

@{
    ViewBag.Title = "Create";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>Create</h2>


@using (Html.BeginForm("Create", "Cliente"))
{
    @Html.AntiForgeryToken()
    
    <div class="form-horizontal">
        <h4>DTO_Cliente</h4>
        <hr />
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })

        <div class="form-group">
            @Html.LabelFor(model => model.Identificacion, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Identificacion, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Identificacion, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.Nombre, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Nombre, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Nombre, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.Apellido, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Apellido, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Apellido, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.Edad, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Edad, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Edad, "", new { @class = "text-danger" })
            </div>
        </div>


        <div class="form-group">
            <div class="col-md-offset-2 col-md-10">
                <input type="submit" value="Create" class="btn btn-default" />
            </div>
        </div>
    </div>
}

<div>
    @Html.ActionLink("Volver Atras", "Index","Cliente")
</div>

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

This is the code of the main view

@model IEnumerable<SegurosDeVida.Models.DTO_Cliente>

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>Index</h2>

<p>
    @Html.ActionLink("Nuevo Cliente", "Create","Cliente")>   
</p>
<table class="table">
    <tr>
        <th>
            Numero de Cliente
        </th>
        <th>
            Identificacion
        </th>
        <th>
            Nombre
        </th>
        <th>
            Apellido
        </th>
        <th>
            Edad
        </th>
        <th></th>
    </tr>

    @foreach (var item in Model)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.IdCliente)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.Identificacion)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.Nombre)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.Apellido)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.Edad)
            </td>
            <td>
                @Html.ActionLink("Editar", "Edit", "Cliente") |
                @Html.ActionLink("Eliminar", "Delete", "Cliente") |
            </td>
            </tr>
        }

    </table>

This is the code for the client controller, which I use to load clients on the main screen, as well as create new clients:

namespace SegurosDeVida.Controllers
{
    public class ClienteController : Controller
    {
        ServiceCliente service = null;
        [HttpGet]
        public ActionResult Index()
        {
            service = new ServiceCliente();
            return View(service.GetClientes(true));
        }

        [HttpGet]
        public ActionResult Create()
        {
            service = new ServiceCliente();
            return View();
        }
        [HttpPost]
        public ActionResult Create(string Identificacion, string Nombre, string Apellido, string Edad)
        {
            service = new ServiceCliente();
            bool exito;
            DTO_Cliente dto = new DTO_Cliente();
            DTO_Atributos dtoa = new DTO_Atributos();
            IList<DTO_Atributos> lista = new List<DTO_Atributos>();

            dtoa.IdAtributo = "1";
            dtoa.Titulo = "Maneja";
            dtoa.Valor = false;
            dtoa.Observaciones = "nada";

            lista.Add(dtoa);

            dtoa.IdAtributo = "2";
            dtoa.Titulo = "Usa Lentes";
            dtoa.Valor = false;
            dtoa.Observaciones = "nada";

            lista.Add(dtoa);

            dto.Identificacion = Identificacion;
            dto.Nombre = Nombre;
            dto.Apellido = Apellido;
            dto.Edad = Edad;
            dto.Activo = true;

            exito = service.RegistrarCliente(dto,lista);

            if (exito)
            {
                ViewBag.res = "Clientes registrado con exito";
                ViewBag.Alerta = "Success";
            }  
            else
            {
                ViewBag.res = "Error al registrar el cliente, intenten nuevamente";
                ViewBag.Alerta = "Danger";
            }
            return Index();
        }

        [HttpPost]
        public ActionResult Delete(string IdCliente)
        {
            service = new ServiceCliente();
            service.EliminarCliente(Convert.ToInt32(IdCliente));
            return Index();
        }
        
         
        }
}

As you can see, when registering the new client, I call Index(), which calls a service.GetClientes(true))that returns an IList<DTO_Client>. When I load the main screen, it brings me the clients without problems as seen:

but when calling Index(), from the creation view, it throws me the aforementioned error. I would be grateful if you could tell me where my error is, surely it is something nonsense, but I am just starting out in ASP.Net and I don't see where the error is.

Good morning, I am trying to append a TClientDataSet with another, but it may be that these 2 datasets have the same records. The problem is that this generates a Key violation error when trying to append, but I need to have the 2 records even if they are duplicates. I would like to add a field to the dataset and indicate that it is part of the Primary key, but I don't know how to do it.

This is the code I use to create the TClientDataSet:

//Esta funcion recibe como parametro ,la query y un boolean, y devuelve un TClientDataSet

function fxQueryToCDS(pqQuery : TFXQuery; pbFreeQuery : Boolean = true) : TClientDataSet;
var
  dspCDS : TDataSetProvider;
begin
  dspCDS := TDataSetProvider.Create(nil);
  Result := TClientDataSet.Create(nil);

  dspCDS.DataSet := pqQuery;
  try
    Result.Data := dspCDS.data;
  finally
    FreeAndNil(dspCDS);

    if pbFreeQuery then
      FreeAndNil(pqQuery);

  end;
  Result.Open;
end; 

This is a part of the code, it is in which it gives me the Key violation:

cdsConsulta1Principal := fxQueryToCDS(query1);
cdsConsulta1Sucursal := fxQueryToCDS(query2);
cdsConsulta1Principal.AppendData(cdsConsulta1Sucursal.Data, False);//aca da key violation si hay registros iguales.
cdsConsulta1Principal.MergeChangeLog;

Yes or if I need to append the records, even if they are duplicates, because the data comes from 2 different databases, but I can't think of how.

I am trying to update the value of a generator id. Trying to update the stream using a script throws me an error.

This is the script I'm trying to run

set term ^ ;
execute block
as
    declare variable codigo integer ;
begin
    select first 1 (peo2.codigo+1)
    from presupuestosestadosoportunidad peo2
    order by peo2.codigo desc
    into :codigo;

    execute statement
        'ALTER SEQUENCE GEN_PRESUPESTADOSOPORTUNIDAD RESTART WITH ' + cast(codigo as varchar(10))+ ';';
end ^
commit work ^
set term ; ^

This is the error that throws me:

can't format message 13:198 -- message file C:\Windows\firebird.msg not found. arithmetic exception, numeric overflow, or string truncation. string right truncation. At block line: 12, col: 1.

I can't understand why I get this error. My understanding is that to update a sequence, the value passed in has to be a constant. This is why I convert the code value to varchar. The value that the id should be having is approximately 453788.

Good morning, I'm using firebird 2.5 and I'm trying to change the data type of a column. First I drop the PK constraint, then I change the data type with the following code:

ALTER TABLE CABEZAMOVIMIENTOSEMPLEADOS DROP CONSTRAINT PK_CABEZAMOVIMIENTOSEMPLEADOS;

ALTER TABLE CABEZAMOVIMIENTOSEMPLEADOS
ALTER COLUMN NUMEROMOVIMIENTO
TYPE DOUBLE PRECISION

Then when I try to add the constraint again:

ALTER TABLE CABEZAMOVIMIENTOSEMPLEADOS ADD CONSTRAINT PK_CABEZAMOVIMIENTOSEMPLEADOS PRIMARY KEY (NUMEROMOVIMIENTO);

I get the following error:

can't format message 13:393 -- message file C:\Windows\firebird.msg not found. unsuccessful metadata update. Column: MOVENUMBER not defined as NOT NULL - cannot be used in PRIMARY KEY constraint >definition.

I try to solve it with the following code:

ALTER TABLE CABEZAMOVIMIENTOSEMPLEADOS ALTER COLUMN NUMEROMOVIMIENTO DOUBLE PRECISION NOT NULL
ALTER TABLE CABEZAMOVIMIENTOSEMPLEADOS ADD CONSTRAINT PK_CABEZAMOVIMIENTOSEMPLEADOS PRIMARY KEY (NUMEROMOVIMIENTO);

And now I get this error:

can't format message 13:896 -- message file C:\Windows\firebird.msg not found. Dynamic SQLError. SQL error code = -104. Token unknown - line 1, column 70. DOUBLE.

I don't know what I'm doing wrong, if you can help me I would appreciate it

I am programming in pascal and I use Delphi Xe7. I am trying to make the width of the columns of a grid adjust to its content, but to allow the width to be modified to suit the user. The grid is one TStringAlignGridand this is the code I use to adjust it to the content:

procedure TfPlanillaOrdenPreparacion.gDetalleDrawCell(Sender: TObject; ACol, ARow: Integer; Rect: TRect; State: TGridDrawState);
var
  vWidth : Integer;
begin
  if (FormPosition.WMaximized = True) then
  begin
    vWidth := gDetalle.Canvas.TextWidth(gDetalle.Cells[ACol, ARow]);
    if vWidth > aColWidthExpanded[ACol] then
      aColWidthExpanded[ACol] := vWidth+20;
    gDetalle.ColWidths[ACol] := aColWidthExpanded[ACol];
  end;
end;

At the time of loading the data, it is loaded correctly in the grid and adjusts to the content as it should be, but when you want to enlarge or reduce a column, I cannot do it. It's like I know that it disables the property that lets me modify the width. I don't understand what I'm doing wrong, I'm pretty new to delphi xe7, I appreciate your help :D.

Good day, I have a problem with a query generated by a Pascal procedure. The query is as follows:

Select CodigoProveedor as Codigo 
From proveedores 
where Activo = 1
And CodigoProvedores not in (....aca hay muchos strings)
--y a su vez hay muchos NOT IN por una cuestion de lectura

And it throws me the following error:

I think that the engine expected a space or a ;, given the length of the query and that is why it throws me the error, but I really have no idea. If you can give me a hand I would appreciate it.

I'm reneging on a function to remove [] from a string. I need to remove the brackets from a string, but the problem I'm having is that those [] can be anywhere in the string.

The code I am using is the following:

function quitarCorchetes(descripcion: string): String;
Begin
  if descripcion <> '' then
    if descripcion[1] = '[' then
      descripcion := Copy(descripcion,2,Length(descripcion)-2);
  Result := descripcion;
End;

This code works for strings that are "[algo adentro]", the problem is when the string is of type "[algo] mas descripcion"or "descripcion [algo]".I don't know if there is any way to do it using a regular expression or something like that. I am very new to pascal and don't have much idea.

I'm starting in the world of python and I'm trying to sort a list of objects under a certain criteria, but when I indicate the criteria I get the error

Expected collections.Iterable, got 'None' instead`.

I have a class Prenda:

class Prenda():
    def __init__(self,identificacion,descripcion,precio,stock,tipo):
        self.identificacion = identificacion;
        self.descripcion = descripcion;
        self.precio = precio;
        self.stock = stock;
        self.tipo = tipo;

    def toString(self):
        print("Identificacion: " + str(self.identificacion))
        print("Descripcion: "+self.descripcion)
        print("Precio: $"+str(self.precio))
        if stock > 0:
            print("Cantidad en stock: " +str(self.stock))
        else:
            print("No queda stock")
        print("Tipo de prenda: "+str(self.tipo))

I have a small code that requests the number of garments to load and with a cycle forI request the data according to the number of garments that I enter:

for x in range(cantidad):
    identificacion = int(input("Identificacion de prenda: "))
    descripcion = input("Descripcion: ")
    precio = float(input("Precio: "))
    stock = int(input("Cantidad en stock: "))
    tipo = int(input("Tipo de prenda (valores entre 0 y 14, con ambos numeros incluidos): "))
    print()
    p = Prenda(identificacion, descripcion, precio, stock, tipo)
    lista.append(p)

    while tipo < 0 or tipo > 14:
        tipo = int(input("Tipo de prenda (valores entre 0 y 14, con ambos numeros incluidos: "))
        p = Prenda(identificacion, descripcion, precio, stock, tipo)
        lista.append(p)
        print()

After this I try to show the data of all the garments from lowest to highest, according to their price, but this is where I get the error:

for x in lista.sort(key = x.precio): #<-- aca es donde me sale el error.
    x.toString()

I have also tried with:

for x in lista.sort(key= lambda prenda: prenda.precio):
    x.toString()

It doesn't work either, if I try to execute the code even with the error, when I reach the line where the is .sort(), it throws me the following error.

Traceback (most recent call last):
  File "C:/Users/Usuario/PycharmProjects/pythonProject/main.py", line 53, in <module>
    for x in lista.sort(key= lambda prenda: prenda.precio):
TypeError: 'NoneType' object is not iterable

I am trying to create a backup in excel with the data loaded in a DataGridView, but when validating if the file exists it validates wrong. When the file doesn't exist it validates fine and creates it, but when the file already exists it tries to create it the same. I am using visual studio 2017.

This is the code of the method that creates the backup:

public void respaldarInfo(DataGridView dgv)
{
    Service_Inscripcion service = new Service_Inscripcion();
    DateTimeFormatInfo fecha = new System.Globalization.DateTimeFormatInfo();

    //variable para crear o buscar la carpeta donde se va a guardar el respaldo en excel.
    //Dentro de la carpeta Respaldo Sport Gym, se van a crear subCarpetas con el formato: "nombre del mes" "año"
    string ruta = "C:\\Respaldo Sport Gym\\" + DateTime.Now.ToString("MMMM") + " " + DateTime.Now.Year.ToString();

    //variable para darle nombre al excel con el formato: "dia"-"mes"-"año"
    string excel = DateTime.Now.Day.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Year.ToString();

    //variable que junta la ruta de la carpeta + la ruta que deberia tener el archivo a crear.
    string rutaFinal = ruta + "\\" + excel; ;

    IList<DTO_Inscripcion> inscripciones = service.getInscripciones();
    if (!Directory.Exists(ruta) && dgv != null)//valida que la carpeta no exista
    {
        Directory.CreateDirectory(ruta);//en caso de no existir se crea

        //Valida que la lista tenga valores para guardar
        if (inscripciones != null && inscripciones.Count > 0)
        {
            crearExcel(dgv,inscripciones,rutaFinal);
        }
        else
        {
            MessageBox.Show("No hay datos para guardar", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
    }
    else//este else se ejecuta si el directorio donde se crean los respaldos existe.
    {
        if (inscripciones != null && inscripciones.Count > 0)//valida que la lista que llena el DataGridView tenga datos
        {
            if(!File.Exists(rutaFinal))//valida que el archivo no haya sido creado ya
            {
                crearExcel(dgv, inscripciones, rutaFinal);
            }
        }
        else
        {
            MessageBox.Show("No hay datos para guardar", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
    }
}

And this is the code of the method that creates the excel, in case there is an error in this method that affects the other:

private void crearExcel(DataGridView dgv, IList<DTO_Inscripcion> inscripciones, string rutaFinal)
{
    //try para capturar algun error que pueda suceder al momento de crear y dar formato al Excel
    try
    {
        Microsoft.Office.Interop.Excel.Application aplicacion;
        Microsoft.Office.Interop.Excel.Workbook libros_trabajo;
        Microsoft.Office.Interop.Excel.Worksheet hoja_trabajo;
        aplicacion = new Microsoft.Office.Interop.Excel.Application();
        libros_trabajo = aplicacion.Workbooks.Add();
        hoja_trabajo =
            (Microsoft.Office.Interop.Excel.Worksheet)libros_trabajo.Worksheets.get_Item(1);

        for (int i = 0; i < dgv.Rows.Count; i++)
        {
            for (int j = 0; j < dgv.Columns.Count; j++)
            {
                hoja_trabajo.Cells[i + 2, j + 1] = dgv.Rows[i].Cells[j].Value.ToString();
            }
        }
        //nombre de las columnas del excel
        hoja_trabajo.Cells[1, "A"] = "Nº Inscripcion";
        hoja_trabajo.Cells[1, "B"] = "Orden";
        hoja_trabajo.Cells[1, "C"] = "Socio";
        hoja_trabajo.Cells[1, "D"] = "Nombre";
        hoja_trabajo.Cells[1, "E"] = "Apellido";
        hoja_trabajo.Cells[1, "F"] = "Vencimiento";
        hoja_trabajo.Cells[1, "G"] = "Estado";
        hoja_trabajo.Cells[1, "H"] = "Fecha Pago";
        hoja_trabajo.Cells[1, "I"] = "Hora Ingreso";
        hoja_trabajo.Cells[1, "J"] = "Hora Egreso";
        //formato de la hoja
        hoja_trabajo.Range["A1", "J" + (dgv.Rows.Count) + 1.ToString()].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
        hoja_trabajo.Range["A1", "J1"].Font.Bold = true;
        hoja_trabajo.Range["A1", "J1"].Font.Size = 16;
        hoja_trabajo.Range["A1", "J1"].Interior.ColorIndex = 17;
        hoja_trabajo.Range["A2", "J2" + (dgv.Rows.Count + 1).ToString()].Font.Size = 12;
        hoja_trabajo.Columns.AutoFit();
        //

        //linea que guarda el archivo
        libros_trabajo.SaveAs(rutaFinal, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal);
        libros_trabajo.Close(true);
        aplicacion.Quit();
        MessageBox.Show("El respaldo se realizo correctamente", "Exito", MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error al intentar generar el archivo Excel", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
}

I have put a breakpoint to see what it returns File.Exists()and it always returns false, even if the file exists. I have forced it to enter true or false in the following ways:

if(!File.Exists(rutaFinal))//valida que el archivo no haya sido creado ya
{
    crearExcel(dgv, inscripciones, rutaFinal);
}

and here taking out the !

if(File.Exists(rutaFinal))//valida que el archivo no haya sido creado ya
{
    crearExcel(dgv, inscripciones, rutaFinal);
}

Both codes return false, which doesn't make sense. If you know of another way to validate that the file exists, I would appreciate it. I have read/write permissions.

I am trying to update the data of a DataGridView when I press a button from another. To explain myself better, I have a main form where all registered partners are displayed, then a secondary form from where I create new partners. I need that when I press the button that saves the new partner, I update the DataGridView of the main form. I have tried to achieve this with an interface that communicates to the 2 forms and calls the update method but it does nothing. As a clarification, I am not looking to pass data from one form to another, I am looking to be able to call the method that is responsible for loading the grid but from another child form.

The main form code:

public partial class frm_principal_socio : Form, IForm//implementa la interfaz que cree para llamar al metodo de actualizacion
{
    private void frm_principal_Load(object sender, EventArgs e)
    {
        this.llenarCombos();
        this.cargarGrillaInscripciones(svInscripcion.getInscripciones());
        this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
        timer1.Start();
    }

    //metodo para llenar el DataGridView
    public  void cargarGrilla(IList<DTO_Socio> lista)
    {
        dgv_socios.Rows.Clear();
        if (lista != null && lista.Count > 0)
        {
            habilitarBotonesNoError();
            foreach (DTO_Socio dto in lista)
            {
                dgv_socios.Rows.Add(new Object[]
                        {
                            dto.NumeroSocio,
                            dto.Nombre,
                            dto.Apellido,
                            dto.Dni
                        });
            }
        }
    }
    

    //metodo que actualiza la grilla desde la interfaz
    public void actualizarDatos()
    {
        this.cargarGrillaInscripciones(svInscripcion.getInscripciones());
    }
}

interface code

public interface IForm
{
    void actualizarDatos();
}

Code of the secondary form, this is the form that calls the main one:

private void btn_guardar_Click(object sender, EventArgs e)
{
    //......aca esta el codigo que valida los textBox y los datos ingresados
    //...

   retorno = (service.registrarSocio(dto) == 1);//valida que en la base de datos se haya creado el socio nuevo y si es correcto retorna 1
   if (retorno == true)
   {
       //bloque de código que debería actualizar el otro formulario
       IForm frm_p = this.Owner as IForm;
       if (frm_p != null)
       {
           frm_p.actualizarDatos();//llamo al actualizar datos del principal
       }
       MessageBox.Show("Socio registrado con exito", "Exito", MessageBoxButtons.OK, MessageBoxIcon.Information);
       this.limpiarCampos();
   }
   else
   {
       MessageBox.Show("Hubo un problema al registrar al socio, intente nuevamente", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
       this.limpiarCampos();
   }    
}

I add the code of the button that calls the form to register a new user:

private void btn_socios_Click(object sender, EventArgs e)
{
    Form frm = Application.OpenForms.Cast<Form>().FirstOrDefault(x => x is frm_nuevo_socio);
    if (frm == null || frm.IsDisposed == true)
    {
        frm = new frm_nuevo_socio();
        frm.ShowDialog();
    }           
    else
    {
        frm.BringToFront();
    }               
}

To clarify, the method that fills the DataGridView works perfectly, it works at startup or when applying a filter to it on the main form. The new member form also works perfectly since it registers the member in the database, the only problem is that I cannot call the method to update the DataGridView from the new member form and thus show that the new member has been added.

I've been doing some research and this code should work but it doesn't do anything, when I go to the main form there are the same partners as before I created the new one. Another solution is to call the button that refreshes the DataGridView, but it doesn't either or I'm possibly doing it wrong.

I am trying to save an excel that is created with the data in a list, but it does not save it. I would also like to know how to give that Excel a specific name, for example, what is it called "Respaldo " + Dia/Mes/Añoand how to make the file that is generated be .xlsxand not .xls.

Here is the code I am using:

private void btn_exportar_excel_Click(object sender, EventArgs e)
        {
            string ruta = "c:\\Respaldo";
            SaveFileDialog fichero = new SaveFileDialog();
            fichero.Filter = "Excel (*.xls)|*.xls";
            IList<DTO_Inscripcion> inscripciones = svInscripcion.getInscripciones();
            if (!Directory.Exists("c:\\Respaldo"))
            {
                Directory.CreateDirectory("c:\\Respaldo");

                //Valido que la lista tenga valores para guardar
                if (inscripciones != null && inscripciones.Count > 0)
                {
                    // este try es para capturar algun error que pueda suceder al momento de crear y dar formato al Excel
                    try
                    {
                        Microsoft.Office.Interop.Excel.Application aplicacion;
                        Microsoft.Office.Interop.Excel.Workbook libros_trabajo;
                        Microsoft.Office.Interop.Excel.Worksheet hoja_trabajo;
                        aplicacion = new Microsoft.Office.Interop.Excel.Application();
                        libros_trabajo = aplicacion.Workbooks.Add();
                        hoja_trabajo =
                            (Microsoft.Office.Interop.Excel.Worksheet)libros_trabajo.Worksheets.get_Item(1);

                        for (int i = 0; i < dgv_inscripciones.Rows.Count; i++)
                        {
                            for (int j = 0; j < dgv_inscripciones.Columns.Count; j++)
                            {
                                hoja_trabajo.Cells[i + 2, j + 1] = dgv_inscripciones.Rows[i].Cells[j].Value.ToString();
                            }
                        }
                        hoja_trabajo.Cells[1, "A"] = "Socio";
                        hoja_trabajo.Cells[1, "B"] = "Nombre";
                        hoja_trabajo.Cells[1, "C"] = "Apellido";
                        hoja_trabajo.Cells[1, "D"] = "Vencimiento";
                        hoja_trabajo.Cells[1, "E"] = "Estado";
                        hoja_trabajo.Cells[1, "F"] = "Fecha Pago";

                        //hoja_trabajo.Range["A5", "F5"].Merge();
                        hoja_trabajo.Range["A1", "F" + dgv_inscripciones.Rows.Count.ToString()].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
                        hoja_trabajo.Range["A1", "F" + dgv_inscripciones.Rows.Count.ToString()].Font.Bold = true;
                        hoja_trabajo.Range["A1", "F" + dgv_inscripciones.Rows.Count.ToString()].Font.Size = 20;

                        //este try es para capturar algun error al momento de intentar guardar el archivo
                        try
                        {
                            libros_trabajo.SaveAs(ruta, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal);
                            libros_trabajo.Close(true);
                            aplicacion.Quit();
                        }
                        catch(Exception exsave)
                        {
                            MessageBox.Show("Error al intentar guardar el archivo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                    }
                    catch(Exception ex)
                    {
                        MessageBox.Show("Error al intentar generar el archivo Excel", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }

                    
                }
                else
                {
                    MessageBox.Show("No hay datos para guardar", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
}

When I run the code I get the following exception and is caught by the first Catch:

System.Runtime.InteropServices.COMException: 'Microsoft Excel no puede obtener acceso al archivo 'c:\'. Puede haber varios motivos:

• El nombre o la ruta del archivo no existen.
• Otro programa está usando el archivo.
• El libro que está intentando guardar tiene el mismo nombre que otro libro que está abierto en estos momentos.'

when I try to reopen a form that was closed from the X of the window I get the exception System.ObjectDisposedExceptionwith the message "Cannot access the discarded object. Object name: 'frm_schedules'."

I understand that X calls the method Dispose(), which releases resources, but I don't know to what extent it releases. I check that the form is not Nullwhen I call it, but it keeps throwing that exception.

Code of the form frm_horarios, is what I call:

public partial class frm_horarios : Form
    {
        private static Form instancia = null;  //implemento el patron singleton para tener solo una instancia de este formulario

        private frm_horarios()
        {
            InitializeComponent();
        }

        public static Form getFormularioHorario()
        {
            if(instancia ==null)
            {
                instancia = new frm_horarios();
                return instancia;
            }
            else
            {
                return instancia;
            }
        }
    }

Code of the button that calls the form frm_hours:

private void btn_horarios_Click(object sender, EventArgs e)
        {
            if(horario !=null)//la variable horario es del tipo Form y se encuentra declarada en el principio de la clase
            {
                horario.Show();
            }          
            else
            {
                horario = frm_horarios.getFormularioHorario();
                horario.Show();
            }
        }

I am trying to load a DataGridView with a list of filtered partners, but at the time of loading I load all the partners plus those that I filter. I don't see where the error could be. The filter is applied while you write, to explain myself better: if I enter fra it has to show all the members, whose names start with those 3 letters, such as Franco, Francisco, Franca, etc.

The textBox code is as follows:

private void txt_filtro_nombre_TextChanged(object sender, EventArgs e)
        {       
            if (!String.IsNullOrWhiteSpace(txt_filtro_nombre.Text))
            {
                cargarGrilla(svSocio.getSocioPorNombre(txt_filtro_nombre.Text));
            }
        }

The code getSocioPorNombre(textbox)that brings me the data is as follows:

public IList<DTO_Socio> getSocioPorNombre(string nombre)
        {
            IList<DTO_Socio> lista = new List<DTO_Socio>();
            IList<Socio> listaSocios = dao.getSociosPorNombre(nombre);
            foreach (Socio socio in listaSocios)
            {
                lista.Add(mapSocio.getDtoSocio(socio));
            }

            return lista;
        }

which communicates with the DAO that brings me the data from the database and has this code:

public IList<Socio> getSociosPorNombre(string nombre)
        {
            string sp = "listar_socios_por_nombre";
            var parametro = new SqlParameter("@nombre", nombre);
            parametro.SqlDbType = SqlDbType.VarChar;

            IList<Socio> listaSocios = getSocios();
            DataTable tabla = helper.consultarStoredProcedureConUnParametro(sp, parametro);
            foreach (DataRow fila in tabla.Rows)
            {
                listaSocios.Add(mapper(fila));
            }
            return listaSocios;
        }

The helper code that communicates with the database:

public DataTable consultarStoredProcedureConUnParametro(string sp, SqlParameter parametro)
        {
            SqlConnection cnn = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            DataTable tabla = new DataTable();

            try
            {
                cnn.ConnectionString = string_conexion;
                cnn.Open();
                cmd.Connection = cnn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = sp;
                cmd.Parameters.Add(parametro);
                tabla.Load(cmd.ExecuteReader());
                return tabla;
            }
            catch (SqlException ex)
            {
                MessageBox.Show("EXPLOTO EL HELPER", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                throw (ex);
            }
            finally
            {
                this.CloseConnection(cnn);
            }
        }

The code ofcargarGrilla():

dgv_socios.Rows.Clear();
            if (lista != null)
            {
                foreach (DTO_Socio dto in lista)
                {
                    dgv_socios.Rows.Add(new Object[]
                            {
                                dto.NumeroSocio,
                                dto.Nombre,
                                dto.Apellido,
                                dto.Dni
                            }
                        );
                }
            }
            else
            {
                MessageBox.Show("No hay datos para mostrar", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

I can't see where the error is, for which it brings me all the partners + the filtered ones.

I leave you an image of what I say

Run the SP on the database to see if that failed, but it works great

I am creating a project in C# with sql server 2017 and I have the DAO_Socio class, which is responsible for assembling the objects that communicate with the Database:

public Inscripcion getSociosPorNombre(string nombreSocio)
            {   
                string sp, columna, parametro;
                sp = "sp_listar_socios_por_nombre";
                columna = "@nombre";
                parametro = nombreSocio;
                DataTable tabla = getSociosPorNombre(sp,columna,parametro);
                Inscripcion inscripcion = new Inscripcion();
                foreach (DataRow fila in tabla.Rows)
                {
                    inscripcion = mapper(fila);              
                }
                return inscripcion;
            }

In turn, the DBHelper class is responsible for communicating with the database.

The following method allows me to bring a table from the database, through a stored procedure:

public DataTable getSociosPorNombre(string storedProcedure, string nombreColumna, string parametro)
        {
            SqlConnection cnn = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            DataTable tabla = new DataTable();
            
            try
            {
                cnn.ConnectionString = string_conexion;
                cnn.Open();
                cmd.Connection = cnn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = storedProcedure;
                cmd.Parameters.AddWithValue(nombreColumna,parametro);
                tabla.Load(cmd.ExecuteReader());
                return tabla;
            }
            catch (SqlException ex)
            {
                MessageBox.Show("EXPLOTO EL HELPER", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                throw (ex);
            }
            finally
            {
                this.CloseConnection(cnn);
            }
        }

The problem with this method is that I can only pass a single parameter to it. How do I make the method execute any type of SP, with any number of parameters without having to specify the name of the column and the value that I pass to it.

I have a table called Cuota, which has a Fecha_vencimiento(of type Date) and a estado(of type varchar). I need that when the expiration date arrives, the status changes automatically from 'VALIDA'to 'VENCIDA'.

I don't know if I have to do it with a stored procedure or with a trigger; if it is with any of these 2, how do I make it run automatically when the expiration date arrives?

I'm trying to get the latest payments from several clients, but I can't filter them well. I have tried with the following query but it doesn't work, I also tried with subquery but I can't get the desired result. I leave an image of what I get and what I want to get:

select distinct s.nroSocio, s.nombre, s.apellido, max(c.fechaPago)as 'Ultimo pago', c.estado
from Socios s join Cuotas c on s.nroSocio = c.nroSocio
group by  s.nroSocio, s.nombre, s.apellido, c.fechaPago, c.estado
order by 4 desc

Here I leave the 2 tables that I use:

This is the query I'm using, try to get the maximum date with a subquery with MAX and TOP, but it doesn't work either. Sure I have a conceptual error, if you could give me a hand it would be of great help.

I need to compare the date of a cell against a column that has several dates, see which one matches and get the associated value. Here is an image to explain better:

Column D is where I need to put the formula, which compares the dates in column A of sheet 1 with the dates in column A of sheet 2. If it matches, I need to multiply the values ​​in column C of sheet 1 by the values ​​in column B of sheet 2.

Here is another image with an example to be clearer

I have a little idea that would be something like: =IF(ISERROR(MATCH(Sheet1!A4;Sheet2!A2:A32;0));Sheet1!C4*....

Where the ellipses are, B3 should go, but I don't know how to get that cell in the search above. I'm waiting for some ideas, thank you very much. :)

Hi, I'm trying to read a .txt with 10 million numbers, and it only reads 5 million and I really don't know where the problem is. Here is the code of the method I am using:

public double promedioDouble() throws IOException
    {
        double acumulador = 0;
        int contador = 0;
        try{
                file = new FileReader(ruta);
                reader = new BufferedReader(file);
                while(reader.readLine()!=null)
                {
                    acumulador+=Double.parseDouble(reader.readLine());
                    contador++;
                }

            }
        catch (IOException e) 
        {
              System.out.println("cant read");
        }
        finally {
            if (file != null) file.close();
        }             
        return acumulador/contador;
    }

I did a print to the counter and it only counts 5 million.