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. 

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
 

 I saw lots of post about this issue. but haven't got good solution for that yet. Basically, what I did is that: I have a table in SQL database and some of data fields allow null. I built Objectdatasource through dataset. When I built update page using dataset. It generate the following error before showing the update page correctly. It seems I have issue to retrieve the null value from the database through using objectdatasource through dataset. Any suggestions?

Xinguo

Error attached below:

Line 1178:            get {
Line 1179:                try {
Line 1180:                    return ((string)(this[this.tablemember.CurrentCityStateColumn]));
Line 1181:                
 Operator '=' is not defined for type 'DBNull' and string "REJECTED". 
  
Hi,
I know that the problem is my field having NULL values. However, I don't know how to have it process the code even if the field have nulls
here's my code:
 Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

        If e.Row.RowType = DataControlRowType.DataRow Then
            
            Select Case DataBinder.Eval(e.Row.DataItem, "userStatus")
                Case "REJECTED"
                    e.Row.ForeColor = Drawing.Color.Red
                    e.Row.Font.Bold = True
                Case "ACCEPTED"
                    e.Row.ForeColor = Drawing.Color.Green
                Case Is = vbNullString
                    e.Row.ForeColor = Drawing.Color.Red
                                    
            End Select
            Select Case DataBinder.Eval(e.Row.DataItem, "Status")
                Case "Editing"
                    ' e.Row.Font.Bold = True
                    e.Row.Cells(6).ForeColor = Drawing.Color.DarkOrange
                Case "Active"
                    ' e.Row.Font.Bold = True
                    e.Row.Cells(6).ForeColor = Drawing.Color.DodgerBlue
            End Select
         
        End If
    
    End Sub

 
 override error message (The value 'test' is not valid for Age) when input incorrect data type for in 
  

Hello everyone,
I've tried to override error message when input incorrect data type in input field on HTML form.
For example I have the model like this.

public class Person
{
public string FirstName {get;set;}
public int Age {get;set;}

}

For view, I put text input for Age to get it value.
When type some string in Age text box like 'test' and press submit button. 
I got this error message 
The value 'xxx' is not valid for Age
However, I want to change this message and try many way. There 's nothing effect this message value. 
Please could you help me to solve this problem.

 Conversion Failed when Converting the nvarchar value 'N' to data type int. 
  
Hi..
I am facing a strange situation. when i executing the following query it is returning the error
SELECT  s.row_id as shipment,  
  SUM(CAST(la5.attr_value AS INT)) AS Cases    

FROM  
  shipment s WITH(NOLOCK)  
  INNER JOIN shipping_shift ss WITH(NOLOCK) ON s.shipping_shift = ss.row_id 

  INNER JOIN shift WITH(NOLOCK) ON ss.shift_id = shift.shift_id  
  INNER JOIN shipment_lot sl WITH(NOLOCK) ON s.po_id = sl.po_id AND s.cust_id = sl.cust_id AND 

        s.so_line_no = sl.so_line_no and s.ship_date_local = sl.ship_date_local  

  INNER JOIN lot_attr la5 WITH(NOLOCK) ON sl.lot_no = la5.lot_no AND sl.item_id = la5.item_id AND la5.attr_id = (SELECT attr_id FROM attr WITH(NOLOCK) WHERE attr_desc = 'CaseQty' AND attr_grp = 3) 

WHERE s.spare2 = 'RELEASED'     
  AND shift.shift_desc = 'c'
  AND DAY(ss.production_date) = DAY('2010-08-09 00:00:00.000')  
  AND MONTH(ss.production_date) = MONTH('2010-08-09 00:00:00.000')  
  AND YEAR(ss.production_date) = YEAR('2010-08-09 00:00:00.000') 
GROUP BY s.row_id 
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value 'N' to data type int.
The column  type of attr_value of lot_attr table is a
USER D