It is using command builder to to that.
Dim objCommandBuilder As New OleDbCommandBuilder(objDataAdapter)
I have a hunch as I have read hours on the net using google to find this
that it might be about reserved Keywords. There is a field named Password
and a Field named Connect in the table row. I am building a insert string
and using [ and ] around those fields. I guess the command builder doesn't
do that on it's own. Here is the string how does it look?
'Build SQL String --------------------------------------
Dim strSQLstring As String
'strSQLstring = "SELECT * FROM tblBTC"
strSQLstring = "INSERT INTO tblBTC ([Name], [Playingname], [Password],
[Location], [Email], [Age], [icq], [aim], [Occupation], [bio],
[PersonalInformation], [GamesPlayed], [Connect], [Processor], [Ram],
[VideoCard], [SoundCard], [HardDrive], [AdditionalSystemInformation],
[Photo], [UserName], [DateJoined], [OS], [SystemPhoto])VALUES('" & strName &
"','" & strPlayingname & "','" & strPassword & "','" & strLocation & "','" &
strEmail & "','" & strAge & "','" & strIcq & "','" & strAim & "','" &
strOccupation & "','" & strBio & "','" & strPersonalInformation & "','" &
strGamesPlayed & "','" & strConnect & "','" & strProcessor & "','" & strRam
& "','" & strVideocard & "','" & strSoundcard & "','" & strHarddrive & "','"
& strAdditionalsysteminformation & "','" & strPhoto & "','" & strUserName &
"','" & strDateJoined & "','" & strOS & "','" & strSystemPhoto & "')"
'-------------------------------------------------------
Have a nice day.
----- Original Message -----
From: "Dean Fiala" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, January 12, 2005 8:57 PM
Subject: Re: [AspNetAnyQuestionIsOk] Form wil not submit. amazing
>
> Let's see the insert statement...
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
