I have a program that calculates commission, but if the commission is nothing then I do not want it to show a zero commission. I want a message box to show a message that there is no commission earned.
View 1 RepliesI need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesI'm trying to add data into a datagridview cell but I keep on getting a data type error.[code]Value of type 'Char' cannot be converted to 'System. Windows.Forms.DataGridViewCell'.[quote]
View 2 RepliesI'm trying to delete the 2 last characters of a string if they are "||". This is my
Dim MyReader As Microsoft.VisualBasic.FileIO.TextFieldParser
MyReader = My.Computer.FileSystem.OpenTextFieldParser(playlist)
Dim TextFields As String() = MyReader.ReadFields()
Dim last As String = TextFields.Last
If last.Substring(last - 2) = "||" Then
last.Remove(last - 2)
End If
But it gave me the following error on the highlighted line:
"The converting from the string to the type Double is not valid."
For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
I am using two textBox's. The first to enter the data. The second to convert to answer the program complies with no error, the debugger cannot convert data type from string to double.
[Code]....
why does the program not convert the textbox txtFahrenheit from string to double?
When i use VB6 i get the following outputs
961.605 * 100 = 96161
936.495 * 100 = 93650
929.295 * 100 = 92929
NOW..... When i do the above in vb.net 2005 i get the following
961.605 * 100 = 96160
936.495 * 100 = 93650
929.295 * 100 = 92930
How can i get the same output as the VB results. And i have tired it ! Type conversions, math functions, everything i can think of to get the same VB6 output !
Here is an issue that i am facing - VB6
[Code]....
The value of d3 is not coming to 301006308001004.5 but it is getting rounded off. Is there a way to fix this. When I use currency data type, the issue looks solved. However currency cannot hold a larger decimal number. the value of d2 can have more decimal value like 0.343324532553 .
integer 51 is the result of Math.Round(mX ) where mX = 50.8026755852843how do I ensure that an integer value is created but doesn't round up but rather rounds down.the application is a location coordinate system begin displayed and if the mouse pointer hovers over a point just slightly to the right of the vertical x grid line as determined by a MouseEventArg, I want the resultant integer value to be 50 if the Mouse
View 5 RepliesI'm using the Double data type in a subroutine and it's giving inaccurate results. Basically I've got:
Dim Temp as Double
Dim A,B as Single
Dim C as Byte
Temp=A*B/C
When A=996 B=4 and C=1.6 Temp should be 2490 but that's not the case. I get something like 2489.9999628961091. This later screws up another calculation that's based on getting the value and remainder.Whatever the case I set the Temp variable to Single and it works. What I want to know is WHY does this happen? I'm a bit confused.
How do you validate input when you are dealing with doubles. I have successfully gotten the message box to pop up when the user enters a number in a text field, but what if I have a text box that requests a number from the user and they enter text? This is the code, the even for btnDisplayFull works fine, but not btnDisplayRqst: [code]
View 2 RepliesI'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
When i use VB6 i get the following outputs
[Code]...
Ok, I'm half convinced that this is such a simple question that no one has ever needed to ask it in the history of google.I have a double datatype, which contains a currency value. This is returned by an API, so I can't just change it to decimal.The variable gets populated with this: 5.37979542325911E-315, which I took to mean that the current balance was $5.3797. This is incorrect!
So my question to you guys is: How do I convert a double to a data type I can use for currency?
Note: Cdec() and other casting to decimals hasn't workd. It's set the decimal to 0D.
I am getting this error when I am tring to load string type to data table)
Using connection As New SqlConnection("connectionstring;")
connection.Open()
Using Command As New SqlCommand("SELECT ClientId,forename,surname from t_clientdetails
[code].....
I get the below error Unable to cast object of type 'System.String' to type 'System.Data.DataTable'.This is the code I'm using
Dim str As String = String.Empty
If (Session("Brief") IsNot Nothing) Then
Dim dt As DataTable = Session("Brief")
If (dt.Rows.Count > 0) Then
[code]....
I don't know how to convert the nvarchar value into an int, but that is the way it needs to be set up. I've found other posts about this but I don't know how to use CAST in the INSERT statement I have. All the posts I could find were about converting to int in SELECT statements. I need this statement to change the field @Duration to an int in the database. @Duration is an amount of time. (01:00, 02:00...) They will all get rounded up to the next int value. So if a user enters 0:45, it should be converted to 1. how to get this INSERT to work?
'SQL Insert: Product table
Dim sqlInsertProduct As String = "INSERT INTO Product (ProductName, Status,
CreateDate, ModifyDate, CreateUser,
[Code]....
Error converting data type varchar to datetime.rtfI am trying to learn ASP.NET using ASP.NET 1.1 with SQL Server 2000 for the database. I have created a Stored Procedure in SQL Server 2000 and the procedure to execute the Stored Procedure is in ASP.NET 1.1. The problem is that when I try to save a record, the date field returns the above error. I have ried to use the several solutions on the web without getting one to solve the problem.I am attaching the Stored Procedure as well as the ASP.NET code for some advice. I am also attached a word document containing the two procedures.
View 5 RepliesWhen I try to close my form it gives me the following error; Error converting data type varchar to numeric. I have only one field which is numeric - ProjectID, and when I close this form sometimes this txtProjectID is empty and this calls the error. But if there is a number in the txtProjectID it closes fine.
View 3 RepliesI am getting the error Error converting data type varchar to numeri when trying to save some of the information that is entered in a textbox to my sql server 2005 database. HEre is the code for my insert statement.
'declare your variables
Dim FirstName, LastName, Comments, MRN
Dim sConnString, connection, sSQL [code]......
Using Vb.net/SQL Server 2000 updating a row via a gridview/sqldatasource
Stored proc:
@ISTag varchar(10),
@PCISTag varchar(10),
[Code]......
I don't understand where else it could be screwing up. I'd love to be able to keep it to a null value if it is one already, I'm just trying to get it to take anything right now and this is where I'm at.
There was a syntax error while converting from one data type to another. [ Expression = -1 ].
This part of the code where the issue starts is here: Do While JVReader.Read()
Here is the
CODE:
I have a DateTime Picker that I have set Format to "Custom" and CustomFormat to "dd/MM/yyyy HH:mm"
When the user changes the date time it all works fine and update the table no problem.
If the user does not change the date time I get the error[code]...
I am trying to create stored procedure that gone return varchar value, and that value I need to display in textbox.This is the code for stored procedure:
Create PROCEDURE Status @id_doc int, @Name varchar(50) OUTPUT
AS
select @Name =items.name
from Doc,Items where @id_doc=IDN and doc.IDN=Items.ID
return @Name
This is the code in vb.net where i need to display returned value from procedure in textbox:
Public Sub Current()
Dim dtc As New Data.DataTable
Dim dr As SqlClient.SqlDataReader
[code]....
When I try to execute this code I get this message in exception:
"Conversion failed when converting the varchar value 'Blue color' to data type int."
My colleague gave me a DLL that manage all database business. I wanted to invoke a function that uses Stored Procedure and return the search result. In the function receive a parameter type in ystem.Data.IDataParameter[]. Below is my codes.
[Code]...
I created an application in vb.net 2005. It works fine on my machine. I tested several different test machines and all were working fine. As for the client, it's generating an error. My application reads from an excel sheet and imports the values to an oracle database. the error being generated is: "conversion from type string to type double is not valid". Why is it generating only on the client's computer and not mine?
View 13 RepliesI have a sql select statement with something like:
select...
where column in (@Parameter)
In VB code a set parameter.defaultvalue to "65555,67803", But i get an error "Conversion failed when converting the nvarchar value '65555,67803' to data type int."
I have a function (on vb.net) to get a data from a XMLWebService:
[Code]...
I added this lines in the form load of DataGridPrinter by Merrion in the codebank..[code]Unable to cast object of type 'System.Data.DataViewManager' to type 'System.Data.DataTable'.
View 2 Repliesevery time i run this code i get the same error
Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.DataView'.
the code is
Dim plmExcelCon As New System.Data.OleDb.OleDbConnection
Dim cmdLoadExcel As System.Data.OleDb.OleDbDataAdapter
Dim PrmPathExcelFile As String
[Code]......