 |  |  |  |  |  |  |  |
error in insert into statement
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
m using access 2007 and vb 2005
this is my code
this is my code
VB.NET Syntax (Toggle Plain Text)
That much looks correct, I'm assuming the error is in your actual insert statement connected to your adapter. Can you provide that query? Also add the exact error message that you are receiving.
•
•
Join Date: Jun 2009
Posts: 260
Reputation: 
Solved Threads: 50
Posting Whiz in Training
if i have to guess i would say the problem is in this line
drNewRow("Price") = txtPrice.Text.Trim
if the Price is declared as money then you have to convert the txtPrice.text
drNewRow("Price") = Convert.ToDouble(txtPrice.Text.Trim)
but as i said...without any more details its hard to guess.
drNewRow("Price") = txtPrice.Text.Trim
if the Price is declared as money then you have to convert the txtPrice.text
drNewRow("Price") = Convert.ToDouble(txtPrice.Text.Trim)
but as i said...without any more details its hard to guess.
•
•
Join Date: Jun 2009
Posts: 260
Reputation:
Solved Threads: 50
Posting Whiz in Training
then please provide su your Update query. the query you posted is a select query.
why not use ado.net instead?
use commandtext its easier!
use commandtext its easier!
Share your knowledge It's one way to achieve immortality.
My Blog: http://blog.rabihtawil.com
My Programming Community: http://www.coderisland.com
My Blog: http://blog.rabihtawil.com
My Programming Community: http://www.coderisland.com
•
•
•
•
Originally Posted by babbu 
the data adapter handles my update insert and delete query...
If you are referring to the use of a commandbuilder attached to your dataadapter to generate the insert, update & delete statements; I would like to see the block of coding that creates this and fills your dataadapter so that I may see where it is causing you problems.
Also does the table have a primary key/unique field, the command builder needs this in order to be able to perform these statements.
|
Similar Threads
- Insert Error:Syntax error in INSERT INTO statement (C#)
- Syntax error in INSERT INTO statement, please help (ASP)
- Syntax error in INSERT INTO statement (Java)
- Problems on Insert and Update Statement (C#)
- insert statement error (MySQL)
- SQL Server 2005 version Error Insert command help me (MySQL)
Other Threads in the VB.NET Forum
- Previous Thread: Small Probs
- Next Thread: Storing Data in Excel Worksheet Invisible to the User
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
"crystal .net .net2005 30minutes 2005 2008 access account arithmetic array arrays basic binary bing button buttons c# center check code combobox component connectionstring convert crystalreport data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dropdownlist excel file-dialog folder ftp google hardcopy image images inline insert listview login math memory mobile ms navigate net networking opacity output passingparameters peertopeervideostreaming picturebox picturebox1 plugin port print printing problemwithinstallation project reports" save savedialog searchbox serial server soap sql string table tcp text textbox timer toolbox trim update updown upload usercontrol vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio web wpf
