从sql server数据库插入和显示图像在vb.net

Question

我需要上传和显示图像数据库。我已经写了这个代码上传，它上传的罚款。除了1个问题。它崩溃时，我不选择一个图像。有人可以帮我解决它的空值？你怎么在IE中显示图像？用于插入图像

代码 -

Dim imageInfo As FileInfo = Nothing 
Dim data() As Byte = Nothing 
imageInfo = New FileInfo(Me.UploadLogo.Value.Trim()) 
Dim imagestream As FileStream = New FileStream(imageInfo.ToString, FileMode.Open) 

if name_id > 0 
    ReDim data(imagestream.Length - 1) 
    imagestream.Read(data, 0, imagestream.Length) 
    imagestream.Close() 
    Sqlstr = "UPDATE logos WITH(ROWLOCK) " & _ 
      "SET [email protected],Modified_Date=GETDATE() " & _ 
      "WHERE ID = " + name_id.ToString + "" 
Else 
    Sqlstr = "INSERT logos (Logo,Created_Date) " & _ 
      "VALUES ("@Logo,GETDATE())" 
End If 

SqlCmd = New SqlCommand(Sqlstr, SqlCnn) 
Dim pictureParameter As SqlParameter = Nothing 
pictureParameter = New SqlParameter("@Logo", SqlDbType.Image) 
pictureParameter.Value = data 
SqlCmd.Parameters.Add(pictureParameter) 
SqlCmd.ExecuteScalar() 

这只有当一个图像被选择细，为崩溃NULL值。 也请帮助我与图像显示。感谢

Answer 1

为了解决你的“文件不选择的问题”，你应该有沿线的If语句：

If Not File.Exists(Me.UploadLogo.Value.Trim()) 
    ' Exit out or handle no file selected 
End If