Fatal error during command execution (MySQL, VBNET)

0

I have a problem when inserting data from a VB.Net application to a Mysql database, the problem I have has been asked by many other people but I can not find exactly what my code is failing

Function Guardar_Datos() As Boolean
    Dim err As Boolean = False
    Dim con As New MySqlConnection
    Dim captura As String = "" 
    con.ConnectionString = server
    Try
        con.Open()
        Try



            For f As Integer = 0 To DataGridView1.RowCount - 1
                captura = "INSERT INTO estatusdeot.presupuestos ('Presupuesto', 'Obra', 'Cliente', 'Direccion', 'Atencion', [Ruta de Archivo], 'Cotizo', 'Factor', [Monto Ppto.], 'Fecha')" & _
                     "VALUES (@Presupuesto, @Obra, @Cliente, @Direccion, @Atencion, @RutadeArchivo, @Cotizo, @Factor, @MontoPpto, @Fecha);"
                Dim insertar As New MySqlCommand(captura, con)
                'insertar.Prepare()

                insertar.Parameters.AddWithValue("@Presupuesto", DataGridView1.Item(0, f).Value)
                insertar.Parameters.AddWithValue("@Obra", DataGridView1.Item(1, f).Value.ToString)
                insertar.Parameters.AddWithValue("@Cliente", DataGridView1.Item(2, f).Value.ToString)
                insertar.Parameters.AddWithValue("@Direnccion", DataGridView1.Item(3, f).Value.ToString)
                insertar.Parameters.AddWithValue("@Atencion", DataGridView1.Item(4, f).Value.ToString)
                insertar.Parameters.AddWithValue("@RutadeArchivo", DataGridView1.Item(5, f).Value.ToString)
                insertar.Parameters.AddWithValue("@Cotizo", DataGridView1.Item(6, f).Value.ToString)
                insertar.Parameters.AddWithValue("@Factor", DataGridView1.Item(7, f).Value)
                insertar.Parameters.AddWithValue("@MontoPpto", DataGridView1.Item(8, f).Value)
                insertar.Parameters.AddWithValue("@Fecha", DataGridView1.Item(9, f).Value.ToString)
                insertar.ExecuteNonQuery()
            Next
            err = False
        Catch ex As Exception
            MsgBox(ex.Message)
            err = True
        End Try
        con.Close()
        con.Dispose()
    Catch exc As Exception
        MsgBox("hubo un error al conectar con servidor " & vbCrLf & exc.Message, vbCritical)
    End Try
    Return err
End Function

The Budget field and the Factor Field are as Int (11) and the Amount field is as Decimal (15.2).

Thanks for your help.

    
asked by Rchrd 09.11.2018 в 01:53
source

0 answers