Results 1 to 4 of 4

Thread: Mysql And Vb

  1. #1
    Join Date
    Jul 2007
    Posts
    4
    Rep Power
    0

    Smile Mysql And Vb

    Hi All
    has any one used Mysql and vb together to code?, does anyone have any good ebooks for a beginning user of mysql and Visual basic?

    thanks...

  2. #2
    Join Date
    Nov 2004
    Posts
    41
    Rep Power
    0

    Default

    It's almost the same as using SQL Server..
    i have some .NET books gimme a link at dow_2002@yahoo.com

  3. #3
    Join Date
    Jul 2007
    Posts
    4
    Rep Power
    0

    Default

    Kool, thanks bredz will email...

  4. #4
    Join Date
    Dec 2005
    Posts
    4
    Rep Power
    0

    Default

    to edit u need to use update
    here is an example

    Code:
    Private Sub cmdupdate_Click()
    
    Dim cn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    
    
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:\NYSPlacementDatabase\NYSPlacementDatabase.mdb;"
    
    Dim sql As String
    
    Dim container As Integer
    container = CInt(txtID.Text)
    
    
    sql = "select * from PostApplicant where Post_ID=" & container
    
    rs.Open sql, cn, adOpenDynamic, adLockOptimistic
    
    
    rs("Post_ID") = txtID.Text
    rs("FirstName") = txtFirstName.Text
    rs("LastName") = txtLastName.Text
    rs("Post_Age") = txtage.Text
    rs("PhoneCell") = txtPhoneCell.Text
    rs("PhoneFixed") = txtPhoneFixed.Text
    rs("Address") = txtAddress.Text
    
    rs.Update
    
    MsgBox ("Update successful")
    
    
    cn.Close
    End Sub
    Last edited by Arch_Angel; Aug 6, 2007 at 07:45 PM. Reason: added CODE tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •