A record in SQL is inserted twice from ASP.NET C #

0

**

<button runat="server" id="cmdSavep" class="btn btn-success" onserverclick="savepago">Guardar</button>                                
            
        SqlConnection conn = new SqlConnection();
        SqlCommand coman = new SqlCommand();

        conn.ConnectionString = ConfigurationManager.ConnectionStrings["miconexion"].ToString();
        coman.Connection = conn;
        coman.CommandText = "insert into webpagos (comprobante,formapago,montopago,fechapago,comentario,fecha_audita,user_audita " +
                                ")values(@comprobante,@formapago,@montopago,@fechapago,@comentario,getdate(),@user_audita)";

        coman.Parameters.AddWithValue("@comprobante", cComproba);
        coman.Parameters.AddWithValue("@formapago", cTPpago);
        coman.Parameters.AddWithValue("@montopago", cMontopago);
        coman.Parameters.AddWithValue("@fechapago", dtFechaPago);
        coman.Parameters.AddWithValue("@comentario", cComenta);
        coman.Parameters.AddWithValue("@user_audita", "XXXY");

        try
        {
            conn.Open();
            coman.ExecuteNonQuery();
            conn.Close();
        }
        catch (Exception ex)
        {
            conn.Close();
        }
    
asked by Luis Preciado 30.10.2018 в 18:33
source

0 answers