No value given for one or more required parameters
 

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]


May 16th, 2015 12:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics