2
Answers

Updating database access?

Hi, i got a problem here. please someone help me. this would mean a lot. :''(


i have a windows form application in visual basic 2010. This program gets data from user and add it to the database.
my problem is how to update the database particularly the this "personal information" table and save it permanently.


all the codes i have searched always give me errors. this is my final project and im not even a programmer, this is only a minor subject. we've only studied this course for about 3months, once a week, 5hrs per meetings.
please help me :(


heres my personal informations's form interface


http://oi41.tinypic.com/20f3p0p.jpg




heres my code so far:


=================================================================
Imports System.Data.OleDb


Public Class frm_personalInfo
    Private Sub frm_applicantForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


    End Sub


    Private Sub cb_applyingFor_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)


    End Sub


    Private Sub Personal_InformationBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
        Me.Validate()
        Me.Personal_InformationBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.MIT_Resume_DatabankDataSet)


    End Sub


    Private Sub tb_sss_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)


    End Sub


    Private Sub BindingNavigatorAddNewItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)


    End Sub


    Private Sub lbl_educBG_next_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lbl_educBG_next.Click
       
       
    End Sub


    Private Sub Contact_NumberTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Contact_NumberTextBox.KeyPress
        If (e.KeyChar < "0" OrElse e.KeyChar > "9") AndAlso
            e.KeyChar <> ControlChars.Back Then
            e.Handled = True
        End If
    End Sub


    Private Sub BirthdateTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles BirthdateTextBox.KeyPress
        If (e.KeyChar < "0" OrElse e.KeyChar > "9") AndAlso
            e.KeyChar <> ControlChars.Back Then
            e.Handled = True
        End If
    End Sub


    Private Sub Present_AddressTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Present_AddressTextBox.TextChanged


    End Sub
End Class


========================================================================

UPDATE:
this would be kinda embarrassing,  but here's my code now. this is partially done but i cant seem to make the database update and display work. please help me. gotta submit this by tom :'(

http://www.mediafire.com/?1a0z0bb52k3cl4m


*note: if youre so good and you downloaded it, i apologize in advance coz its kind of unorganized >_<





Answers (2)