参数化查询'(@imageID int，@ imageName varchar(50)，@ image image)插入到im'中需要未提供的参数'@imageID'. [英] The parameterized query '(@imageID int,@imageName varchar(50),@image image)insert into im' expects the parameter '@imageID', which was not supplied.

问题描述

此页面上的错误

Dim result As Integer = cmd.ExecuteNonQuery()

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim strImageName As String = txtname.Text.ToString()

        If FileUpload1.PostedFile IsNot Nothing AndAlso FileUpload1.PostedFile.FileName <> "" Then

            Dim imageSize(FileUpload1.PostedFile.ContentLength - 1) As Byte
            Dim uploadedImage_1 As HttpPostedFile = FileUpload1.PostedFile
            uploadedImage_1.InputStream.Read(imageSize, 0, CInt(FileUpload1.PostedFile.ContentLength))
            Dim con As New SqlConnection("user id=sa;password=siva;Initial Catalog=Travel;server=192.168.90.9")
            Dim cmd As New SqlCommand
            cmd.CommandText = "insert into image(imageID, imageName, Image)values (@imageID ,@imageName,@image)"
            cmd.CommandType = CommandType.Text
            cmd.Connection = con
            Dim Imageid As New SqlParameter("@imageID", SqlDbType.Int)
            cmd.Parameters.Add(Imageid)
            Dim ImageName As New SqlParameter("@imageName", SqlDbType.VarChar, 50)
            ImageName.Value = strImageName.ToString()
            cmd.Parameters.Add(ImageName)

            Dim UploadedImage__2 As New SqlParameter("@image", SqlDbType.Image, imageSize.Length)
            UploadedImage__2.Value = imageSize
            cmd.Parameters.Add(UploadedImage__2)
            con.Open()
            Dim result As Integer = cmd.ExecuteNonQuery()
            con.Close()
            If result > 0 Then
                Label2.Text = "File Uploaded"
            End If
            GridView1.DataBind()
        End If


    End Sub
End Class

这是我的程序.

this is my program

推荐答案

您已将其放入，但未给它一个值.因此，未提供".

You''ve put it in, but you''ve not given it a value. It is therefore ''not supplied''.

这是您用来添加@imageID 参数的内容.

Hi,
Here is what you are using to add @imageID parameter.

Dim Imageid As New SqlParameter("@imageID", SqlDbType.Int)
cmd.Parameters.Add(Imageid)

但是您在哪里增加它的价值呢?
尝试添加值.您的问题将得到解决.


--Amit

But where are you adding the value for it?
Try adding the value. Your problem will be solved.


--Amit

这篇关于参数化查询'(@imageID int，@ imageName varchar(50)，@ image image)插入到im'中需要未提供的参数'@imageID'.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！