locked
Conversion from string "" to type 'Date' is not valid. RRS feed

  • Question

  • User810354248 posted

    In my asp.net+VB=SQL DB i am using this code to upload images to DB.

     Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As EventArgs)
            ' Read the file and convert it to Byte Array 
            Dim filePath As String = FileUpload1.PostedFile.FileName
            Dim filename As String = Path.GetFileName(filePath)
            Dim ext As String = Path.GetExtension(filename)
            Dim contenttype As String = String.Empty
            Dim PID As String = pidtxt.Text
            Dim users As String = usertxt.Text
            Dim updated As DateTime = dttxt.Text
            'Set the contenttype based on File Extension
            Select Case ext
                Case ".doc"
                    contenttype = "application/vnd.ms-word"
                    Exit Select
                Case ".docx"
                    contenttype = "application/vnd.ms-word"
                    Exit Select
                Case ".xls"
                    contenttype = "application/vnd.ms-excel"
                    Exit Select
                Case ".xlsx"
                    contenttype = "application/vnd.ms-excel"
                    Exit Select
                Case ".jpg"
                    contenttype = "image/jpg"
                    Exit Select
                Case ".png"
                    contenttype = "image/png"
                    Exit Select
                Case ".gif"
                    contenttype = "image/gif"
                    Exit Select
                Case ".pdf"
                    contenttype = "application/pdf"
                    Exit Select
            End Select
            If contenttype <> String.Empty Then
                Dim fs As Stream = FileUpload1.PostedFile.InputStream
                Dim br As New BinaryReader(fs)
                Dim bytes As Byte() = br.ReadBytes(fs.Length)
    
                'insert the file into database 
                Dim strQuery As String = "insert into tblFiles" _
                & "(Name, ContentType, Data,PID)" _
                & " values (@Name, @ContentType, @Data,@PID)"
                Dim cmd As New SqlCommand(strQuery)
                cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = filename
                cmd.Parameters.Add("@ContentType", SqlDbType.VarChar).Value _
                = contenttype
                cmd.Parameters.Add("@Data", SqlDbType.Binary).Value = bytes
                cmd.Parameters.Add("@PID", SqlDbType.VarChar).Value = PID
                cmd.Parameters.Add("@Users", SqlDbType.VarChar).Value = users
                cmd.Parameters.Add("@Updated", SqlDbType.DateTime).Value = updated
    
                InsertUpdateData(cmd)
                lblMessage.ForeColor = System.Drawing.Color.Green
                lblMessage.Text = "File Uploaded Successfully"
            Else
                lblMessage.ForeColor = System.Drawing.Color.Red
                lblMessage.Text = "File format not recognised." _
                & " Upload Image/Word/PDF/Excel formats"
            End If
            gridview.DataBind()
            DataList1.DataBind()
        End Sub

    It was working fine. Now i added a date field name updated. then the error comes as under

    Conversion from string "" to type 'Date' is not valid.

    Saturday, November 25, 2017 6:34 AM

Answers

  • User810354248 posted

    Sorry

    That was my mistake.

    the date code was empty. Now rectified. Thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, November 25, 2017 6:43 AM