This is a migrated thread and some comments may be shown as answers.

ASPX page fails with input control

1 Answer 99 Views

Upload (Obsolete)

This is a migrated thread and some comments may be shown as answers.

David asked on 24 Nov 2010, 07:07 PM

Let me start with the code

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UpdateMembers.aspx.cs" Inherits="Commissions.UpdateMembers" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title></title>

<link href="Stylesheet.css" rel="stylesheet" type="text/css" />

</head>

<body>

<form id="form1" runat="server">

<telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server">

</telerik:RadStyleSheetManager>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

</telerik:RadScriptManager>

<div>

<br />

Please select an Excel file to import:<br />

<telerik:RadUpload ID="RadUpload1" Runat="server"

AllowedFileExtensions="xls" ControlObjectsVisibility="None">

</telerik:RadUpload>

<br />

<asp:Button ID="ButtonUploadFile" runat="server" Text="Upload File"

onclick="ButtonUploadFile_Click" CausesValidation="False"

UseSubmitBehavior="False" />

<br />

<asp:Label ID="LabelUpload" runat="server" Text=""></asp:Label>

</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:CommissionsEngineConnectionString %>"

SelectCommand="SELECT MemberID, AgencyName, Company, AgencyID, AgentLastName, AgentFirstName, AgentID, ApplicationNo, EligibleForCommission, CommissionableReason, MemberLastName, MemberFirstName, MemberMidInitial, MedicareID, County, CountyCode, State, PlanID, SignedDate, EnrollDate, TransDate, CMSDate, Effdate, ExpireDate, OrigEffDate, MemberStatus, MemberInfo, CommissionType, PaidTo, TotalCommissionAmount, FMOAgencyTotalCommission, AgentTotalCommission, FMOTotalOverrideCommission, TotalPreviouslyPaid, FMOAgencyPreviousPaid, AgentPreviouslyPaid, FMO_OverridePreviousPaid, CurrentPaymentOrCharge, FMOAgencyCurrentPaymentOrCharge, AgentCurrentPaymentOrCharge, FMO_OverrideCurrentPaymentOrCharge, YTD2009ProRata, Current2009ProRata, YTDRetention, CurrentRetention, RAM_Override, FD_Override, ND_Director_Override, Corp_L1_Override, Corp_L2_Override, Corp_L2a_Override, Corp_L2b_Override, Corp_L2c_Override, Corp_L3_Override, AgentDatePaidOrCharged, AgentPaymentRef, AgentVoidDate, AgencyDatePaidOrCharged, AgencyPaymentRef, AgencyVoidDate, FMO_OverrideDatePaidOrCharged, FMO_OverridePaymentRef, FMO_OverrideVoidDate, FMO_OverrideID, CycleYearEnrollDate, PriorPlanType, AutoRollover, IntegrityCheck, YearRun, ManualOverride, Notes, DateEntered, EnteredBy, DateUpdated, UpdatedBy FROM MembersTemp">

</asp:SqlDataSource>

<br />

<asp:Button ID="Button1" runat="server" onclick="Button1_Click"

Text="View Data" />

<br />

<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True"

AllowPaging="True" DataSourceID="SqlDataSource1" GridLines="None"

Visible="False">

<HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

<MasterTableView AutoGenerateColumns="False" DataKeyNames="MemberID"

DataSourceID="SqlDataSource1">

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="MemberID" HeaderText="MemberID"

ReadOnly="True" SortExpression="MemberID" UniqueName="MemberID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgencyName" HeaderText="AgencyName"

SortExpression="AgencyName" UniqueName="AgencyName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Company" HeaderText="Company"

SortExpression="Company" UniqueName="Company">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgencyID" HeaderText="AgencyID"

SortExpression="AgencyID" UniqueName="AgencyID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentLastName" HeaderText="AgentLastName"

SortExpression="AgentLastName" UniqueName="AgentLastName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentFirstName" HeaderText="AgentFirstName"

SortExpression="AgentFirstName" UniqueName="AgentFirstName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentID" HeaderText="AgentID"

SortExpression="AgentID" UniqueName="AgentID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ApplicationNo" HeaderText="ApplicationNo"

SortExpression="ApplicationNo" UniqueName="ApplicationNo">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="EligibleForCommission"

HeaderText="EligibleForCommission" SortExpression="EligibleForCommission"

UniqueName="EligibleForCommission">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CommissionableReason"

HeaderText="CommissionableReason" SortExpression="CommissionableReason"

UniqueName="CommissionableReason">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MemberLastName" HeaderText="MemberLastName"

SortExpression="MemberLastName" UniqueName="MemberLastName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MemberFirstName"

HeaderText="MemberFirstName" SortExpression="MemberFirstName"

UniqueName="MemberFirstName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MemberMidInitial"

HeaderText="MemberMidInitial" SortExpression="MemberMidInitial"

UniqueName="MemberMidInitial">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MedicareID" HeaderText="MedicareID"

SortExpression="MedicareID" UniqueName="MedicareID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="County" HeaderText="County"

SortExpression="County" UniqueName="County">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CountyCode" HeaderText="CountyCode"

SortExpression="CountyCode" UniqueName="CountyCode">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="State" HeaderText="State"

SortExpression="State" UniqueName="State">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PlanID" HeaderText="PlanID"

SortExpression="PlanID" UniqueName="PlanID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SignedDate" DataType="System.DateTime"

HeaderText="SignedDate" SortExpression="SignedDate" UniqueName="SignedDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="EnrollDate" DataType="System.DateTime"

HeaderText="EnrollDate" SortExpression="EnrollDate" UniqueName="EnrollDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TransDate" DataType="System.DateTime"

HeaderText="TransDate" SortExpression="TransDate" UniqueName="TransDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CMSDate" DataType="System.DateTime"

HeaderText="CMSDate" SortExpression="CMSDate" UniqueName="CMSDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Effdate" DataType="System.DateTime"

HeaderText="Effdate" SortExpression="Effdate" UniqueName="Effdate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ExpireDate" DataType="System.DateTime"

HeaderText="ExpireDate" SortExpression="ExpireDate" UniqueName="ExpireDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OrigEffDate" DataType="System.DateTime"

HeaderText="OrigEffDate" SortExpression="OrigEffDate" UniqueName="OrigEffDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MemberStatus" HeaderText="MemberStatus"

SortExpression="MemberStatus" UniqueName="MemberStatus">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MemberInfo" HeaderText="MemberInfo"

SortExpression="MemberInfo" UniqueName="MemberInfo">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CommissionType" HeaderText="CommissionType"

SortExpression="CommissionType" UniqueName="CommissionType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PaidTo" HeaderText="PaidTo"

SortExpression="PaidTo" UniqueName="PaidTo">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TotalCommissionAmount"

DataType="System.Decimal" HeaderText="TotalCommissionAmount"

SortExpression="TotalCommissionAmount" UniqueName="TotalCommissionAmount">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMOAgencyTotalCommission"

DataType="System.Decimal" HeaderText="FMOAgencyTotalCommission"

SortExpression="FMOAgencyTotalCommission" UniqueName="FMOAgencyTotalCommission">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentTotalCommission"

DataType="System.Decimal" HeaderText="AgentTotalCommission"

SortExpression="AgentTotalCommission" UniqueName="AgentTotalCommission">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMOTotalOverrideCommission"

DataType="System.Decimal" HeaderText="FMOTotalOverrideCommission"

SortExpression="FMOTotalOverrideCommission"

UniqueName="FMOTotalOverrideCommission">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TotalPreviouslyPaid"

DataType="System.Decimal" HeaderText="TotalPreviouslyPaid"

SortExpression="TotalPreviouslyPaid" UniqueName="TotalPreviouslyPaid">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMOAgencyPreviousPaid"

DataType="System.Decimal" HeaderText="FMOAgencyPreviousPaid"

SortExpression="FMOAgencyPreviousPaid" UniqueName="FMOAgencyPreviousPaid">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentPreviouslyPaid"

DataType="System.Decimal" HeaderText="AgentPreviouslyPaid"

SortExpression="AgentPreviouslyPaid" UniqueName="AgentPreviouslyPaid">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMO_OverridePreviousPaid"

DataType="System.Decimal" HeaderText="FMO_OverridePreviousPaid"

SortExpression="FMO_OverridePreviousPaid" UniqueName="FMO_OverridePreviousPaid">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CurrentPaymentOrCharge"

DataType="System.Decimal" HeaderText="CurrentPaymentOrCharge"

SortExpression="CurrentPaymentOrCharge" UniqueName="CurrentPaymentOrCharge">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMOAgencyCurrentPaymentOrCharge"

DataType="System.Decimal" HeaderText="FMOAgencyCurrentPaymentOrCharge"

SortExpression="FMOAgencyCurrentPaymentOrCharge"

UniqueName="FMOAgencyCurrentPaymentOrCharge">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentCurrentPaymentOrCharge"

DataType="System.Decimal" HeaderText="AgentCurrentPaymentOrCharge"

SortExpression="AgentCurrentPaymentOrCharge"

UniqueName="AgentCurrentPaymentOrCharge">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMO_OverrideCurrentPaymentOrCharge"

DataType="System.Decimal" HeaderText="FMO_OverrideCurrentPaymentOrCharge"

SortExpression="FMO_OverrideCurrentPaymentOrCharge"

UniqueName="FMO_OverrideCurrentPaymentOrCharge">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="YTD2009ProRata" DataType="System.Decimal"

HeaderText="YTD2009ProRata" SortExpression="YTD2009ProRata"

UniqueName="YTD2009ProRata">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Current2009ProRata"

DataType="System.Decimal" HeaderText="Current2009ProRata"

SortExpression="Current2009ProRata" UniqueName="Current2009ProRata">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="YTDRetention" DataType="System.Decimal"

HeaderText="YTDRetention" SortExpression="YTDRetention"

UniqueName="YTDRetention">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CurrentRetention" DataType="System.Decimal"

HeaderText="CurrentRetention" SortExpression="CurrentRetention"

UniqueName="CurrentRetention">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="RAM_Override" DataType="System.Decimal"

HeaderText="RAM_Override" SortExpression="RAM_Override"

UniqueName="RAM_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FD_Override" DataType="System.Decimal"

HeaderText="FD_Override" SortExpression="FD_Override" UniqueName="FD_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ND_Director_Override"

DataType="System.Decimal" HeaderText="ND_Director_Override"

SortExpression="ND_Director_Override" UniqueName="ND_Director_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Corp_L1_Override" DataType="System.Decimal"

HeaderText="Corp_L1_Override" SortExpression="Corp_L1_Override"

UniqueName="Corp_L1_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Corp_L2_Override" DataType="System.Decimal"

HeaderText="Corp_L2_Override" SortExpression="Corp_L2_Override"

UniqueName="Corp_L2_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Corp_L2a_Override"

DataType="System.Decimal" HeaderText="Corp_L2a_Override"

SortExpression="Corp_L2a_Override" UniqueName="Corp_L2a_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Corp_L2b_Override"

DataType="System.Decimal" HeaderText="Corp_L2b_Override"

SortExpression="Corp_L2b_Override" UniqueName="Corp_L2b_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Corp_L2c_Override"

DataType="System.Decimal" HeaderText="Corp_L2c_Override"

SortExpression="Corp_L2c_Override" UniqueName="Corp_L2c_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Corp_L3_Override" DataType="System.Decimal"

HeaderText="Corp_L3_Override" SortExpression="Corp_L3_Override"

UniqueName="Corp_L3_Override">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentDatePaidOrCharged"

DataType="System.DateTime" HeaderText="AgentDatePaidOrCharged"

SortExpression="AgentDatePaidOrCharged" UniqueName="AgentDatePaidOrCharged">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentPaymentRef"

HeaderText="AgentPaymentRef" SortExpression="AgentPaymentRef"

UniqueName="AgentPaymentRef">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgentVoidDate" DataType="System.DateTime"

HeaderText="AgentVoidDate" SortExpression="AgentVoidDate"

UniqueName="AgentVoidDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgencyDatePaidOrCharged"

DataType="System.DateTime" HeaderText="AgencyDatePaidOrCharged"

SortExpression="AgencyDatePaidOrCharged" UniqueName="AgencyDatePaidOrCharged">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgencyPaymentRef"

HeaderText="AgencyPaymentRef" SortExpression="AgencyPaymentRef"

UniqueName="AgencyPaymentRef">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AgencyVoidDate" DataType="System.DateTime"

HeaderText="AgencyVoidDate" SortExpression="AgencyVoidDate"

UniqueName="AgencyVoidDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMO_OverrideDatePaidOrCharged"

DataType="System.DateTime" HeaderText="FMO_OverrideDatePaidOrCharged"

SortExpression="FMO_OverrideDatePaidOrCharged"

UniqueName="FMO_OverrideDatePaidOrCharged">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMO_OverridePaymentRef"

HeaderText="FMO_OverridePaymentRef" SortExpression="FMO_OverridePaymentRef"

UniqueName="FMO_OverridePaymentRef">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMO_OverrideVoidDate"

DataType="System.DateTime" HeaderText="FMO_OverrideVoidDate"

SortExpression="FMO_OverrideVoidDate" UniqueName="FMO_OverrideVoidDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FMO_OverrideID" HeaderText="FMO_OverrideID"

SortExpression="FMO_OverrideID" UniqueName="FMO_OverrideID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CycleYearEnrollDate"

HeaderText="CycleYearEnrollDate" SortExpression="CycleYearEnrollDate"

UniqueName="CycleYearEnrollDate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PriorPlanType" HeaderText="PriorPlanType"

SortExpression="PriorPlanType" UniqueName="PriorPlanType">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AutoRollover" HeaderText="AutoRollover"

SortExpression="AutoRollover" UniqueName="AutoRollover">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="IntegrityCheck" HeaderText="IntegrityCheck"

SortExpression="IntegrityCheck" UniqueName="IntegrityCheck">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="YearRun" HeaderText="YearRun"

SortExpression="YearRun" UniqueName="YearRun">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ManualOverride" HeaderText="ManualOverride"

SortExpression="ManualOverride" UniqueName="ManualOverride">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Notes" HeaderText="Notes"

SortExpression="Notes" UniqueName="Notes">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DateEntered" DataType="System.DateTime"

HeaderText="DateEntered" SortExpression="DateEntered" UniqueName="DateEntered">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="EnteredBy" HeaderText="EnteredBy"

SortExpression="EnteredBy" UniqueName="EnteredBy">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DateUpdated" DataType="System.DateTime"

HeaderText="DateUpdated" SortExpression="DateUpdated" UniqueName="DateUpdated">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UpdatedBy" HeaderText="UpdatedBy"

SortExpression="UpdatedBy" UniqueName="UpdatedBy">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<telerik:RadAjaxManager runat="server">

</telerik:RadAjaxManager>

</form>

</body>

</html>

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.Sql;

using System.Data.SqlClient;

using System.Data.OleDb;

namespace Commissions

{

public partial class UpdateMembers : System.Web.UI.Page

{

protected void ImportData()

{

string sSourceConstr = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/ExcelImport.xls") + "; Extended Properties='Excel 8.0;HDR=YES;'";

string sDestConstr = ConfigurationSettings.AppSettings["connString"];

OleDbConnection conn = new OleDbConnection(sSourceConstr);

using (conn)

{

string sql = "Select * FROM Worksheet1";

OleDbCommand command = new OleDbCommand(sql, conn);

conn.Open();

using (OleDbDataReader dr = command.ExecuteReader())

{

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sDestConstr))

{

bulkCopy.DestinationTableName = "MembersTemp";

//You can mannualy set the column mapping by the following way.

//bulkCopy.ColumnMappings.Add("MSISDN", "MSISDN");

bulkCopy.WriteToServer(dr);

}

protected void Page_Load(object sender, EventArgs e)

{

}

protected void ButtonUploadFile_Click(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

RadGrid1.Rebind();

RadGrid1.Visible = true;

}

protected void Button2_Click(object sender, EventArgs e)

{

}

When this page is executed and no file has been selected nothing nhappens as it should. However, select a file, press the Upload button and the page kiscks back with a lost network connection error. the crazy part is thyere is no code in this button so why is this happening?

1 Answer, 1 is accepted

answered on 25 Nov 2010, 03:39 PM

Hi David,

This issue happens when one is trying upload a file larger than 4mb (the default size allowed by ASP.NET). If you need to upload files larger than 4mb, some tweaks in the web.config are needed. I suggest that you take a look at the following help article which explains in details how to do that.

All the best,
Genady Sergeev
the Telerik team

Browse the vast support resources we have to jumpstart your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.