I am trying to learn Visual Basic and started with a small inventory project. I gather information from a form where the user will enter information, and then I try to update a MS ACCESS database. When I stop the program while debugging, it seems like all the data is captured, but never written to the database. Also in the DataSet.xsd, I am getting over 100 warning messages. One is ProviderType attribute is not declared, and another is AllowDbNull attribute is not declared.
The Imports entries I have in my program which may be causing this problem are:
Imports System.Collections.ObjectModel
Imports System.Data.OleDb
Imports Microsoft.VisualBasic.FileIO
I checked every Tutorial I could find, and it looks real easy, but when I try it, I can not get it to work. Also, should I use SQL rather than Access
Help please.
Frustrated VB-Newbie
Updating a MS ACCESS Database from VB Express Edition
SAMSQL2005
I agree with Cgraus and I just wanted to expand upon this.
LEARN Fundamental DATATYPES
Bits, bytes, shorts, integers signed and unsigned.
Laurent4x
>> I am trying to learn Visual Basic and started with a small inventory project
My core advice to anyone who says something like that is, learn your language before you learn the libraries. In other words, learn VB first, then worry about winforms, and only then worry about databases.
>> Also, should I use SQL rather than Access
Do you mean SQL Server All databases use SQL, it's the language of databases.