Error Unable To Cast Object Of Type 'System.Data.SqlTypes.SqlDecimal' To Type 'System.IConvertible'
Jun 6, 2011
I have an InvalidCastException Error in my program. The program is that i try to insert an employee record into a database table after getting the details from a form. I've used Money data type is SQL Server for salary and SqlTypes.SqlDecimal data type in employee template class. i've used a stored procedure to pass the values and i add the basic value by passing a parameter by the method
Dim prm8 As SqlParameter = com.Parameters.Add("@basic", SqlDbType.Money)
prm8.Direction = ParameterDirection.Input
prm8.Value = emp.Bsc
I've used the money datatype itself even in the stored procedure variable.I get the following error.
failed to convert parameter value from sql decimal to decimal
Even if i use
prm8.Value = Convert.ToDecimal(emp.Bsc)
I get an error Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'.
I'm creating a student evaluation form in a repeater that should submit the evaluation responses and update the SQL database, but I keep getting the error mentioned in the title. I'm coding in ASP.Net using VB.
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
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.
I have a series of API calls that are returning J# data types. I have been able to convert most of the data types (Integer, Boolean, Double, Float, etc) just fine.What I need to do now is convert a java.Util.Collection to a VB .NET collection (ArrayList)
Here is my attempt:
Public Function MakeDotNETCollection(ByVal javaCol As java.util.Collection) As Collection Dim dotNetCol As Collection
[code]....
I keep getting a runtime error "Unable to cast object of type 'AbstractListlistIterator' to type 'System.Collections.IEnumerator.
I am using a background worker and am attempting to use the following code. However I keep getting this error on i "Unable to cast object of type 'ObjectCollection' to type 'System.Array'."
Private Sub btnVerify_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnVerify.Click myArray = listProxies.Items() BackgroundWorker1.RunWorkerAsync() End Sub
I am getting a really bizarre error and it makes no sense at all.Basically I have a user entity which has a Password property. This property is of Type Binary, the server data type being Binary(512).I am reading this value in and converting it to a byte array. However whenever I run my code I am getting a completely unrelated error of Unable to cast object of type 'System.Guid' to type 'System.String'.This strikes me as very odd since I am not using a property or variable of type string or GUID anywhere in this procedure where it falls over.
The code is below:
Public Shared Function ValidateUser(ByVal username As String, ByVal password As String) As UserValidationMessage Using db As New EntityMapDataContext Dim u = From user In db.Users Where user.Username = username
Code: Dim dom As New DOMDocument30 dom.async = False dom.Load(serverAddress & "/App/filelist.jsp?type=content") For i = 0 To dom.childNodes.item(1).childNodes.length - 1 downloadfile(dom.childNodes.item(i), mcount, currentpath) Next
The above code is activated upon clicking of a button. i have the server address declared. and using the domdoc to load the jsp file to generate the xml data. and using for loop, i call the download file function which accepts the following parameters
Code:Public Sub downloadfile(ByVal domdoc As Xml.XmlNode, ByVal totalcount As Integer, ByVal currentpath As String)
The totalcount and currentpath work fine, but when i pass in the dom.childNodes.item(i) , error pops up.
--------------------error message------------------------------------------Unable to cast COM object of type 'System.__ComObject' to class type 'System.Xml.XmlNode'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.-------------------------------------------------------------------------------
When testing the followng code from Mastering VB2010, I get an Unable to cast object of type 'System.String' to type 'System.IFormatProvider' exception.In the Button1_Click event code Dim strmOut As New System.IO.StringWriter(SaveFileDialog1.FileName)the 'SaveFileDialog1. FileName' is underlined with a green squiggle and displays the following tool tip:Runtime errors might occur when converting 'String' to'System. Iformat Provider'.This is apparrently the problem but what does it mean and how do I fix it to get the code to work? 'Code being tested that runs the exception:Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click.[code]
I have a bit of trouble right here, I am trying to get the data from the site and input them in the listview. Well, when my main app start to load through on debug, then it start to display a warning. The warning is: Unable to cast object of type 'System.String' to type 'System.IFormatProvider'.
I have been trying to use vb2008 to automatically update CustomDocumentProperties fields that I have set up within a pro-forma document. I can load the Word application and word document without problems.I want to update the CustomDocumentProperties fields with data read from a dB. To do this I am assuming that I need to iterate through the CustomDocumentProperties fields within the word document and when one is "found" that matches the data I wish to merge then assign the dB value to the field.The problem is that I am getting an exception error when I try to reference the document customdocumentproperties
"Error : Unable to cast the COM object of type 'System._ComObject' to interface type 'Microsoft.Office.Interop.Word.CustomProperties'. ...... "
my code looks like;
Dim WordApp As Word._Application Dim odoc As Word._Document Dim BContinue As Boolean = True
I'm getting a sporadic 'Unable to cast object of type 'System.Int32' to type 'System.String' Exceptions at .SingleorDefault() in the below code. It works 9/10 times but randomly it throws an exception. I made sure that SettingID that i'm passing has no Null Values and the data in the table always exists for the settingID, and i'm always passing SettingID as Integer.
Code: Dim sql2 As String = " SELECT * FROM Etiqa_Image_Details where TransmissionID='" & Request("id") & "' " With objDB.OpenDataReader(sql2) While .Read() If .Item("ImageType") = "Invoice" Then imgInv.ImageUrl =
[code]....
However,i get this error while retrieving the image path(Varchar in sql server 2000) and display the image on the web.
Unable to cast object of type 'System.String' to type 'System.Byte[]'.
Actually in my database, i am just storing the image path where the image store...And now when I browsing the web, it should get the image path out and find the image through the image path and then display on the web....
I am getting casting error(Coversion from string "" to type "Integer' is not valid.) and I am not sure how to fix it. The error seems to be occuring in the first line (logU as New loginUser with...) of the code following.
[code]...
The code was working just fine and all of sudden I am getting this error. Note that I get the same error without the "CInt".
same errors or something related to System.windows.forms. Unable to cast object of type 'Public_Information_System_Remake.PIS' to type 'System.Windows.Forms.TextBox'.
