On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Course Of The Month
6 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Oledb command text
Posted on 2013-06-07
Visual Studio 2010 Vb.net
I want to write these values to the database
using this but I am not sure of the sintax
cn = New OleDb.OleDbConnection
cn.ConnectionString = (My.Settings.cnStringAdo1)
command = New OleDb.OleDbCommand
command.Connection = cn
command.Connection.Open()
command.CommandText = ("UPDATE [3320Monitor].MASTERSCHEDU
command.ExecuteNonQuery()
command.Connection.Close()
I want to overwrite the records based on teh TXTCODE.TEXT
The fields I want to update BOXES, CUT, CODE their values come from a TXTBOXES.TEXT and TXTCUT.TEXT and TXTCODE.TeXT
AGAIN is WINDOWS FORMS 2010 VB
I want to write these values to the database
using this but I am not sure of the sintax
cn = New OleDb.OleDbConnection
cn.ConnectionString = (My.Settings.cnStringAdo1)
command = New OleDb.OleDbCommand
command.Connection = cn
command.Connection.Open()
command.CommandText = ("UPDATE [3320Monitor].MASTERSCHEDU
command.ExecuteNonQuery()
command.Connection.Close()
I want to overwrite the records based on teh TXTCODE.TEXT
The fields I want to update BOXES, CUT, CODE their values come from a TXTBOXES.TEXT and TXTCUT.TEXT and TXTCODE.TeXT
AGAIN is WINDOWS FORMS 2010 VB
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
2
9 Comments
Active today
command.CommandText = "UPDATE [3320Monitor].MASTERSCHEDU
..also, if you do
Dim RecordsCount as integer = command.ExecuteNonQuery()
You'll get the number of records affected.
..also, if you do
Dim RecordsCount as integer = command.ExecuteNonQuery()
You'll get the number of records affected.
Error converting data type varchar to numeric BOXES AND CUT ARE numeric on the database I can't change that
Active today
You would be better served if you used parameterized queries.
e.g.
There's no error handling in the above, so if either text box does not contain a valid integer, then you will encounter an exception. You would want to account for this, of course. Also, it's not clear from my example above, but the order that you add the parameters to the command object must be the same as how they appear in the query (for future reference).
e.g.
command.CommandText = ("UPDATE [3320Monitor].MASTERSCHEDULE SET BOXES = ?, CUT = ? where CODE= ?")
command.Parameters.AddWithValue("?", Convert.ToInt32(TXTBOXES.TEXT))
command.Parameters.AddWithValue("?", Convert.ToInt32(TXTCUT.TEXT))
command.Parameters.AddWithValue("?", Convert.ToInt32(TXTCODE.TeXT))
There's no error handling in the above, so if either text box does not contain a valid integer, then you will encounter an exception. You would want to account for this, of course. Also, it's not clear from my example above, but the order that you add the parameters to the command object must be the same as how they appear in the query (for future reference).
Active today
Then you must have non-numeric characters in the textboxes?
You'll need to check for that in code.
You'll need to check for that in code.
Active today
@xuserx2000
No, you need to remove the single quotes you added in the query from around the numeric values ; )
No, you need to remove the single quotes you added in the query from around the numeric values ; )
Featured Post
Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
- Document Management
- Printers and Scanners
- Document Imaging
- Software-Other
- Images and Photos
- Adobe Acrobat, Photos / Graphics Software, Security, OCR, *PDF
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Suggested Courses
Course of the Month6 days, 10 hours left to enroll
724 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.