0

I have been using examples from the textbook creating a OleDbDataAdapter using the wizard, everything works fine loading the data into the dataset, but when i try to update the dataset, it doesn't save tod the database, can someone please tell me what im doing wrong: I created the data adapter and dataset using the wizard, I binded all applicable textboxes. I do not get any errors the update command just doesn't save to the Access Database.

This is my code

Imports System
Imports System.IO
Imports System.Data
Imports System.Data.OleDb

Public Class Form1
    Inherits System.Windows.Forms.Form

Private Sub Label3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label3.Click

    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        OleDbDataAdapter1.Fill(DataSet11)

    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        OleDbDataAdapter1.Update(DataSet11)
    End Sub
End Class
2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by dakaboguy
0

Well i created the app.config file but how exactly do i change that value.
the app.config file contains

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<appSettings>

	</appSettings>
</configuration>
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.