Click here to Skip to main content
15,905,867 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionSilent install? Pin
charleslau285528-Dec-04 15:54
charleslau285528-Dec-04 15:54 
QuestionHow to write and display chemical formula or mathematical formula in VB.NET Pin
bangzozo28-Dec-04 15:32
bangzozo28-Dec-04 15:32 
GeneralSQL Statement in vb.net Pin
Mekong River28-Dec-04 13:33
Mekong River28-Dec-04 13:33 
GeneralRe: SQL Statement in vb.net Pin
Mekong River28-Dec-04 14:53
Mekong River28-Dec-04 14:53 
QuestionHow to select a RadioButton? Pin
Matrix100028-Dec-04 13:29
Matrix100028-Dec-04 13:29 
GeneralDisappointed with Graphics Speed Pin
nagajim28-Dec-04 12:05
nagajim28-Dec-04 12:05 
GeneralRe: Disappointed with Graphics Speed Pin
Robert Rohde29-Dec-04 1:26
Robert Rohde29-Dec-04 1:26 
GeneralVB.NET & ADO - Update & Insert Problems Pin
tinomclaren28-Dec-04 12:01
tinomclaren28-Dec-04 12:01 
Hello

I suspect that this is a simple error on my part but this example may help others starting out with ADO.NET.

I'm working on a very basic Database Application. I've included the full project as an attachment in this post.

Its a very basic Form that is the front end for a database containing contact information.

The form has many fields but I've only implemented the first 4 for simplicity.

The form has 4 buttons

1-Find = user enters record ID to bring up the contact information for that record (SQL Select used)
2-New = user can create a new record (SQL Insert used)
3-Save = user saves current record (updated or new- SQL Update or insert used)
4-Delete = Record deleted

I have used an access DB for simplicity but will need to use MySql or MS SQL for end project. Amen.mdb is included with project.

Parts That Work

1-Find Works OK
2-New Works OK until Save

Parts that Don't work

3 - Save - Insert only inserts the first 2 fields in the database! ie name & contact, phone & mobile don't get inserted! -
I don't understand this as the code seems OK
Update doesn't work at all - it causes an unhandled exception in the cmdUpdate part of my code.


The project was written in VS.NET 2003

Any Help greatly appreciated


Tino


--------------------------------------------------------------------------------


zipped up project
www.itsthere2share.com/Amen2.zip
GeneralRe: VB.NET & ADO - Update & Insert Problems Pin
Mekong River28-Dec-04 13:46
Mekong River28-Dec-04 13:46 
GeneralZip and Unzip from VB.Net Pin
CharlotteF28-Dec-04 6:19
CharlotteF28-Dec-04 6:19 
GeneralRe: Zip and Unzip from VB.Net Pin
Robert Rohde29-Dec-04 1:32
Robert Rohde29-Dec-04 1:32 
GeneralRe: Zip and Unzip from VB.Net Pin
Dennis C. Dietrich29-Dec-04 9:35
Dennis C. Dietrich29-Dec-04 9:35 
QuestionHow to Call Visual C++ .NET from Visual Basic .NET Pin
Member 161742528-Dec-04 6:05
Member 161742528-Dec-04 6:05 
AnswerRe: How to Call Visual C++ .NET from Visual Basic .NET Pin
Colin Angus Mackay28-Dec-04 13:59
Colin Angus Mackay28-Dec-04 13:59 
GeneralMDI non-child forms Pin
GeneralDisorder28-Dec-04 5:28
GeneralDisorder28-Dec-04 5:28 
Generalvolume and pitch Pin
azam31628-Dec-04 1:47
azam31628-Dec-04 1:47 
GeneralMake graphik with data shape Pin
widhie_prihatna28-Dec-04 1:44
widhie_prihatna28-Dec-04 1:44 
Generaltouch screen (point-of-sales) user interface Pin
StenH28-Dec-04 1:00
StenH28-Dec-04 1:00 
Generalinserting images to imagelist Pin
SelvaRavi28-Dec-04 0:34
SelvaRavi28-Dec-04 0:34 
GeneralImport text files Pin
G-Viking27-Dec-04 23:36
G-Viking27-Dec-04 23:36 
GeneralPopulating Listview with DB information Pin
kobezt0827-Dec-04 18:36
kobezt0827-Dec-04 18:36 
GeneralRe: Populating Listview with DB information Pin
Mekong River27-Dec-04 20:24
Mekong River27-Dec-04 20:24 
General[VB.NET] Paint MainMenu Pin
thesleeper27-Dec-04 15:40
thesleeper27-Dec-04 15:40 
GeneralRe: [VB.NET] Paint MainMenu Pin
David M J29-Dec-04 12:18
David M J29-Dec-04 12:18 
GeneralRe: [VB.NET] Paint MainMenu Pin
thesleeper29-Dec-04 13:09
thesleeper29-Dec-04 13:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.