This customization uploads an attachment such as an image or Microsoft Word document. This customization creates a new database record and uploads a file to a database field of type image (Microsoft SQL Server) or OLE Object (Microsoft Access).

NOTE: The database table must have a primary key. If you want to upload an attachment to a database field, you do not need a code customization to do so. On the Page Properties dialog box, set the Display Style of the Field Value control to "File UpLoad" in the Page Properties Dialog box. This code customization provides two additional features: (1) to upload to a new database record and (2) to save the file name in a field.

Step 1:  In Iron Speed Designer, switch to Layout Editor. Select a record panel or table panel.

Step 2:  Select any desired cell, copy the following HTML code into the Cell Editor.

<input type="file" id="inputFile" name="inputFile" runat="server"/>

Step 3:  Drag and drop a Button (Themed) from the Toolbox to a desired cell.

Step 5:  Set the button text and tool tip text properties for the button in Page Properties window.

Step 6:  Go to the Attributes tab in the button's Page Properties and add "PostBack" pass-through attribute with value "True". Add this attribute only if the button is inside a table or record control whose SmoothPanelUpdate pass-through attribute is true.

Step 7:  Build the application.

Step 8:  Use this wizard to add code that handles the OnClick event for the custom button.

Step 9:  Build and run the application.