Hi

Im receiving a strange error Error Message: Conversion from string "15/08/2010 22:21:35" to type 'Date' is not valid.

I know this is generally down to cultural date formats etc, however the reason this is strange is it just randomly occured twice in the last week, the website has been running since october and nothing has changed,

The error constantly occured until the IIS was reset and recompilled the site, its been running fine since, however im just trying to figure out what could cause such an error to occur.

I've narrowed it down to a line of code which is:

bktime = DReader.Item("Bktime").ToString

bktime = Year(CDate(bktime)) & "-" & fmt(Month(CDate(bktime)), 2) & "-" & fmt(Day(CDate(bktime)), 2)

Has anyone else encountered this randomly occuring and is there anything i can put in place to prevent this in future?


Cheers


Mike

Hello,

I am having  badly stuck!!I have spent hours in trying to solve that.

I am having the following loving function:

   Public Function InsertDeleteUpdate(ByVal command As String) As Boolean
        Try
            open_connection()
            objectconnection.Open()
            cmd.Connection = objectconnection
            cmd.CommandText = command
            cmd.ExecuteNonQuery()
            objectconnection.Close()
            Return True
        Catch ex As Exception
            Return False
End Try

 In the above function I pass the following string:

gridcost = Convert.ToDecimal(txtcost.Text)
_date = Convert.ToDateTime(txtdatefrom.Text)
patient = Convert.ToInt32(ddlpatients.SelectedValue)

 sqlstring = "execute dbo.InsertDeleteUpdate " & patient & ",'" & _date + "'," & gridcost & ",'" & txtinsurances.Text & "','" & checkreceipt.Checked + "'," & appointment_xid
InsertDeleteUpdate(sqlstring)

The string includes a stored procedure.The store procedure includes the following parameters:

I am getting the below error. Please see my code below and let me know what is wrong.

dim sDatetime as string = startdate & " " &starttime & "AM"

dim dt as Date = CDate(sDatetime)

I am getting the Conversion from string "09/28/10 9.00AM" to type 'Date' is not valid error in this line. 

help i am getting error :

Conversion from type 'DBNull' to type 'String' is not valid

Dim OledbString As String = ("SELECT  Product_Hierarchy,Model,Origin,Item_Code,Description,Price_USD FROM [sheet1$]")
                    'Dim eAdapter As New SqlDataAdapter(sqlString, connection)
                    Dim eAdapter As New OleDbDataAdapter(OledbString, connection)
                    Dim eTable As New DataTable()
                    eAdapter.Fill(eTable)

Dim i As Integer = 0
                    While (i < eTable.Rows.Count)
                        If ((eTable.Rows(i)(0)).ToString().Tri

Hi All,

I have a script component in my Dataflow that generates Error Description string.

But I am not trying to convert anything in my Script as you can see below.

Here is the Code inside the SCR_component.

-----------------------------------------------

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper


Public Class ScriptMain
    Inherits UserComponent
    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
     'Use the incoming error number as a parameter to GetErrorDescription
    Row.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode)
   End Sub
End Class

-------------------------------------------------

When I run the package , it fails at this script task with the following error:

Description: System.InvalidCastException: Conversion from string "C002" to type 'Integer' is not valid.

The value "C002" is actually a column in the metadata and its type is "DT_STR". I am not trying to convert it in my Script as you can see

Hi Guys,

I have the following IF Statement checking if the function GetNexstAddress (which gets the ClientID from  GetClientFleetInfo(i).CLIENTID) . SECONDARYCITY

is there.

If GetNextAddress(GetClientFleetInfo(i).CLIENTID).SECONDARYCITY(0) = Nothing Then
                    NextAddress = " No next Destination"
                Else
                    NextAddress = GetNextAddress(GetxxxxFleetInfo(i).TNO).CITY(0)
                End If

somehow I get the error.

+exception{"Conversion from string "111 AA BB" to type 'Integer' is not valid."}System.Exception

Do you have any idea how to fix this?

PS: I have searched through the forum but not found an answer yet.

 Polynaux