¿Cómo guardo los datos de un gridview en una tabla (sql server)?
Para guardar los datos de un botón.
Protected Sub Button_1Click(sender As Object, e As EventArgs) Handles Button_1.Click
Dim cQuery As String = "SELECT * FROM TABLA_ORIGEN ORDER BY int_id ASC"
Dim Ds As New DataSet
Dim Da As New SqlClient.SqlDataAdapter(cQuery, Cnn)
Da.Fill(Ds)
Dim myDataView As DataView = New DataView(Ds.Tables(0))
If myDataView.Count > 0 Then
For x = 0 To myDataView.Count - 1
Try
Dim cSentencia = "INSERT INTO TABLA_DESTINO (in_solicitud,strarticulo,strdescripcion,strproveedor)"+
" values (@solicitud,@articulo,@descripcion,@proveedor)"
Dim command = New SqlCommand(cSentencia, Cnn)
command.Parameters.AddWithValue("@solicitud", myDataView(x)("strsolicitud"))
command.Parameters.AddWithValue("@articulo", myDataView(x)("strarticulo"))
command.Parameters.AddWithValue("@descripcion", myDataView(x)("strdescripcion"))
command.Parameters.AddWithValue("@proveedor", myDataView(x)("strproveedor"))
Cnn.Open()
command.ExecuteNonQuery()
Cnn.Close()
Catch ex As Exception
Me.mensaje.Text = ex.Message
End Try
Next
End If
End sub
Visita: https://vbpuntonet.blogspot.com/