Questions on UI for ASP.NET AJAX Forum

110,772 questions

5 answers

287 views

hi for all

I've download rad pdf tool
Because I want to use in web application and I want to show the files for visitors or users to the site through the rad pdf tool
But I don't know how to use this tool with asp.net
Any one can help me in this matter, or propose to another tool to view the pdf files

throw asp.net thanks

General Discussions

answered on 25 Nov 2010

2 answers

84 views

PanelBar does not expand to show all content in Firefox and does not show a scrollbar

The problem is in Firefox (only tested in IE6 and Firefox)
PanelBaritem does not expand to show all content in Firefox and does not show a scrollbar
attached is a screenshot
and here is a snippet

<telerik:RadPanelBar ID="RadPanelBar1" Runat="server" Skin="Windows7"

Width="90%" ExpandMode="SingleExpandedItem" AllowCollapseAllItems="true">

<Items>

<telerik:RadPanelItem runat="server" Text="Company" ImagePosition="Right" ImageUrl="Images/Expand.jpg" ExpandedImageUrl="Images/Collapse.jpg" >

<Items>

<telerik:RadPanelItem>

<ItemTemplate>

<uc2:ByCompany ID="ByCompany1" runat="server" />

</ItemTemplate>

</telerik:RadPanelItem>

</Items>

</telerik:RadPanelItem >

<telerik:RadPanelItem runat="server" Text="Analyst" ImagePosition="Right" ImageUrl="Images/Expand.jpg" ExpandedImageUrl="Images/Collapse.jpg">

<Items>

<telerik:RadPanelItem>

<ItemTemplate>

<uc3:ByAnalyst ID="ByAnalyst1" runat="server" />

</ItemTemplate>

</telerik:RadPanelItem>

</Items>

</telerik:RadPanelItem >

he code

PanelBar

answered on 25 Nov 2010

1 answer

91 views

Hierarchy Grid with Nested Object

Good Day/Evening,

I've been struggling these past 2 days to get the Heirarchy grid working with my object, this is what my object looks like

Public Class Person

Public Property Firstname as String

Public Property Surname as String

Public Property Age as Integer

Public Property Vehicles as List(Of Vehicle)

End Class

Public Class Vehicle

Public Property Make as String

Public Property Model as String

Public Property Color as String

End Class

Now when I call my WCF Service it returns a List(Of Person) which I bind to my RadGrid only show the Firstname,Surname and Age. I would like to get the Vehicles to show in a child grid. Is this possible?

Thank you!

Grid

answered on 25 Nov 2010

1 answer

162 views

Prevent Delete of top folder

Hi all

I'm using the FileExplorer control in a scenario with the following requirements:

a) Physical paths for the files should not accessible through IIS
=> I'm working on implementing an adapted version of the the "PhysicalpathFilesystemProvider"

b) The permissions should be set in a way that a user can upload files, create new folders and delete files/folders under a designed "home" (top) folder, but should not be allowed to delete or rename his "home" folder, for example:
"D:\userdata\10711" is the "home" folder for user 10711, where he should have full rights to anything that is in located in that folder and its subfolders, but he should not be allowed to delete or rename the "10711" folder.
=> I've played around with different configurations of viewPaths, uploadPaths and deletePaths, but have not found a way to set the permissions accordingly. But perhaps I'm overseeing something since I figure this must be quite a common scenario ...

Thanks in advance for any help,
Michael

FileExplorer

answered on 25 Nov 2010

1 answer

63 views

RadMenu in DNN

I created a parent portal in DNN and when I go to the new parent portal I see the menu and all pages from portal 0. Is there a setting in RadMenu that I need not to have this happen? I should not be seeing any of portal 0's pages.

Thanks,
Judy

answered on 25 Nov 2010

4 answers

66 views

Toggling group panel on the client side

Hi,

What's the best way of showing/hiding the group panel without doing a postback? I couldn't find an equivalent of hideFilterItem() / showFilterItem() for the group panel.

Thanks,

Grid

answered on 25 Nov 2010

3 answers

185 views

How to Upgrade Rad from the oldest version

Hi there,

I was using the old rad editor,(which uses RadEditor.Net2.dll)

I now got the latest version of rad and I have installed it on my machine.

Is there a way to upgrade the old to this new version (which uses Telerik.Web.UI.dll)

Like most of the websites still has old version of rad? i want to upgrade it to this new one , but not sure how.

Is there any documentation somewhere so i can upgrade my rad editor?

Please Help,

Thanks,
Abdul.

Documentation and Tutorials

answered on 25 Nov 2010

5 answers

159 views

Preview RadTextBox within RadGrid using RadWindow

Hi,
I have a RadGrid that serves to show text for preview and editing. I have a detail aspx page which serves as the parent, and then user control pages within a radtabstrip with a multipageview. When I try to preview the text box within the grid (which is wihtin the usercontrol), I get a null each time I reference the window manager, the window comes back null. I have a piece of it working where I preview images, for some reason it reads tha manager fine. As you can see from the code below, I've tried a few things. Let me know if there's a viable solution to my problem. Again, informationWindowLocation works, and the OnClientPageLoad doesn't.

protected void ibPreviewMessage_Click(object sender, EventArgs e)

{

ImageButton previewMessage = (ImageButton)sender;

ClientScriptManager clientScript = Page.ClientScript;

//string clientScriptName="previewMessage";

Type clientScriptType=this.GetType();

int index = previewMessage.ID.IndexOf("_"), ID;

int.TryParse(previewMessage.ID.Substring(index + 1), out ID);

foreach (GridDataItem gdi in grdMessages.Items)

{

RadTextBox rtb = (RadTextBox)gdi["DefaultDescriptionNameColumn"].FindControl("Description_" + ID.ToString());

if (rtb != null)

{

radWindowManager1.OnClientPageLoad = "OnClientPageLoad('" + HttpUtility.HtmlEncode(rtb.Text) + "')";

RadWindow newwindow = new RadWindow();

newwindow.ID = "previewmessages";

newwindow.NavigateUrl = "about:blank";

newwindow.VisibleOnPageLoad = true;

newwindow.Behaviors = WindowBehaviors.Close;

radWindowManager1.Windows.Add(newwindow);

//if (!clientScript.IsClientScriptBlockRegistered(clientScriptType, clientScriptName))

//{

// StringBuilder sb = new StringBuilder();

// sb.Append("<script type='text/javascript'>");

// sb.Append("radopen('about:blank')");

// sb.Append("document.write(" + HttpUtility.HtmlEncode(rtb.Text) + ")");

// sb.Append("</script>");

// clientScript.RegisterClientScriptBlock(clientScriptType, clientScriptName, sb.ToString());

//}

//RadAjaxManager ajm = RadAjaxManager.GetCurrent(Page);

//if (ajm != null)

//{

// ajm.Alert(HttpUtility.HtmlEncode(rtb.Text)); // make this a radopen or a window.open

//}

}

<script type="text/javascript">

function informationWindowLocation(id) {

var oManager = GetRadWindowManager();

var fileName = "Images/" + id;

var examplePath = new Image();

examplePath.src = fileName;

var width = examplePath.width;

var height = examplePath.height;

var oWnd = oManager.GetWindowByName("messages");

if (width > 0 && height > 0) {

oWnd.Show();

oWnd.setSize(width + 100, height + 100);

oWnd.SetUrl(fileName, "messages");

}

else {

radalert("Example doesn't exist for this level and Promotion Type", 425, 150, "Promotion Type Example");

}

return false;

}

function OnClientPageLoad(textDescription) {

var oManager = GetRadWindowManager();

var oWnd = oManager.GetWindowByName("messages");

oWnd.GetContentFrame().contentWindow.document.write('<html><title>Preview Description</title><body>' + textDescription + '</body></html>');

oWnd.Show();

}

</script>

<telerik:RadGrid ID="grdMessages" runat="server" Skin="Vista" OnItemCreated="grdMessages_ItemCreated" style="padding-top:20px;">

<ItemStyle Height="150px" />

<MasterTableView AutoGenerateColumns="false" ShowHeader="false" DataKeyNames="Level" ClientDataKeyNames="Level" EnableNoRecordsTemplate="true">

<Columns>

<telerik:GridBoundColumn DataField="Level" UniqueName="LevelColumn" Visible="false" />

<telerik:GridTemplateColumn UniqueName="ShowImage" DataField="Level_Message_Example">

<ItemTemplate>

<asp:ImageButton ID="ibPreviewLocation" runat="server" ImageUrl="~/Images/picture.png" ImageAlign="Middle" OnClientClick='<%# String.Format("return informationWindowLocation(\"{0}\");", Eval("Level_Message_Example")) %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="PreviewMessage" DataField="Level">

<ItemTemplate>

<asp:ImageButton ID="ibPreviewMessage" runat="server" ImageUrl="~/Images/image_magnify.png" ImageAlign="Middle" OnClick="ibPreviewMessage_Click" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="Description" UniqueName="DescriptionColumn" />

<telerik:GridTemplateColumn DataField="Default_Description" UniqueName="DefaultDescriptionNameColumn">

<ItemStyle Width="70%" Wrap="false" Height="150px" />

<ItemTemplate>

<telerik:RadTextBox ID="rtbDescription" Height="150px" runat="server" Width="100%" TextMode="MultiLine" Text='<%# Eval("Default_Description") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<NoRecordsTemplate><asp:Label ID="lblPromotionEmptyMessage" runat="server" Text="No Messages Available for Editing" /></NoRecordsTemplate>

</MasterTableView>

</telerik:RadGrid>

<telerik:RadWindowManager ID="radWindowManager1" runat="server"></telerik:RadWindowManager>

the radwindow manager on the aspx page looks like this

<telerik:RadWindowManager ID="RadWindowManager1" ShowContentDuringLoad="false" VisibleStatusbar="false"

ReloadOnShow="true" runat="server" Skin="Windows7" EnableShadow="true" Behaviors="Close">

<Windows>

<telerik:RadWindow ID="save" runat="server" Skin="Windows7" Height="345px" Width="475px"

ReloadOnShow="true" ShowContentDuringLoad="false" Modal="true" VisibleTitlebar="false" />

<telerik:RadWindow ID="products" Width="320" Height="275" runat="server" Behaviors="Close" />

<telerik:RadWindow ID="messages" runat="server" KeepInScreenBounds="true" Behaviors="Close" Width="300" Height="300" />

</Windows>

</telerik:RadWindowManager>

I know that it has two radwindowmanagers on the same page, but I couldn't get the manager from the main page when I tried to search using the $find method. I also couldn't find the one on the user control. Let me know if there is anything I should do. Thanks

Window

answered on 25 Nov 2010

5 answers

84 views

Inconsistent bug when saving text from RAD Editor to DB.

Im getting an exception randomly only on the deplyed server version of my app. This exception does not come upp when i debug in my local version. I have tried to update and replace the .CS files to make sure they are the same on server as on local machine.

The app saves text from a RadEditor to a database.

I never get this error on the local machine while debugging it in visual studio, so i am lost and dont know what to do?! :(

The problem is when i hit hte save button. Sometimes i get this error:

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Line 347: articleToBeEdited.Body = editorSweBody.Content;

Line 348: articleToBeEdited.Title = tbTitle.Text;

Line 349: articleToBeEdited.TitleFinnish = tbTitleFinnish.Text;

saadasdasasd

Editor

answered on 25 Nov 2010

1 answer

99 views

ASPX page fails with input control

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?

Upload (Obsolete)

answered on 25 Nov 2010

Top users last month