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'.
View 3 Replies
ADVERTISEMENT
May 2, 2012
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.
Here's my code:
Student.aspx
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
[Code].....
View 1 Replies
Jun 5, 2010
i get the error in following code
Function ReadFile(ByVal sPath As String) As Byte
Dim data As Byte
data = Nothing
[Code].....
View 2 Replies
Jan 29, 2012
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].....
View 1 Replies
Oct 4, 2009
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]....
View 3 Replies
May 16, 2011
[URL]The issue is as soon as I change the value of the text boxes it gives me an error and forces me to close the project.
The error is:Unable to cast object of type 'System.EventArgs' to type 'System.Windows.Forms.KeyPressEventArgs'.
However I'm supposed to clear the number of gallons used and the total charged when a change is made to the contents of the 2 text boxes on the form.
View 3 Replies
Feb 9, 2012
Private
Sub cmdExit_Click(ByVal
sender As System.Object,
ByVal e
[code]....
View 3 Replies
Aug 9, 2009
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]...
View 5 Replies
Apr 25, 2012
I have a function (on vb.net) to get a data from a XMLWebService:
[Code]...
View 2 Replies
Dec 31, 2009
every 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]......
View 2 Replies
Dec 22, 2010
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.
View 1 Replies
Feb 24, 2012
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
[code]....
View 2 Replies
May 14, 2012
I'm getting an error after sending a list to a web service.This is the code that is calling the web service:
Dim sProgramInterest As New List(Of Integer)
crmService.InsertProspectGetId(sProgramInterest.ToList)
But I'm getting this error.
[code].....
View 3 Replies
Jun 25, 2010
My project worked a first and now its giving me a problem.The error
Quote:
Unable to cast object of type 'System.Windows.Forms.MouseEventArgs' to type 'System.ComponentModel.RunWorkerCompletedEventArgs'.
View 2 Replies
Dec 24, 2009
Now I want to display picture in picturebox1.To do this I use this codes, but it does not display picture
on this line: Dim arrPicture() As Byte = CType(dt2.Rows(0)("img_path"), Byte())
it shows this message,
Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.[code]......
View 1 Replies
Jun 12, 2011
Unable to cast object of type 'System.String' to type 'System.Windows.Forms.TextBox'.
View 12 Replies
Nov 15, 2011
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]....
View 3 Replies
Jul 30, 2009
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.-------------------------------------------------------------------------------
[code]....
View 1 Replies
Aug 7, 2011
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]
View 12 Replies
Jun 6, 2011
I have a page that get value from SQL. I'm having a problem when I initialize Label object with field having TEXT data type.[code]...
View 4 Replies
Oct 20, 2010
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'.
[Code]...
View 7 Replies
May 10, 2009
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
[code].....
View 2 Replies
Jun 27, 2011
VB 2008, DataGridView,DataGridView1_CellLeave(sender, New System.EventArgs)
"Unable to cast object of type 'System.EventArgs' to type 'System.Windows.Forms.DataGridViewCellEventArgs'."
What is the Correct String for "New System.EventsArgs"
Anybody there is to help me out.
View 1 Replies
Mar 20, 2012
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]...
View 4 Replies
Jun 6, 2012
[Code]...
Unable to cast object of type 'System.Net.FileWebRequest' to type 'System.Net.FtpWebRequest'.
View 6 Replies
Apr 11, 2012
iNCEEB = .First.NCEEB '<-- Im getting the error in this line, iNCEEB is integer .First.NCEEB is short.
NCEEB Server Datatype property is smallint
where is that "to type 'System.String'." coming from?
I'm using vs2008 and mssql2008.
[Code]...
View 8 Replies
Nov 25, 2009
I has the following code in my vb.net:
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....
View 2 Replies
Mar 25, 2012
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".
View 9 Replies
Jan 25, 2011
For I = 0 To 10
If Items.Count = 0 Then Exit For
Dim T As New Thread(AddressOf Thread)
T.Start(New Object() {"Test", "Test"})
[code]....
When I put same code in empty project it works.
View 5 Replies
Mar 31, 2011
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'.
[Code]...
View 5 Replies
