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

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.