adding a data using " VB.NET " and will appear on the database " MS ACCESS 07 "

[Member 785267]

Can you give me a sample registration module ?
Please.
Badly Need It.

'code to insert textbox1 and textbox2 values into sample database
Dim con As New OleDb.OleDbConnection
        Dim cmd As OleDbCommand
        Dim myquery As String
        Dim transaction As OleDbTransaction
        con.ConnectionString = "your connection string"
        con.Open()
        transaction = con.BeginTransaction
        Try
            'query to insert record into Login database table schedules 
            myquery = "INSERT INTO sample VALUES('" & (texbox1.text) & _
                       "','" & (textbox2.Text) & "')"

            cmd = New OleDbCommand(myquery, con, transaction)
            cmd.ExecuteNonQuery()
            transaction.Commit()
         Catch ex As Exception
            transaction.Rollback()
            MsgBox(ex.Message, MsgBoxStyle.Critical, Me.Text)
        End Try
        transaction.Dispose()
        cmd = Nothing
        con.Close()

[Member 785267]

Thanks for the code.
How about a code for Add, Delete, Edit and Update.

"How about a code for Add, Delete, Edit and Update"

Code it or Google it.

[G_Waddell]

hi,

see my reply to your other post....