I have created a basic form with two fields. The first field is a text filed and the second is a field to upload a file.
If I just populate the first field it will create a row in SQL.
If try to populate both fields a row in SQL does not get created. However I do see the file get uploaded to the web server.
Can anyone help me understand why I am not getting a row in sql but I see the file get uploaded? Below are my tags for the form.
Thanks,
Ryan
<AddForm>
<ScriptBlock BlockType="HeadScript" RegisterOnce="True" ScriptId="KBXM_Style_axa_report_dev">
<style type="text/css">
.xmp-axa_report_dev { padding: 10px 5px 5px 5px; }
.xmp-axa_report_dev .xmp-form-row { margin: 3px;, padding: 3px; clear:left;}
.xmp-axa_report_dev label.xmp-form-label, .xmp-axa_report_dev span.xmp-form-label{ display:block; float:left; width: 120px;text-align: left; margin-right: 5px; }
.xmp-axa_report_dev .xmp-button { margin-right: 5px; }
.xmp-axa_report_dev label.xmp-form-label, .xmp-axa_report_dev span.xmp-form-label{ display:block; float:left; width: 120px;text-align: left; margin-right: 5px; }
</style>
</ScriptBlock>
<SubmitCommand CommandText="INSERT INTO [axa_reports] ([type], [ReportFile]) VALUES(@type, @ReportFile) " /><div class="xmp-form xmp-axa_report_dev">
<div class="xmp-form-row"><Label CssClass="xmp-form-label NormalBold" For="type">Type</Label><TextBox Id="type" Width="70" MaxLength="10" DataField="type"></TextBox></div>
<div class="xmp-form-row"><Label CssClass="xmp-form-label NormalBold" For="fileReportId">FileUpload</Label><FileUpload Id="fileReportId" DataField="ReportFile" DisplayMode="FilePicker" Path="~/_FileUpload" UseUniqueFileName="True"></FileUpload></div><ValidationSummary CssClass="NormalRed xmp-validation" Id="vsaxa_reports"></ValidationSummary><div class="xmp-form-row"><Label class="xmp-form-label NormalBold"> </Label><AddButton Text="Add"></AddButton><CancelButton Text="Cancel" style="margin-left: 12px;" Visible="true"></CancelButton></div>
</div></AddForm>