Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. Private Sub BtnInsertar_Click(sender As Object, e As EventArgs) Handles BtnInsertar.Click
  2. Dim conexion As SqlConnection
  3. conexion = New SqlConnection("server=USER-PC; database=base1; integrated security=true")
  4. conexion.Open()
  5.  
  6. Dim placa As String = TxtPlaca.Text
  7. Dim marca As String = TxtMarca.Text
  8. Dim cilindraje As String = TxtCilindraje.Text
  9. Dim color As String = TxtColor.Text
  10. Dim modelo As String = TxtModelo.Text
  11.  
  12. Dim cadena As String = "insert into automovil (placa, marca, cilindraje, color, modelo) values (" & placa & ",'" & marca & "', " & cilindraje & ",'" & color & "','" & modelo & "')"
  13.  
  14. Dim comando As SqlCommand
  15. comando = New SqlCommand(cadena, conexion)
  16. comando.ExecuteNonQuery()
  17.  
  18. MessageBox.Show("Datos Ingresados Correctamente")
  19.  
  20. TxtPlaca.Text = ""
  21. TxtMarca.Text = ""
  22. TxtCilindraje.Text = ""
  23. TxtColor.Text = ""
  24. TxtModelo.Text = ""
  25.  
  26. conexion.Close()
  27. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement