Control: File

 Show all Hide all

File control for posting client-side files.

When used in conjunction with newedit additional control-names are also returned. If file-control ID is @X then parameters @XFileName, @XContentType and @XContentSize are also posted.

CREATE PROCEDURE xxx_InsertUpdate
  ...
  @X varbinary(max),
  @XFileName nvarchar(300),
  @XContentType varchar(300),
  @XContentSize int
AS
...

When the control is set to support upload of multiple files (version 6.1 and later only) the files are returned as a temporary table with the columns FileName, ContentType and File.

Start value: n/a
Return value: Selected file from local/network hard drive.

Control container: NewEdit

Supported in: NewEdit

Best practice

GetEditFields

Use CONVERT(varbinary(MAX), NULL) in GetEditFields instead of returning file data which will be discarded anyway.