Menu
First and foremost, I am NOT using an UpdatePanel -- it looks like that's a common issue, but I didn't even know what one was before I googled this issue.
I have a DetailsView attempting to upload a file and insert the filename into the database. Problem is, HasFile is always turning up false! Any idea what I've done wrong?
C#:
public partial class DocManager : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!(System.Convert.ToBoolean(Session["Admin"])))
Response.Redirect("Index.aspx");
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
FileUpload fu1 = (FileUpload) DetailsView1.FindControl("FileUpload1");
if (fu1 == null)
{
e.Cancel = true;
StatusLabel.Text = "Could not find file upload";
}
if (fu1.HasFile)
{
try
{
string filename = Path.GetFileName(fu1.FileName);
fu1.SaveAs(Server.MapPath("~/Docs/") + filename);
StatusLabel.Text = "Upload status: File uploaded!";
e.Values["FileName"] = filename;
}
catch (Exception ex)
{
StatusLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
else
{
e.Cancel = true;
StatusLabel.Text = "No file uploaded";
return;
}
DropDownList dd1 = (DropDownList)DetailsView1.FindControl("DropDownList2");
DropDownList dd2 = (DropDownList)DetailsView1.FindControl("DropDownList4");
e.Values["Type"] = dd1.SelectedValue;
e.Values["MeetingID"] = dd2.SelectedValue;
}
protected void DetailsView1_ItemEditing(object sender, DetailsViewInsertEventArgs e)
{
FileUpload fu1 = (FileUpload)DetailsView1.FindControl("FileUpload2");
if (fu1 == null)
e.Cancel = true;
if (fu1.HasFile) {
try
{
string filename = Path.GetFileName(fu1.FileName);
fu1.SaveAs(Server.MapPath("~/Docs/") + filename);
StatusLabel.Text = "Upload status: File uploaded!";
e.Values["FileName"] = filename;
}
catch (Exception ex)
{
StatusLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
else
e.Cancel = true;
DropDownList dd1 = (DropDownList)DetailsView1.FindControl("DropDownList1");
DropDownList dd2 = (DropDownList)DetailsView1.FindControl("DropDownList3");
e.Values["Type"] = dd1.SelectedValue;
e.Values["MeetingID"] = dd2.SelectedValue;
}
}
The only thing in PageLoad is a check to be sure the user is logged in properly, nothing else should be running before that.
The form itself:
<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px"
AutoGenerateRows="False" DataSourceID="Docs" DefaultMode="Insert"
OnItemInserting="DetailsView1_ItemInserting"
OnItemEditing="DetailsView1_ItemEditing"
>
<Fields>
<asp:BoundField DataField="Documents.Title" HeaderText="Title"
SortExpression="Documents.Title" />
<asp:TemplateField HeaderText="Type" SortExpression="Type">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem Selected="True" Value="Presentation">Presentation</asp:ListItem>
<asp:ListItem Value="Handout">Handout</asp:ListItem>
<asp:ListItem Value="Minutes">Minutes</asp:ListItem>
<asp:ListItem Value="Agenda">Agenda</asp:ListItem>
<asp:ListItem Value="Other">Other</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem Selected="True" Value="Presentation">Presentation</asp:ListItem>
<asp:ListItem Value="Handout">Handout</asp:ListItem>
<asp:ListItem Value="Minutes">Minutes</asp:ListItem>
<asp:ListItem Value="Agenda">Agenda</asp:ListItem>
<asp:ListItem Value="Other">Other</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("Type") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MeetingID" SortExpression="MeetingID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="Meetings"
DataTextField="Title" DataValueField="MeetingID">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="Meetings"
DataTextField="Title" DataValueField="MeetingID">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("MeetingID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="FileName" SortExpression="FileName">
<EditItemTemplate>
<asp:FileUpload ID="FileUpload2" runat="server" />
</EditItemTemplate>
<InsertItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" />
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("FileName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
ETA: The entire form:
<asp:Content ID="Content2" ContentPlaceHolderID="mainContent" Runat="Server">
<h1>Document Manager</h1>
<h2>Existing Documents</h2>
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="Docs"
OnRowDeleting="GridView1_RowDeleting"
DataKeyNames="DocID" BackColor="White" BorderColor="#E7E7FF"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:BoundField DataField="Documents.Title" HeaderText="Title"
SortExpression="Documents.Title" />
<asp:BoundField DataField="FileName" HeaderText="FileName"
SortExpression="FileName" />
<asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" />
<asp:BoundField DataField="Meetings.Title" HeaderText="Meeting"
SortExpression="Meetings.Title" />
<asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" />
<asp:HyperLinkField DataNavigateUrlFields="FileName" Text="Download" />
</Columns>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<SortedAscendingCellStyle BackColor="#F4F4FD" />
<SortedAscendingHeaderStyle BackColor="#5A4C9D" />
<SortedDescendingCellStyle BackColor="#D8D8F0" />
<SortedDescendingHeaderStyle BackColor="#3E3277" />
</asp:GridView>
<h2>Add New</h2>
<asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px"
AutoGenerateRows="False" DataSourceID="Docs" DefaultMode="Insert"
OnItemInserting="DetailsView1_ItemInserting"
OnItemEditing="DetailsView1_ItemEditing"
>
<Fields>
<asp:BoundField DataField="Documents.Title" HeaderText="Title"
SortExpression="Documents.Title" />
<asp:TemplateField HeaderText="Type" SortExpression="Type">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem Selected="True" Value="Presentation">Presentation</asp:ListItem>
<asp:ListItem Value="Handout">Handout</asp:ListItem>
<asp:ListItem Value="Minutes">Minutes</asp:ListItem>
<asp:ListItem Value="Agenda">Agenda</asp:ListItem>
<asp:ListItem Value="Other">Other</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem Selected="True" Value="Presentation">Presentation</asp:ListItem>
<asp:ListItem Value="Handout">Handout</asp:ListItem>
<asp:ListItem Value="Minutes">Minutes</asp:ListItem>
<asp:ListItem Value="Agenda">Agenda</asp:ListItem>
<asp:ListItem Value="Other">Other</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("Type") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MeetingID" SortExpression="MeetingID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="Meetings"
DataTextField="Title" DataValueField="MeetingID">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="Meetings"
DataTextField="Title" DataValueField="MeetingID">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("MeetingID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="FileName" SortExpression="FileName">
<EditItemTemplate>
<asp:FileUpload ID="FileUpload2" runat="server" />
</EditItemTemplate>
<InsertItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" />
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("FileName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
<asp:AccessDataSource ID="Docs" runat="server"
DataFile="~/App_Data/Database1.accdb"
DeleteCommand="DELETE FROM [Documents] WHERE [DocID] = ?"
InsertCommand="INSERT INTO [Documents] ([Title], [Type], [FileName], [MeetingID]) VALUES (@Title, @Type, @FileName, @MeetingID)"
SelectCommand="SELECT Documents.DocID, Documents.Title, Documents.FileName, Documents.Type, Meetings.Title, Documents.MeetingID FROM
(Documents LEFT OUTER JOIN Meetings ON Documents.MeetingID = Meetings.MeetingID)"
UpdateCommand= "UPDATE [Documents] SET [Title] = ?, [Type] = ?, [FileName] = ?, [MeetingID] = ? WHERE [DocID] = ?">
<DeleteParameters>
<asp:Parameter Name="DocID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Documents.Title" Type="String" />
<asp:Parameter Name="Type" Type="String" />
<asp:Parameter Name="FileName" Type="String" />
<asp:Parameter Name="MeetingID" Type="Int32" />
</InsertParameters>
<SelectParameters>
<asp:SessionParameter Name="?" SessionField="UserID" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Type" Type="String" />
<asp:Parameter Name="FileName" Type="String" />
<asp:Parameter Name="MeetingID" Type="Int32" />
<asp:Parameter Name="DocID" Type="Int32" />
</UpdateParameters>
</asp:AccessDataSource>
<asp:Label ID="StatusLabel" runat="server" Text="Label"></asp:Label>
<asp:AccessDataSource ID="Meetings" runat="server"
DataFile="~/App_Data/Database1.accdb"
SelectCommand="SELECT [MeetingID], [Title] FROM [Meetings] WHERE ([AdminID] = ?)">
<SelectParameters>
<asp:SessionParameter Name="AdminID" SessionField="UserID" Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>
I also edited in the rest of the c# code above, it wasn't as long
The form element in the master page:
<body style="background-color: rgb(231, 231, 255);height:100%;margin:0px;padding:0px">
<form id="form1" runat="server">
ETA: I found the problem. I'd been using an empty text file as a test - which was reading as 0 bytes, confusing the file uploader into thinking it had no file. Adding some text to the file makes it work perfectly.
Thanks for the help everyone!
692
FileUpload control requires a full PostBack. Hence when you place FileUpload control in AJAX UpdatePanel and try to upload the file asynchronously using the PostedFile property is always NULL and the HasFile property is always false.
The HasFile property gets a value indicating whether the FileUpload control contains a file to upload. Use this property to verify that a file to upload exists before performing operations on the file.
Use the FileName property to get the name of a file on a client to upload by using the FileUpload control. The file name that this property returns does not include the path of the file on the client. The FileContent property gets a Stream object that points to a file to upload.
Net C# using File Upload Control and Display in Gridview. Launch/Open Visual Studio -> Go to File Menu -> New -> Project. Select Visual C# from left side template then choose web -> ASP.Net web application and name it then click on Ok -> Select Empty tempate -> click on Ok.
I found the problem. I'd been using an empty text file as a test - which was reading as 0 bytes, confusing the file uploader into thinking it had no file. Adding some text to the file makes it work perfectly.
Ranting about why a file with a size of 0 bytes is not the same thing as no file at all shall be done elsewhere.
149
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
