Are you interested in becoming an AWS Certified Solutions Architect?
Discover a new interactive way of training for the exam.
COURSE of the MONTH
13 days, 23 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
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
IP addresses can be stored in a database in any of several ways. These ways may vary based on the volume of the data. I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.
…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month13 days, 23 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.