Let me start with the code
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?
<%@ 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?