我在VB.NET所以你可能需要忍耐一下总初学者,但我需要背后编辑此代码,以便空值传递给我的数据库为“IMAGEURL”字段。 前端是一个Web表单,用户可以输入一本书的细节,在上传一本书的封面的选项。
我想改变我的代码,如果该文件上传对话框不履行hasFile,在数据库中生成的将是一个NULL值的GUID字符串(是这样的话,我可以有一个“无可用的图像”使用ASP的NullImageUrl财产图像。)
这是我试过到目前为止实现,但智能感知告诉我,“String类型的值不能转换为‘的System.Guid’。
后面的代码:
Imports System.Data.OleDb Partial Public Class addBook Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Protected Sub btn_submission_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btn_submission.Click Dim noFile As String = Nothing Dim myGUID = Guid.NewGuid() Dim newFileName As String = myGUID.ToString() & ".jpg" Dim fileLocationOnServerHardDisk = Request.MapPath("img/thumb") & "/" & newFileName If fu_picture.HasFile Then fu_picture.SaveAs(fileLocationOnServerHardDisk) Else myGUID = noFile End If Dim oleDbConn As New OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("BookMeetConnString").ConnectionString) Dim SqlString As String = "Insert into booklist(Title,Author,PublicationDate,Pages,Publisher,Blurb,imgurl,AverageRating) Values (@f1,@f2,@f3,@f4,@f5,@f6,@f7,@f8)" Dim cmd As OleDbCommand = New OleDbCommand(SqlString, oleDbConn) cmd.CommandType = CommandType.Text cmd.Parameters.AddWithValue("@f1", tb_booktitle.Text) cmd.Parameters.AddWithValue("@f2", tb_bookauthor.Text) cmd.Parameters.AddWithValue("@f3", tb_bookpubyear.Text) cmd.Parameters.AddWithValue("@f4", tb_bookpages.Text) cmd.Parameters.AddWithValue("@f5", tb_publisher.Text) cmd.Parameters.AddWithValue("@f6", tb_blurb.Text) cmd.Parameters.AddWithValue("@f7", "img/thumb/" & newFileName) cmd.Parameters.AddWithValue("@f8", rbl_Stars.SelectedValue) oleDbConn.Open() cmd.ExecuteNonQuery() System.Threading.Thread.Sleep("2000") Response.Redirect("~/addedrecord.aspx") End Sub Protected Sub rbl_Stars_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles rbl_Stars.SelectedIndexChanged End Sub End Class
请告诉我,如果我在我的思路完全错误的!
编辑:在这个当下,即使文件没有上传,在数据库表中生成一个GUID字符串+ JPG后缀即使图像本身不存在