Below code gives the error "No value given for one or more required parameters"
strSQL = "insert into FILE_UPLOAD(RefNo, FileName, FileType, FileData, FileDescription, Created, CreatedBy) values " strSQL = strSQL & "(?, ?, ?, ?, ?, ?, ?)" Dim cmd As New OleDbCommand cmd.Connection = objCommon.oConn cmd.CommandText = strSQL cmd.Parameters.Add("@RefNo", OleDbType.VarChar).Value = "" cmd.Parameters.Add("@FileName", OleDbType.VarChar).Value = strFileName cmd.Parameters.Add("@FileType", OleDbType.VarChar).Value = "application/vnd.ms-excel" cmd.Parameters.Add("@FileData", OleDbType.Binary).Value = Filebytes cmd.Parameters.Add("@FileDescription", OleDbType.VarChar).Value = "" cmd.Parameters.Add("@Created", OleDbType.Date).Value = Now cmd.Parameters.Add("@CreatedBy", OleDbType.Integer).Value = Session("UserID")
Table structure is below
CREATE TABLE [dbo].[FILE_UPLOAD]( [RecNo] [int] IDENTITY(1,1) NOT NULL, [FileName] [nvarchar](254) NULL, [FileDescription] [nvarchar](500) NULL, [RefNo] [nvarchar](254) NULL, [RefNoOther] [nvarchar](254) NULL, [FileData] [nvarchar](max) NULL, [CustomerID] [int] NULL, [IPAddress] [nvarchar](254) NULL, [Created] [datetime] NULL, [CreatedBy] [int] NULL, [LastModified] [datetime] NULL, [ModifiedBy] [int] NULL, [FileLocation] [nvarchar](254) NULL, [FileType] [varchar](20) NULL, CONSTRAINT [PKFileUpload_RecNo] PRIMARY KEY CLUSTERED ( [RecNo] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
No value given for one or more required parameters
May 16th, 2015 12:33am