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

RadComboBox drop-down rendering issue

15 Answers 704 Views

ComboBox

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

ToltingColtAcres asked on 02 Apr 2013, 06:19 PM

problem.png

I have an issue with my radComboBoxes rendering the drop-down data randomly on the screen.

Attached is an illustration of the problem with one of the fields.

The code for the combobox is as follows:

<telerik:RadComboBox ID="RadComboBox_Age_UOM_GUID" Runat="server" DataSourceID="SqlDataSource_AgeUOM" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="200px" />

Also, the problem only occurs once the user has to scroll down... so, the comboboxes which are present on the initial, visible portion of the page work correctly... but the moment the user has to scroll down the web page (either by clicking the down-arrow or scrolling), the combobox drop-down rendering is FUBAR.

The problem is not related to the specific control... if I change my video resolution to a lessor screen size, then a combobox higher-up on the screen which is initially visible at the higher resolution (and renders the drop-down correctly) will become FUBAR when I change to a lower resolution and then have to scroll down to get to the control. (Hopefully that makes sense... In other words, if ComboBoxA is normally visible on the web page at 1024x768 and renders correctly, if I use a machine with 800x600 resolution where ComboBoxA is only accessible after scrolling down, it will render correctly on the 1024x768 system, but render incorrectly on the 800x600 system.)

Also... the problem seems to compound itself the more you scroll down... such that, comboboxes at the way bottom of the screen, if you expand them, won't even show the expanded data (because it actually expands much 'higher up' on the non-visible portion of the web page. This confuses users as they think clicking the down-arrow on the combobox is having no effect.

I do not have this issue in development. It only occurs on the production system.

Can anyone tell me how to correct this? I have irate users.

15 Answers, 1 is accepted

answered on 03 Apr 2013, 05:03 AM

Hello,

Please try with the nelow code snippet.

<script type="text/javascript" language="javascript">

function pageLoad() {

$telerik.$("#container").scroll(function() {

var combos = Telerik.Web.UI.RadComboBox.ComboBoxes;

if (combos != null) {

for (var i = 0; i < combos.length; i++) {

var combo = combos[i];

if (combo.get_dropDownVisible())

combo.hideDropDown();

}

});

}

</script>

For more info please check below link.
http://www.telerik.com/community/forums/aspnet-ajax/combobox/radcombobox-autoresize-and-dropdown-position.aspx#1682758

Thanks,
Jayesh Goyani

answered on 03 Apr 2013, 03:26 PM

problem.png

The "solution" indicated above had no effect.

Note attached screen shot. Note red border.

added Code:

Still have the same problem.

User is irate. Doesn't want to hear "its a problem with the control" excuse. Expects me to fix it.

I am disturbed by the link. Apparently this bug has been around for two years. Why hasn't it been fixed? What does my annual support contract pay for?

If I global search/replace telerik:RadComboBox with asp:DropDownList, rebuild and publish... guess what? All the comboboxes display data in the correct places.

So, why can't Telerik get it right, when Microsoft apparently can?

<script type="text/javascript" lang="javascript">

function pageLoad() {

$telerik.$("#container").scroll(function () {

var combos = Telerik.Web.UI.RadComboBox.ComboBoxes;

if (combos != null) {

for (var i = 0; i < combos.length; i++) {

var combo = combos[i];

if (combo.get_dropDownVisible())

combo.hideDropDown();

}

});

}

</script>

...

 <div id="container" style="height: 100%; border: 1px solid red; overflow: auto;">

(bunch of comboboxes)

</div>

answered on 23 Apr 2013, 12:23 PM

testform.png

I apologize for the delay, going project deadlines required I work on other things.

I've attached a screen shot showing the problem. The generated source code for the page is below, along with the "source" code of the aspx page. Unfortunately I cannot attach a .html or .txt file containing the source and generated html code. Problem happens in several browsers, including the latest version of IE.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TestForm.aspx.cs" Inherits="TestForm" %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>

<%@ Register src="NavigationMenu.ascx" tagname="NavigationMenu" tagprefix="uc1" %>

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

<head id="Head1" runat="server">

<title></title>

<style type="text/css">

.auto-style1 { text-align: center; }

.auto-style1-210 { width: 210px; text-align: center; }

.style-indent { width: 210px; text-align: right; }

.style-buttons-right { width: 45%; text-align: right }

.style-buttons-left { width: 45%; text-align: left }

.style-font-size-1 { font-size: x-small; }

.style-table { border: 0px; }

</style>

</head>

<body>

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

<uc1:NavigationMenu ID="NavigationMenu1" runat="server" />

<telerik:RadTabStrip ID="RadTabStrip_Reporter" runat="server" Width="100%">

<Tabs>

<telerik:RadTab runat="server" Text="Reporter" Selected="true" ></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<table id="Table_Reporter" class="style-table">

<tr>

<td class="style-indent">

How Received:

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Reporter_Origin_GUID" Runat="server" DataSourceID="SqlDataSource_ReporterOrigin" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

<tr>

<td class="style-indent">

Reporter:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Reporter_Name" Runat="server" Height="150px" Width="800px" Text='<%# DataBinder.Eval( Container, "DataItem.Reporter_Name") %>' TextMode="MultiLine"/>

</td>

</tr>

<tr>

<td class="style-indent">

Telephone:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Reporter_Telephone" Runat="server" MaxLength="20" />

</td>

</tr>

<tr>

<td class="style-indent">

Source:

<div class="style-font-size-1">

<br />

if 'Other', specify:

</div>

</td>

<td>

<asp:CheckBox ID="RadCheckBox_Foreign" runat="server" Text="Foreign" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Foreign") %>' />

<br />

<asp:CheckBox ID="RadCheckBox_Study" Text="Study" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Study") %>'/><br />

<asp:CheckBox ID="RadCheckBox_Literature" Text="Literature" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Literature") %>'/><br />

<asp:CheckBox ID="RadCheckBox_Consumer" Text="Consumer" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Consumer") %>'/><br />

<asp:CheckBox ID="RadCheckBox_HealthProfessional" Text="Health Professional" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_HealthProfessional") %>'/><br />

<asp:CheckBox ID="RadCheckBox_UserFacility" Text="User Facility" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_UserFacility") %>'/><br />

<asp:CheckBox ID="RadCheckBox_CompanyRep" runat="server" Text="Company Representative" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_CompanyRep") %>' />

<br />

<asp:CheckBox ID="RadCheckBox_Distributor" Text="Distributor" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Distributor") %>'/><br />

<asp:CheckBox ID="RadCheckBox_Other" Text="Other" runat="server"

Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Other") %>'  OnCheckedChanged="RadCheckBox_Other_CheckedChanged" AutoPostBack="True"/>, source:

<telerik:RadTextBox ID="RadTextBox_Report_Source_Other" Runat="server"

Text='<%# DataBinder.Eval( Container, "DataItem.Report_Source_Other") %>' Width="360px" MaxLength="15" Enabled="False" ReadOnly="True" />

</td>

</tr>

<tr>

<td class="style-indent">

Relation To Patient:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Reporter_Relationship" Runat="server" MaxLength="50"/>

</td>

</tr>

<tr>

<td class="style-indent">

Health Professional?

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Reporter_Status_GUID" Runat="server" DataSourceID="SqlDataSource_ReporterStatus" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

<tr>

<td class="style-indent">

Occupation:

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Reporter_Title_GUID" Runat="server" DataSourceID="SqlDataSource_ReporterTitle" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

<tr>

<td class="style-indent">

Report also sent to FDA?

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Initial_Reporter_GUID" Runat="server" DataSourceID="SqlDataSource_InitialReporter" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

<tr>

<td class="style-indent">

Missing Information Reason:

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Missing_Information_GUID" Runat="server" DataSourceID="SqlDataSource_MissingInformation" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

<tr>

<td class="style-indent">

Reporter Confidential:

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Confidential_GUID" Runat="server" DataSourceID="SqlDataSource_Confidential" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

</table>

<br />

<telerik:RadTabStrip ID="RadTabStrip_Patient" runat="server" Width="100%">

<Tabs>

<telerik:RadTab runat="server" Text="Patient Data" Selected="true" ></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<table id="Table_Patient" class="style-table">

<tr>

<td class="style-indent">

Patient Identifier:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Patient_Identifier" runat="server" MaxLength="24" />

</td>

</tr>

<tr>

<td class="style-indent">

Age @ Time of Event:

</td>

<td>

<telerik:RadNumericTextBox ID="RadNumericTextBox_Age" Runat="server" MaxValue="999" Width="60px" NumberFormat-ZeroPattern="n" NumberFormat-DecimalDigits="0" MaxLength="3"/>

<telerik:RadComboBox ID="RadComboBox_Age_UOM_GUID" Runat="server" DataSourceID="SqlDataSource_AgeUOM" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="200px" />

</td>

</tr>

<tr>

<td class="style-indent">

Date of Birth:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_Of_Birth" runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Gender:

</td>

<td>

<telerik:RadComboBox Width="300px" ID="RadComboBox_Gender_GUID" Runat="server" DataSourceID="SqlDataSource_Gender" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" />

</td>

</tr>

<tr>

<td class="style-indent">

Weight (lbs/kgs):

</td>

<td>

<telerik:RadNumericTextBox ID="RadNumericTextBox_Weight" Runat="server" MaxValue="999" Width="60px" NumberFormat-ZeroPattern="n" NumberFormat-DecimalDigits="0" MaxLength="4" />

<telerik:RadComboBox ID="RadComboBox_Weight_UOM_GUID" Runat="server" DataSourceID="SqlDataSource_WeightUOM" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="200px" />

</td>

</tr>

<tr>

<td class="style-indent">

Patient Status:

</td>

<td>

<telerik:RadComboBox Width="500px" ID="RadComboBox_Patient_Status_GUID" Runat="server" DataSourceID="SqlDataSource_PS" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM SysComboBoxValues WHERE ComboBox = '' OR ComboBox = 'PS' ORDER BY CODE ASC" />

</td>

</tr>

</table>

<br />

<telerik:RadTabStrip ID="RadTabStrip_Events" runat="server" Width="100%">

<Tabs>

<telerik:RadTab runat="server" Text="Event Information" Selected="true" ></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<table id="Table9" class="style-table">

<tr>

<td class="style-indent">

Outcome:

</td>

<td>

<asp:CheckBox ID="RadCheckBox_Death" runat="server" Text="Death"

Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Death") %>' OnCheckedChanged="RadCheckBox_Death_CheckedChanged" AutoPostBack="True" />... if checked, indicate date:

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Death_Date" Enabled="false" runat="server" DbSelectedDate='<%# DataBinder.Eval( Container, "DataItem.Death_Date") %>' /><br />

<asp:CheckBox ID="RadCheckBox_LifeThreatening" Text="Life Threatening" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_LifeThreatening") %>'/><br />

<asp:CheckBox ID="RadCheckBox_Hospitalization" Text="Hospitalization" runat="server"

Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Hospitalization") %>' AutoPostBack="True" OnCheckedChanged="RadCheckBox_Hospitalization_CheckedChanged"/>, if checked indicate Date Hospitalized:

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_Hospitalized" runat="server" Enabled="False" />Date Discharged:

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_Discharged" runat="server" Enabled="False" />

<br />

<asp:CheckBox ID="RadCheckBox_Disability" Text="Disability" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_Disability") %>'/><br />

<asp:CheckBox ID="RadCheckBox_CongenitalAnomaly" Text="Congenital Anomaly" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_CongenitalAnomaly") %>'/><br />

<asp:CheckBox ID="RadCheckBox_OtherSerious" Text="Other Serious" runat="server" Checked='<%# DataBinder.Eval( Container, "DataItem.Flag_OtherSerious") %>'/><br />

</td>

</tr>

<tr>

<td class="style-indent">

Event Date:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Event_Date" runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Report Received Date:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Report_Received_Date" runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Day Zero:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Day_Zero" runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Describe Event/Problem:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Event_Description" Runat="server" Height="150px" Width="800px" TextMode="MultiLine" />

</td>

</tr>

<tr>

<td class="style-indent">

Relevant Tests/Laboratory Data: <br />

<div class="style-font-size-1">

<br />

(include dates)

</div>

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Relevant_Tests" Runat="server" Height="150px" Width="800px" TextMode="MultiLine"/>

</td>

</tr>

<tr>

<td class="style-indent">

Other Relevant History, including Medical Conditions: <br />

<div class="style-font-size-1">

<br />

(e.g. allergies, race, pregnancy, smoking and alcohol use, hepatic/renal dysfunction, etc.)

</div>

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Other_History" Runat="server" Height="150px" Width="800px" TextMode="MultiLine"/><br />

Allergies:

<asp:CheckBox ID="CheckBox_Allergies" runat="server" /> <br />

Hypertension:

<asp:CheckBox ID="CheckBox_HyperTension" runat="server" /> <br />

Diabetes:

<asp:CheckBox ID="CheckBox_Diabetes" runat="server" /> <br />

Hepatic Dysfunction:

<asp:CheckBox ID="CheckBox_Hepatic" runat="server" /> <br />

Renal Dysfunction:

<asp:CheckBox ID="CheckBox_Renal" runat="server" /> <br />

Cardiac:

<asp:CheckBox ID="CheckBox_Cardiac" runat="server" />

</td>

<tr>

<td class="style-indent">

Concomitant Products/Dates:<br />

<br />

<div class="style-font-size-1">

(exclude treatment of event)

</div>

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Concomitant" Runat="server" Height="150px" Width="800px" TextMode="MultiLine"/>

</td>

</tr>

<tr>

<td class="style-indent">

ADR Categories:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_ADR_Category_1_GUID" Runat="server" Enabled="false" DataSourceID="SqlDataSource_ADR1" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="200px"/>

<telerik:RadComboBox ID="RadComboBox_ADR_Category_2_GUID" Runat="server" Enabled="false" DataSourceID="SqlDataSource_ADR2" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="200px"/>

<telerik:RadComboBox ID="RadComboBox_ADR_Category_3_GUID" Runat="server" Enabled="false" DataSourceID="SqlDataSource_ADR3" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="200px"/>

</td>

</tr>

<tr>

<td class="style-indent">

Relationship To Drug:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Relationship_GUID" Runat="server" Enabled="false" DataSourceID="SqlDataSource_Relationship" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="250px"/>

</td>

</tr>

<tr>

<td class="style-indent">

Classification:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Classification_GUID" Runat="server" Enabled="false" DataSourceID="SqlDataSource_Classification" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="250px"/>

</td>

</tr>

<tr>

<td class="style-indent">

Physician Contact Info:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Physician" Runat="server" Height="150px" Width="800px" TextMode="MultiLine" />

</td>

</tr>

<tr>

<td class="style-indent">

Followup Required?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Followup_Required_GUID" Runat="server" Enabled="false" DataSourceID="SqlDataSource_Followup" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="250px" />

</td>

</tr>

</table>

<br />

<telerik:RadTabStrip ID="RadTabStrip_SuspectProducts" runat="server" Width="100%">

<Tabs>

<telerik:RadTab runat="server" Text="Suspect Products" Selected="true" ></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<table id="Table4" class="style-table">

<tr>

<td class="auto-style1-210">

</td>

<td class="auto-style1">

Product 1:

</td>

<td class="auto-style1">

Product 2:

</td>

</tr>

<tr>

<td class="style-indent">

Suspect Product:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Product_GUID1" Runat="server" DataSourceID="SqlDataSource_Products1" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Product_GUID2" Runat="server" DataSourceID="SqlDataSource_Products2" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

</tr>

<tr>

<td class="style-indent">

Packaging:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Packaging_GUID1" Runat="server" DataSourceID="SqlDataSource_Packaging1" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Packaging_GUID2" Runat="server" DataSourceID="SqlDataSource_Packaging2" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

</tr>

<tr>

<td class="style-indent">

Dose:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Dose1" Runat="server" MaxLength="24" />

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Dose2" Runat="server" MaxLength="24" />

</td>

</tr>

<tr>

<td class="style-indent">

Frequency:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Frequency1" Runat="server" MaxLength="24" />

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Frequency2" Runat="server" MaxLength="24" />

</td>

</tr>

<tr>

<td class="style-indent">

Route:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Route1_GUID" Runat="server" DataSourceID="SqlDataSource_C2a" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Route2_GUID" Runat="server" DataSourceID="SqlDataSource_C2b" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

</tr>

<tr>

<td class="style-indent">

Therapy Dates (Start/End):

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Therapy_Start1" Runat="server" />

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Therapy_End1" Runat="server" />

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Therapy_Start2" Runat="server" />

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Therapy_End2" Runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Therapy Duration:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Therapy_Duration1" Runat="server" MaxLength="24" />

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Therapy_Duration2" Runat="server" MaxLength="24" />

</td>

</tr>

<tr>

<td class="style-indent">

Indication:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Indication_GUID1" Runat="server" DataSourceID="SqlDataSource_Indication1" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Indication_GUID2" Runat="server" DataSourceID="SqlDataSource_Indication1" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="400px" />

</td>

</tr>

<tr>

<td class="style-indent">

Lot Number/ Expiration Date:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Lot_Number1" Runat="server" MaxLength="13" />

<telerik:RadMaskedTextBox ID="RadMaskedTextBox_Exp_Date_MM1" Runat="server" Width="30" Mask="##" />/

<telerik:RadMaskedTextBox ID="RadMaskedTextBox_Exp_Date_YYYY1" Runat="server" Width="40" Mask="####" />

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Lot_Number2" Runat="server" MaxLength="13" />

<telerik:RadMaskedTextBox ID="RadMaskedTextBox_Exp_Date_MM2" Runat="server" Width="30" Mask="##" />/

<telerik:RadMaskedTextBox ID="RadMaskedTextBox_Exp_Date_YYYY2" Runat="server" Width="40" Mask="####" />

</td>

</tr>

<tr>

<td class="style-indent">

NDC Number:

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_NDC_Number_GUID1" Runat="server" DataSourceID="SqlDataSource_NDC1" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_NDC_Number_GUID2" Runat="server" DataSourceID="SqlDataSource_NDC2" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

</tr>

<tr>

<td class="style-indent">

Event Abated?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Event_Abated_GUID1" Runat="server" DataSourceID="SqlDataSource_Abated1" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Event_Abated_GUID2" Runat="server" DataSourceID="SqlDataSource_Abated2" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

</tr>

<tr>

<td class="style-indent">

Event Reappeared?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Event_Reappeared_GUID1" Runat="server" DataSourceID="SqlDataSource_Reappeared1" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Event_Reappeared_GUID2" Runat="server" DataSourceID="SqlDataSource_Reappeared2" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

</tr>

</table>

<br />

<telerik:RadTabStrip ID="RadTabStrip_Complaint" runat="server" Width="100%">

<Tabs>

<telerik:RadTab runat="server" Text="Product Complaint" Selected="true" ></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<table id="TableComplaint" class="table-style">

<tr>

<td class="style-indent">

QA Involvement?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_QA_Involvement_GUID" Runat="server" DataSourceID="SqlDataSource_Involvement" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

</tr>

<tr>

<td class="style-indent">

Date QA Notified:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_QA_Notified" Runat="server"/>

</td>

</tr>

<tr>

<td class="style-indent">

Date QA Response:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_QA_Response" Runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Replacement Requested?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Replacement_Requested_GUID" Runat="server" DataSourceID="SqlDataSource_Replacement" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400" />

</td>

</tr>

<tr>

<td class="style-indent">

If 'Yes', Date of Replacement:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_Of_Replacement" Runat="server" />

</td>

</tr>

<tr>

<td class="style-indent">

Replacement Lot No:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Replacement_Lot_No" Runat="server" MaxLength="13" />

</td>

</tr>

<tr>

<td class="style-indent">

Replacement Lot Exp. Date:

</td>

<td>

<telerik:RadMaskedTextBox ID="RadNumericTextBox_Replacement_Exp_Date_MM" Runat="server" Width="30px" Mask="##" />/

<telerik:RadMaskedTextBox ID="RadNumericTextBox_Replacement_Exp_Date_YYYY" Runat="server" Width="40px" Mask="####" />

</td>

</tr>

<tr>

<td class="style-indent">

Refund Requested?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_Refund_Requested_GUID" Runat="server" DataSourceID="SqlDataSource_Refund" DataTextField="Code" DataValueField="sysComboBoxValues_GUID" Width="400"/>

</td>

</tr>

<tr>

<td class="style-indent">

If 'Yes', Date of Refund:

</td>

<td>

<telerik:RadDatePicker MinDate="01/01/1901" ID="RadDatePicker_Date_Of_Refund" Runat="server" />

</td>

</tr>

</table>

<br />

<telerik:RadTabStrip ID="RadTabStrip_DiaryComments" runat="server" Width="100%">

<Tabs>

<telerik:RadTab runat="server" Text="Diary/Comments" Selected="true" ></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<table id="Table8" class="style-table">

<tr>

<td class="style-indent">

Confidential?

</td>

<td>

<telerik:RadComboBox ID="RadComboBox_CommentConfidential" Runat="server" DataSourceID="SqlDataSource_CommConfidential" DataTextField="Description" DataValueField="sysComboBoxValues_GUID" Width="400px" />

<telerik:RadTextBox ID="RadTextBox_Role_GUID" runat="server" Visible="false" ReadOnly="true" />

</td>

</tr>

<tr>

<td class="style-indent">

Comments:

</td>

<td>

<telerik:RadTextBox ID="RadTextBox_Comment" Runat="server" Height="150px" Width="800px" TextMode="MultiLine" />

</td>

</tr>

</table>

<br />

<table>

<tr>

<td class="style-buttons-right">

<asp:Button ID="Button_Save" runat="server" Text="Save Record" OnClick="Button_Save_Click" />

</td>

<td> </td>

<td class="style-buttons-left">

<asp:Button ID="Button_Cancel" runat="server" Text="Cancel" OnClick="Button_Cancel_Click" />

</td>

</tr>

<tr>

<td colspan="2">

Please do not click SAVE more than once.

</td>

</tr>

</table>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C2' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C2' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C9' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C9' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY CODE "></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'TT' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'G3' OR ComboBox = '' ORDER BY Code" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'G7' OR ComboBox = '' ORDER BY Code" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code" />

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'UN' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'E3' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'MI' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'A2' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'A3' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'A4' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C1' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'PK' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'NA' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'NA' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C1' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'PK' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'NA' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'NA' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY CODE"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'B1' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'B2' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'AD' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'AD' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'AD' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'DR' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'CL' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'YN' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE (ComboBox = 'E0' OR ComboBox = '') AND DESCRIPTION <> 'ELECTRONIC' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C4' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

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

ConnectionString="<%$ ConnectionStrings:AEMSConnectionString %>" SelectCommand="SELECT * FROM sysComboBoxValues WHERE ComboBox = 'C4' OR ComboBox = '' ORDER BY Code"></

asp:SqlDataSource>

</form>

</body>

</html>

using System;

using System.Collections;

using System.Configuration;

using System.Web.UI.WebControls;

using Telerik.Web.UI;

using ToltingColt.Common;

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

{

private SQLReader rdr = new SQLReader(ConfigurationManager.ConnectionStrings["AEMSConnectionString"].ConnectionString.ToString());

protected void Page_Load(object sender, EventArgs e)

{

RadDatePicker_Report_Received_Date.SelectedDate = DateTime.Now;

Button_Save.Attributes.Remove("onclick");

Button_Save.Attributes.Add("onclick", "this.disabled=true;" + Page.ClientScript.GetPostBackEventReference(Button_Save, "").ToString());

}

protected void Button_Cancel_Click(Object o, EventArgs e)

{

Response.Redirect("MainMenu.aspx?m=Entry of new case has been cancelled!");

}

protected void Button_Save_Click(Object o, EventArgs e)

{

Guid hGuid = Guid.NewGuid();

String sAddedText = String.Empty;

if (CheckBox_Allergies.Checked) sAddedText += (sAddedText.Length > 0 ? ((char)10).ToString() : "") + "Allergies: YES";

if (CheckBox_Diabetes.Checked) sAddedText += (sAddedText.Length > 0 ? ((char)10).ToString() : "") + "Diabetes: YES";

if (CheckBox_Cardiac.Checked) sAddedText += (sAddedText.Length > 0 ? ((char)10).ToString() : "") + "Cardiac: YES";

if (CheckBox_Hepatic.Checked) sAddedText += (sAddedText.Length > 0 ? ((char)10).ToString() : "") + "Hepatic: YES";

if (CheckBox_Renal.Checked) sAddedText += (sAddedText.Length > 0 ? ((char)10).ToString() : "") + "Renal: YES";

if (CheckBox_HyperTension.Checked) sAddedText += (sAddedText.Length > 0 ? ((char)10).ToString() : "") + "Hypertension: YES";

String sSql =

"BEGIN TRANSACTION; " +

"DECLARE @RC varchar(50); " + String.Format(

"INSERT INTO Medwatch_Headers (RowGUID_Key) VALUES ('{0}'); ",

hGuid.ToString()) +

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-1'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO Medwatch_Patients (RowGUID_Key, Patient_Identifier, Date_Of_Birth, Age, Age_UOM_GUID, Gender_GUID, Weight, Weight_UOM_GUID, Patient_Status_GUID) "

+

" VALUES('{0}', '{1}', {2}, {3}, '{4}', '{5}', {6}, '{7}', '{8}'); ",

hGuid.ToString(), //0

RadTextBox_Patient_Identifier.Text,//1

Build(RadDatePicker_Date_Of_Birth),//2

Build(RadNumericTextBox_Age.Text), //3

Build(RadComboBox_Age_UOM_GUID),//4

Build(RadComboBox_Gender_GUID),//5

Build(RadNumericTextBox_Weight.Text),//6

Build(RadComboBox_Weight_UOM_GUID),//7

Build(RadComboBox_Patient_Status_GUID)) +

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-2'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO Medwatch_Events (RowGUID_Key, Death_Date, Event_Date, Event_Description, Relevant_Tests, Other_History, Concomitant, "

+

"ADR_Category_1_GUID, ADR_Category_2_GUID, ADR_Category_3_GUID, Relationship_GUID, Classification_GUID, Date_Hospitalized, "

+

"Date_Discharged, Physician, FollowUp_Required_GUID, Flag_Death, Flag_LifeThreatening, Flag_Hospitalization, Flag_Disability, "

+

"Flag_CongenitalAnomaly, Flag_OtherSerious, Report_Date, Date_Day_Zero) " +

"VALUES ('{0}', {1}, {2}, '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', {12}, {13}, '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', {22}, {23}); "

,

hGuid.ToString(), //0 RowGUID

Build(RadDatePicker_Death_Date), // 1 DEATH DATE

Build(RadDatePicker_Event_Date), // 2 EVENT DATE

RadTextBox_Event_Description.Text, // 3 EVENT DESCRIPTION

RadTextBox_Relevant_Tests.Text, // 4 RELEVANT TESTS

RadTextBox_Other_History.Text + sAddedText, //5 OTHER HISTORY

RadTextBox_Concomitant.Text, // 6 CONCOMITANT

Build(RadComboBox_ADR_Category_1_GUID), // 7 ADR CATEGORY 1

Build(RadComboBox_ADR_Category_2_GUID), // 8 ADR 2

Build(RadComboBox_ADR_Category_3_GUID), // 9 ADR 3

Build(RadComboBox_Relationship_GUID), // 10 RELATIONSHIP

Build(RadComboBox_Classification_GUID), // 11 CLASSIFICATION

Build(RadDatePicker_Date_Hospitalized), // 12

Build(RadDatePicker_Date_Discharged), //13

RadTextBox_Physician.Text, //14

Build(RadComboBox_Followup_Required_GUID), //15

RadCheckBox_Death.Checked.ToString(),//16

RadCheckBox_LifeThreatening.Checked.ToString(), // 17

RadCheckBox_Hospitalization.Checked.ToString(), // 18

RadCheckBox_Disability.Checked.ToString(), // 19

RadCheckBox_CongenitalAnomaly.Checked.ToString(), // 20

RadCheckBox_OtherSerious.Checked.ToString(), // 21

Build(RadDatePicker_Report_Received_Date), // 22

Build(RadDatePicker_Day_Zero)) + // 23

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-3'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO Medwatch_Reporters (RowGUID_Key, Reporter_Name, Reporter_Telephone, Reporter_Relationship, Reporter_Status_GUID, Reporter_Title_GUID, Initial_Reporter_GUID, "

+

"Confidential_GUID, Missing_Information_GUID, Reporter_Origin_GUID, Flag_Foreign, Flag_Study, Flag_Literature, " +

"Flag_Consumer, Flag_HealthProfessional, Flag_UserFacility, Flag_CompanyRep, Flag_Distributor, Flag_Other, Report_Source_Other) "

+

"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}'); "

,

hGuid.ToString(),

RadTextBox_Reporter_Name.Text,

RadTextBox_Reporter_Telephone.Text,

RadTextBox_Reporter_Relationship.Text,

Build(RadComboBox_Reporter_Status_GUID),

Build(RadComboBox_Reporter_Title_GUID),

Build(RadComboBox_Initial_Reporter_GUID),

Build(RadComboBox_Confidential_GUID),

Build(RadComboBox_Missing_Information_GUID),

Build(RadComboBox_Reporter_Origin_GUID),

RadCheckBox_Foreign.Checked.ToString(),

RadCheckBox_Study.Checked.ToString(),

RadCheckBox_Literature.Checked.ToString(),

RadCheckBox_Consumer.Checked.ToString(),

RadCheckBox_HealthProfessional.Checked.ToString(),

RadCheckBox_UserFacility.Checked.ToString(),

RadCheckBox_CompanyRep.Checked.ToString(),

RadCheckBox_Distributor.Checked.ToString(),

RadCheckBox_Other.Checked.ToString(),

RadTextBox_Report_Source_Other.Text) +

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-4'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO Medwatch_Manufacturers (RowGUID_Key, Date_Mfg_Report) " +

"VALUES ('{0}', {1}); ",

hGuid.ToString(), //0

Build(RadDatePicker_Report_Received_Date)) +

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-5'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO Medwatch_Comments (RowGUID_Key, FK_Header_GUID, Role_GUID, Confidential_GUID, Comment) " +

" VALUES (NEWID(), '{0}', dbo.udf_GetComboBoxGUIDByCode('RL', 'Specialist'), '{1}', '{2}'); ",

hGuid.ToString(),

Build(RadComboBox_CommentConfidential),

RadTextBox_Comment.Text) +

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-6'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO Medwatch_QA (RowGUID_Key, QA_Involvement_GUID, Date_QA_Notified, Date_QA_Response, Replacement_Requested_GUID, Date_Of_Replacement, "

+

"Replacement_Lot_No, Replacement_Exp_Date_MM, Replacement_Exp_Date_YYYY, Refund_Requested_GUID, Date_Of_Refund) " +

"VALUES ('{0}', '{1}', {2}, {3}, '{4}', {5}, '{6}', '{7}', '{8}', '{9}', {10}); ",

hGuid.ToString(), //0

Build(RadComboBox_QA_Involvement_GUID),

Build(RadDatePicker_Date_QA_Notified),

Build(RadDatePicker_Date_QA_Response),

Build(RadComboBox_Replacement_Requested_GUID),

Build(RadDatePicker_Date_Of_Replacement),

RadTextBox_Replacement_Lot_No.Text,//6

RadNumericTextBox_Replacement_Exp_Date_MM.Text,//7

RadNumericTextBox_Replacement_Exp_Date_YYYY.Text,//8

Build(RadComboBox_Refund_Requested_GUID),

Build(RadDatePicker_Date_Of_Refund)) +//10

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-7'; GOTO ERROLL; END; " + String.Format(

"INSERT INTO MEDWATCH_PRODUCTS (ROWGUID_KEY, FK_HEADER_GUID, PRODUCT_GUID, PACKAGING_GUID, DOSE, FREQUENCY, ROUTE_GUID, THERAPY_START, THERAPY_END, THERAPY_DURATION, "

+

" INDICATION_GUID, LOT_NUMBER, EXP_DATE_MM, EXP_DATE_YYYY, NDC_NUMBER_GUID, EVENT_ABATED_GUID, EVENT_REAPPEARED_GUID) " +

"VALUES (NEWID(), '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, {7}, '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}'); "

,

hGuid.ToString(), //0

Build(RadComboBox_Product_GUID1),//1

Build(RadComboBox_Packaging_GUID1),//2

RadTextBox_Dose1.Text, //3

RadTextBox_Frequency1.Text,//4

Build(RadComboBox_Route1_GUID), //5

Build(RadDatePicker_Therapy_Start1),//6

Build(RadDatePicker_Therapy_End1),//7

RadTextBox_Therapy_Duration1.Text, //8

Build(RadComboBox_Indication_GUID1),//9

RadTextBox_Lot_Number1.Text, //10

RadMaskedTextBox_Exp_Date_MM1.Text, //11

RadMaskedTextBox_Exp_Date_YYYY1.Text, //12

Build(RadComboBox_NDC_Number_GUID1),//13

Build(RadComboBox_Event_Abated_GUID1),//14

Build(RadComboBox_Event_Reappeared_GUID1)) +//15

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-8'; GOTO ERROLL; END; ";

Boolean isProduct2 = false;

if

((RadComboBox_Product_GUID2.SelectedValue.ToString().Length > 0 && RadComboBox_Product_GUID2.SelectedValue.ToString() !=

"00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if

((RadComboBox_Packaging_GUID2.SelectedValue.ToString().Length > 0 && RadComboBox_Packaging_GUID2.SelectedValue.ToString() !=

"00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if (RadTextBox_Dose2.Text.Length > 0) isProduct2 = true;

if (RadTextBox_Frequency2.Text.Length > 0) isProduct2 = true;

if ((RadComboBox_Route2_GUID.SelectedValue.ToString().Length > 0 && RadComboBox_Route2_GUID.SelectedValue.ToString() != "00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if (RadDatePicker_Therapy_Start2.DbSelectedDate != null && RadDatePicker_Therapy_Start2.DbSelectedDate.ToString().Length > 0) isProduct2 = true;

if (RadDatePicker_Therapy_End2.DbSelectedDate != null && RadDatePicker_Therapy_End2.DbSelectedDate.ToString().Length > 0) isProduct2 = true;

if (RadTextBox_Therapy_Duration2.Text.Length > 0) isProduct2 = true;

if

((RadComboBox_Indication_GUID2.SelectedValue.ToString().Length > 0 && RadComboBox_Indication_GUID2.SelectedValue.ToString() !=

"00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if (RadTextBox_Lot_Number2.Text.Length > 0) isProduct2 = true;

if (RadMaskedTextBox_Exp_Date_MM2.Text.Length > 0) isProduct2 = true;

if (RadMaskedTextBox_Exp_Date_YYYY2.Text.Length > 0) isProduct2 = true;

if

((RadComboBox_NDC_Number_GUID2.SelectedValue.ToString().Length > 0 && RadComboBox_NDC_Number_GUID2.SelectedValue.ToString() !=

"00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if

((RadComboBox_Event_Abated_GUID2.SelectedValue.ToString().Length > 0 && RadComboBox_Event_Abated_GUID2.SelectedValue.ToString() !=

"00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if

((RadComboBox_Event_Reappeared_GUID2.SelectedValue.ToString().Length > 0 && RadComboBox_Event_Reappeared_GUID2.SelectedValue.ToString() !=

"00000000-0000-0000-0000-000000000000")) isProduct2 = true;

if (isProduct2)

sSql += String.Format(

"INSERT INTO MEDWATCH_PRODUCTS (ROWGUID_KEY, FK_HEADER_GUID, PRODUCT_GUID, PACKAGING_GUID, DOSE, FREQUENCY, ROUTE_GUID, THERAPY_START, THERAPY_END, THERAPY_DURATION, "

+

" INDICATION_GUID, LOT_NUMBER, EXP_DATE_MM, EXP_DATE_YYYY, NDC_NUMBER_GUID, EVENT_ABATED_GUID, EVENT_REAPPEARED_GUID) " +

"VALUES (NEWID(), '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, {7}, '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}'); "

,

hGuid.ToString(),

Build(RadComboBox_Product_GUID2),

Build(RadComboBox_Packaging_GUID2),

RadTextBox_Dose2.Text,

RadTextBox_Frequency2.Text,

Build(RadComboBox_Route2_GUID),

Build(RadDatePicker_Therapy_Start2),

Build(RadDatePicker_Therapy_End2),

RadTextBox_Therapy_Duration2.Text,

Build(RadComboBox_Indication_GUID2),

RadTextBox_Lot_Number2.Text,

RadMaskedTextBox_Exp_Date_MM2.Text,

RadMaskedTextBox_Exp_Date_YYYY2.Text,

Build(RadComboBox_NDC_Number_GUID2),

Build(RadComboBox_Event_Abated_GUID2),

Build(RadComboBox_Event_Reappeared_GUID2)) +

"IF @@ROWCOUNT <> 1 BEGIN ROLLBACK TRANSACTION; SET @RC = '-9'; GOTO ERROLL; END; ";

sSql += "COMMIT TRANSACTION; " +

"SET @RC = (SELECT TOP 1 File_Number FROM Medwatch_Headers WHERE RowGUID_Key = '" + hGuid.ToString() + "'); " +

"GOTO EOJ " +

"ERROLL: " +

"ROLLBACK TRANSACTION; " +

"EOJ: " +

"SELECT @RC AS RC;";

Response.Write(sSql);

}

protected void RadCheckBox_Other_CheckedChanged(object sender, EventArgs e)

{

if (RadCheckBox_Other.Checked)

{

RadTextBox_Report_Source_Other.Enabled = true;

RadTextBox_Report_Source_Other.ReadOnly = false;

RadTextBox_Report_Source_Other.Focus();

}

protected void RadCheckBox_Death_CheckedChanged(object sender, EventArgs e)

{

if (RadCheckBox_Death.Checked)

{

RadDatePicker_Death_Date.Enabled = true;

RadDatePicker_Death_Date.Focus();

}

else

RadDatePicker_Death_Date.Enabled = false;

}

protected void RadCheckBox_Hospitalization_CheckedChanged(object sender, EventArgs e)

{

if (RadCheckBox_Hospitalization.Checked)

{

RadDatePicker_Date_Discharged.Enabled = RadDatePicker_Date_Hospitalized.Enabled = true;

RadDatePicker_Date_Hospitalized.Focus();

}

else

RadDatePicker_Date_Discharged.Enabled = RadDatePicker_Date_Hospitalized.Enabled = false;

}

private String Build(Object obj)

{

String rc = String.Empty;

switch (obj.ToString())

{

case "Telerik.Web.UI.RadDatePicker":

rc = ((RadDatePicker)obj).SelectedDate == null ? "NULL" : "'" + ((RadDatePicker)obj).SelectedDate.ToString() + "'";

break;

case "Telerik.Web.UI.RadComboBox":

rc = ((RadComboBox)obj).SelectedValue == null ? "00000000-0000-0000-0000-000000000000" : ((RadComboBox)obj).SelectedValue.ToString();

break;

case "System.Web.UI.WebControls.DropDownList":

rc = ((DropDownList)obj).SelectedValue == null ? "00000000-0000-0000-0000-000000000000" : ((DropDownList)obj).SelectedValue.ToString();

break;

default:

rc = obj.ToString() == "" ? "NULL" : "'" + obj.ToString() + "'";

break;

}

return rc;

}

answered on 26 Apr 2013, 11:10 AM

Hi Michael,

The code snippet is too complicated with many missing dependencies and it does not allow us to replicated this behavior. The output also doesn't provide much information as we cannot inspect the css. Please provide us with link to the page where we can see and inspect this issue as its shown on the testform.png screenshot, or create a new support ticket and attach runnable sample demonstrating the problem.

Regards,
Hristo Valyavicharski
the Telerik team

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.

answered on 26 Apr 2013, 12:58 PM

There is no separate user-generated .CSS file for these pages.

What you see in the ASPX and ASPX.CS generates the HTML output sent to the client, which does not work and generates the screen shot indicated). The attached HTML code was directly obtained by doing a "View Source" within IE for the generated page, so I'm not sure what else you would require.

If there are CSS files which the Telerik controls use and install automatically as part of the application deployment, none of those have been modified from their Telerik-supplied defaults.

This application sits on an internal company intranet and is not accessible to the outside world.

My "solution" has been to dump the telerik controls and go back to using the standard ASP.NET dropdown control, which works without issue.

answered on 26 Apr 2013, 04:05 PM

This is what worked for me. Instead of using the page load event since that isn't fired during my scenerio (my RadComboBox is dynamically generated in the EditForm while in PopupMode). I had to use the window.onscroll event

window.onscroll =
function onPagescroll() {

var combos = Telerik.Web.UI.RadComboBox.ComboBoxes;
if (combos != null)
     {
        for (var i = 0; i < combos.length; i++) {
                var combo = combos[i];
                    if (combo.get_dropDownVisible())
                         combo.hideDropDown();
                }
     }
};
to make drop down collapse during scrolling.

Tamara

answered on 29 May 2013, 02:28 PM

I have solved this problem.

After many long hours of work, I determined the problem was caused by versions of IE having "compatibility mode" turned on (this was a requirement by the client as they have web sites used by their staff which require compatibility mode on in order to function correctly.)

Once I added the following meta tag to my telerik ASPX pages:

<meta http-equiv="X-UA-Compatible" content="IE=edge" />

The RadComboBoxes rendered correctly.

So, for anyone experiencing the same problem, try turning compatibility mode "off" in versions of IE9+