Problem with Repeater control in UpdatePanel

[JFKJr]

Hello Guys,

I have been trying to solve the following problem from past 3 days with no luck.

This is what I am trying to do:

I want to allow user (Professor) to choose a course material using "asp:FileUpload" control, upload into the database by clicking "asp:Button" control and allow Professor to view the files he/she uploaded using "asp:Repeater" control.

The procedure is working perfectly fine. But when I place the "asp:Repeater" control in Ajax UpdatePanel, I am unable to retrieve file from "asp:FileUpload" control.

Please help me out. Thanks a million in advance.

1. The following is "CreateSchedule.aspx" page, using this page a professor can upload course materials.

<asp: Content ID="Content1"  ContentPlaceHolderID="ContentPlaceholder1" Runat="Server">
 
<table>
<tr>
<td>Select File:</td>
<td><asp:FileUpload ID="CMFileUpload" runat="server" /></td>
</tr>
<tr>
<td colspan=2>
<asp:Button ID="CMUploadButton" runtat="server" Text="Upload" onClick="CMUploadButton_Click">
</td>
</tr>
<td>Course Materials Uploaded:</td>
<td>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode=Conditional>
<ContentTemplate>
    <asp:Repeater ID="CMRepeater" runat="server"><ItemTemplate>   
    <asp:LinkButton ID="LinkButton1" runat="server" OnCommand="LinkButton1_Click" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"File_UID") %>'><%#DataBinder.Eval(Container.DataItem,"File_Name2") %></asp:LinkButton>
    <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/wrong-icon.gif" OnCommand="ImageButton1_Click" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"File_UID") %>' /> 
    </ItemTemplate></asp:Repeater>
</ContentTemplate>
<Triggers>
    <asp:AsyncPostBackTrigger ControlID="CMUploadButton" EventName="Click" />
</Triggers>
</asp:UpdatePanel>
</td>
<tr>
</tr>
</table>
</asp:Content>

2. "CreateSchedule.aspx.cs" page:

protected void CMUploadButton_Click(object sender, EventArgs e)
    {
        if (!CMFileUpload.HasFile) return;
        int weekNo = 1;
        byte[] binary = new byte[CMFileUpload.PostedFile.ContentLength];
        binary = CMFileUpload.FileBytes;
        SqlParameter param = null;
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=CSMS;Integrated Security=true";
        SqlCommand cmd = new SqlCommand("UploadCourseMaterials", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        param = new SqlParameter("@File_Name1", SqlDbType.NVarChar, 50,
                ParameterDirection.Input, false, 0, 0, "",
                DataRowVersion.Default, CMFileUpload.FileName);
        cmd.Parameters.Add(param);
        param = new SqlParameter("@File_Name2", SqlDbType.NVarChar, 50,
                ParameterDirection.Input, false, 0, 0, "",
                DataRowVersion.Default, CMNameTextBox.Text);
        cmd.Parameters.Add(param);
        param = new SqlParameter("@File_Content", SqlDbType.Image);
        param.Direction = ParameterDirection.Input;
        param.Value = binary;
        cmd.Parameters.Add(param);
        param = new SqlParameter("@Content_Type", SqlDbType.NVarChar, 50,
                ParameterDirection.Input, false, 0, 0, "",
                DataRowVersion.Default, CMFileUpload.PostedFile.ContentType);
        cmd.Parameters.Add(param);
        param = new SqlParameter("@WeekID", SqlDbType.Int, 4);
        param.Value = weekNo;
        cmd.Parameters.Add(param);
 
        conn.Open();
        cmd.ExecuteNonQuery();
        DisplayCourseMaterials();
    }
 
private void DisplayCourseMaterials()
    {
        SqlConnection mySQLconnection = new SqlConnection();
        mySQLconnection.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=CSMS;Integrated Security=true";
 
        if (mySQLconnection.State == ConnectionState.Closed)
        {
            mySQLconnection.Open();
        }
 
        SqlCommand mySqlSelect = new SqlCommand("select * from CourseMaterials", mySQLconnection);
        mySqlSelect.CommandType = CommandType.Text;
 
        SqlDataAdapter mySqlAdapter = new SqlDataAdapter(mySqlSelect);
        DataSet myDataSet = new DataSet();
        mySqlAdapter.Fill(myDataSet);
 
        CMRepeater.DataSource = myDataSet;
        CMRepeater.DataBind();
 
        if (mySQLconnection.State == ConnectionState.Open)
        {
            mySQLconnection.Close();
        }
    }

[Frinavale]

The FileUpload control does not work in an UpdatePanel.

Here is a list of controls that do not work within an update panel (according to the Documentation for ASP.NET Ajax Version 1.0

The following ASP.NET controls are not compatible with partial-page updates, and are therefore not supported inside an UpdatePanel control:

TreeView and Menu controls.


FileUpload controls.

GridView and DetailsView controls when their EnableSortingAndPagingCallbacks property is set to true.

Login, PasswordRecovery, ChangePassword, and CreateUserWizard controls whose contents have not been converted to editable templates.


The Substitution control.

Validation controls, which includes the BaseCompareValidator, BaseValidator, CompareValidator, CustomValidator, RangeValidator, RegularExpressionValidator, RequiredFieldValidator, and ValidationSummary control.

Since the FileUpload control requires a full page postback you could consider placing your FileUpload within an IFrame.

-Frinny

[JFKJr]

Hello Frinny,

Thanks for the reply.

I changed the above "CreateSchedule.aspx" page a little bit as follows:

1. "CreateSchedule.aspx" page

<asp: Content ID="Content1"  ContentPlaceHolderID="ContentPlaceholder1" Runat="Server">  
<table> 
<tr> 
<td>Select File:</td> 
<td>
<asp:ScriptManager ID="ScriptManager1" runat="server"> 
</asp:ScriptManager> 
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode=Conditional> 
<ContentTemplate> 
    <asp:FileUpload ID="CMFileUpload" runat="server" />
</ContentTemplate> 
</asp:UpdatePanel> 
</td> 
</tr> 
<tr> 
<td colspan=2> 
<asp:Button ID="CMUploadButton" runtat="server" Text="Upload" onClick="CMUploadButton_Click"> 
</td> 
</tr> 
</table> 
</asp:Content> 

2. "CreateSchedule.aspx.cs" page:

protected void CMUploadButton_Click(object sender, EventArgs e) 
    { 
         UpdatePanel1.Update();
         if (!CMFileUpload.HasFile) return; 
    }

And whenever I click "Upload" button, it is calling "CMUploadButton_Click" event.

For the first time, the button is unable to retrieve file from "FileUpload" control and coming out of the event procedure (at line #4).

In the following attempts, I am able to retrieve file from "FileUpload" control.

Please kindly let me know how to solve this issue?

Thanks.

[muthu krishnan]

Hi all,

Only the solution use AsyncFileUpload instead of asp:fileupload control

[Frinavale]

Thank you for the reply Muthu.
For those who are unaware of this control, it's part of the free AjaxControlToolkit Library.

-Frinny