Solved

Insert label.text into sql money column

Posted on 2010-09-17
5
596 Views
Last Modified: 2012-05-10
Hello,
I am using VB inserting data into a sql server table. one of the values is in a label, but needs to go into a "money" column.

I'm using the following parameter to convert it but it is not working. Any ideas?

error says,  input string not in correct format

 Cmd2.Parameters.Add(New SqlParameter("Amount", Convert.ToDouble(Label2.Text)))
0
Comment
Question by:mlg101
  • 3
  • 2
5 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 33706798
Have u tried CDbl?

 Cmd2.Parameters.Add(New SqlParameter("Amount", CDbl(Label2.Text)))
0
 
LVL 1

Author Comment

by:mlg101
ID: 33706831
i get the same error with that..
0
 
LVL 1

Author Comment

by:mlg101
ID: 33706839
I found out I had no value to the label, so that is why it didnt work, but your way worked when it had value. thanks.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33706843
hmmm, what about cdec then, convert to decimal

 Cmd2.Parameters.Add(New SqlParameter("Amount", CDec(Label2.Text)))

or format as currency

 Cmd2.Parameters.Add(New SqlParameter("Amount", Format(Label2.Text, "Currency")))

0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33706844
fyi for your other conversions you may want to do


CBool - use this function to convert to Bool data type
CByte - use this function to convert to Byte data type
CChar - use this function to convert to Char data type
CDate - use this function to convert to Date type
CDbl - use this function to convert to Double data type
CDec - use this function to convert to Decimal data type
CInt - use this function to convert to Integer data type
CLng - use this function to convert to Long data type
CObj - use this function to convert to Object type
CShort - use this function to convert to Short data type
CSng - use this function to convert to Single data type
CString - use this function to convert to String data type
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now