Tengo este codigo
Código:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
coneccion = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=anime.mdb")
Dim orden1 As OleDb.OleDbCommand
Dim orden2 As OleDb.OleDbCommand
Dim orden3 As OleDb.OleDbCommand
Dim orden4 As OleDb.OleDbCommand
Dim orden_pre As OleDb.OleDbCommand
If accion = 1 Then
MsgBox("ok sere")
q = "insert into respuesta(id_pregunta,respuesta,correcta) values(@ID_PREGUNTA,@R1,@R1C)"
'q = "insert into respuesta(id_pregunta,respuesta) values(@ID_PREGUNTA,@R2)"
'q = "insert into respuesta(id_pregunta,respuesta,correcta) values(@ID_PREGUNTA,@R3,@R3C)"
'qp = "insert into respuesta(id_pregunta,respuesta,correcta) values(@ID_PREGUNTA,@R4,@R4C)"
Else
MsgBox("actualiza")
q = "update respuesta set respuesta = @R4C where id =" & lblrespuesta1.Text
End If
orden1 = New OleDb.OleDbCommand(q, coneccion)
orden2 = New OleDb.OleDbCommand(q, coneccion)
orden3 = New OleDb.OleDbCommand(q, coneccion)
orden4 = New OleDb.OleDbCommand(q, coneccion)
orden_pre = New OleDb.OleDbCommand(q, coneccion)
orden1.Parameters.Add(New OleDb.OleDbParameter("@ID_PREGUNTA", OleDb.OleDbType.Integer))
orden2.Parameters.Add(New OleDb.OleDbParameter("@ID_PREGUNTA", OleDb.OleDbType.Integer))
orden3.Parameters.Add(New OleDb.OleDbParameter("@ID_PREGUNTA", OleDb.OleDbType.Integer))
orden4.Parameters.Add(New OleDb.OleDbParameter("@ID_PREGUNTA", OleDb.OleDbType.Integer))
orden_pre.Parameters.Add(New OleDb.OleDbParameter("@ID_PREGUNTA", OleDb.OleDbType.Integer))
orden_pre.Parameters.Add(New OleDb.OleDbParameter("@PREGUNTA", OleDb.OleDbType.VarWChar, 250))
orden_pre.Parameters.Add(New OleDb.OleDbParameter("@TIPO", OleDb.OleDbType.VarWChar, 20))
orden_pre.Parameters.Add(New OleDb.OleDbParameter("@NIVEL", OleDb.OleDbType.Integer))
orden1.Parameters.Add(New OleDb.OleDbParameter("@R1", OleDb.OleDbType.VarWChar, 100))
orden2.Parameters.Add(New OleDb.OleDbParameter("@R2", OleDb.OleDbType.VarWChar, 100))
orden3.Parameters.Add(New OleDb.OleDbParameter("@R3", OleDb.OleDbType.VarWChar, 100))
orden4.Parameters.Add(New OleDb.OleDbParameter("@R4", OleDb.OleDbType.VarWChar, 100))
orden1.Parameters.Add(New OleDb.OleDbParameter("@R1C", OleDb.OleDbType.Boolean))
orden2.Parameters.Add(New OleDb.OleDbParameter("@R2C", OleDb.OleDbType.Boolean))
orden3.Parameters.Add(New OleDb.OleDbParameter("@R3C", OleDb.OleDbType.Boolean))
orden4.Parameters.Add(New OleDb.OleDbParameter("@R4C", OleDb.OleDbType.Boolean))
orden1.Parameters("@ID_PREGUNTA").Value = Val(lblid.Text)
orden2.Parameters("@ID_PREGUNTA").Value = Val(lblid.Text)
orden3.Parameters("@ID_PREGUNTA").Value = Val(lblid.Text)
orden4.Parameters("@ID_PREGUNTA").Value = Val(lblid.Text)
orden_pre.Parameters("@ID_PREGUNTA").Value = Val(lblid.Text)
orden_pre.Parameters("@NIVEL").Value = Val(txtnivel.Text)
orden_pre.Parameters("@PREGUNTA").Value = txtpregunta.Text
orden_pre.Parameters("@TIPO").Value = txttipo.Text
orden1.Parameters("@R1").Value = respuesta1.Text
orden2.Parameters("@R2").Value = respuesta2.Text
orden3.Parameters("@R3").Value = respuesta3.Text
orden4.Parameters("@R4").Value = respuesta4.Text
orden1.Parameters("@R1C").Value = rb1.Checked
orden2.Parameters("@R2C").Value = rb2.Checked
orden3.Parameters("@R3C").Value = rb3.Checked
orden4.Parameters("@R4C").Value = rb4.Checked
MsgBox(orden1.Parameters("@R1").Value)
orden1.Connection.Open()
orden1.ExecuteNonQuery()
orden1.Connection.Close()
orden2.Connection.Open()
orden2.ExecuteNonQuery()
orden2.Connection.Close()
orden3.Connection.Open()
orden3.ExecuteNonQuery()
orden3.Connection.Close()
orden4.Connection.Open()
orden4.ExecuteNonQuery()
orden4.Connection.Close()
Me.Close()
End Sub

