Insert data from a data grid view to a table in sql server from vb, net

0

Good afternoon I am trying to insert data from a datagridview in a database of slq server I have it by classes, here the classes if you could help me:

'Insertar quejas 
    Function Insertar_Queja2(ByRef NUM_RECLAMO As String, PRODUCTO As String, ByVal NUM_ORDEN As String,
                    ByVal CANTIDAD As String, ByVal UNID_MEDIDA As String, ByVal FACTURA As String,
                    ByVal PRECIO_UNI As String, ByVal PRECIO_TOTAL As String, ByVal DESCRIPCION As String) As String

        Dim salida As String = "Se genero el Reclamo"

        Dim fila As DataGridViewRow = New DataGridViewRow()
        Try
            For Each fila In frmQuejas.DataGridView1.Rows

            Next
            cmd = New SqlCommand("Sp_InsertarQUeja_Producto", cn)
            cmd.CommandType = CommandType.StoredProcedure
            With cmd.Parameters
                .AddWithValue("@Num_Reclamo", NUM_RECLAMO)
                .AddWithValue("@Producto", PRODUCTO)
                .AddWithValue("@Num_Orden", NUM_ORDEN)


            End With
            cmd.ExecuteNonQuery()
        Catch ex As Exception
            salida = "No se genero debido a: " + ex.ToString
        End Try
        Return salida
    End Function

---------------------------------Este es el boton ------------------------------
 MsgBox(conn.Insertar_Queja2(TxtNumQueja.Text, Column1.ToString, Column2.ToString))

-----------Store Procedure-------------------

ALTER procedure [dbo].[Sp_InsertarQUeja_Producto]

@Num_Reclamo AS VARCHAR (50),
@Producto AS VARCHAR (50),
@Num_Orden AS VARCHAR (50),


as
Insert RECLAMOS_PRODUCTO (Num_Reclamo,Producto,No_Orden)
values
(@Num_Reclamo,@Producto,@Num_Orden)

------------esto se incerta en la base de datos--------------------

Num_Reclamo         Q-00015 

Producto            DataGridViewTextBoxColumn { Name=Column1, Index=0  

No_Orden           DataGridViewTextBoxColumn { Name=Column2, Index=0                        

Thank you very much

    
asked by Cristopher Salay 30.10.2017 в 21:29
source

0 answers