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