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

AJAX requests causing scroll to top of page

3 Answers 167 Views

Ajax

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

Brad asked on 20 May 2011, 12:41 AM

I have a page in development that is basically a large hierarchical radgrid. What is happening is any sort of AJAX request is causing the page to scroll to the top. The loading panel is also not working. Please help!

Also, please note that there is a script manager inside the "DashboardSelector" user control.

ASP:

<%@ Page Title="" Language="VB" MasterPageFile="~/All/Site.master" EnableEventValidation="false" AutoEventWireup="false" CodeFile="Orders.aspx.vb" Inherits="Management_Dashboard_AllOrders" %>

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

<%@ Register src="../../Controls/DashboardSelector.ascx" tagname="DashboardSelector" tagprefix="uc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"

MinDisplayTime="5" Skin="Default" Transparency="20">

</telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxManager ID="RadAjaxManager" runat="server"

DefaultLoadingPanelID="RadAjaxLoadingPanel1">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="OrdersGrid">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="OrdersGrid"

LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<uc1:DashboardSelector ID="DashboardSelector1" runat="server" />

<h4>New Orders</h4>

<telerik:RadButton ID="btnExportToExcel" runat="server"

Text="Export to Excel">

</telerik:RadButton>

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

AllowPaging="True" DataSourceID="GPOrderHeadersDataSource" GridLines="None"

Skin="Telerik" AllowSorting="True" ShowGroupPanel="True">

<ExportSettings FileName="OrdersExport" IgnorePaging="True"

ExportOnlyData="True">

<Excel Format="ExcelML" />

<Excel Format="ExcelML"></Excel>

</ExportSettings>

<ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True"

ReorderColumnsOnClient="True">

</ClientSettings>

<MasterTableView AutoGenerateColumns="False" DataKeyNames="SOPNUMBE"

DataSourceID="GPOrderHeadersDataSource" PageSize="50">

<DetailTables>

<telerik:GridTableView runat="server" DataKeyNames="SOPNUMBE"

AllowFilteringByColumn="False" AllowPaging="False" AutoGenerateColumns="False"

DataSourceID="DetailsDataSource">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="SOPNUMBE"

MasterKeyField="SOPNUMBE" />

</ParentTableRelation>

<CommandItemSettings ExportToPdfText="Export to Pdf" />

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

<Columns>

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

SortExpression="SOPNUMBE" UniqueName="SOPNUMBE" Visible="False">

</telerik:GridBoundColumn>

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

SortExpression="ITMSHNAM" UniqueName="ITMSHNAM">

</telerik:GridBoundColumn>

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

SortExpression="ITEMDESC" UniqueName="ITEMDESC">

</telerik:GridBoundColumn>

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

SortExpression="STATUS" UniqueName="STATUS">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Qty" DataFormatString="{0:0}"

DataType="System.Double" HeaderText="Qty" SortExpression="Qty" UniqueName="Qty">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ATYALLOC" DataFormatString="{0:0}"

DataType="System.Double" HeaderText="ATYALLOC" SortExpression="ATYALLOC"

UniqueName="ATYALLOC">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="QTYFULFI" DataFormatString="{0:0}"

DataType="System.Double" HeaderText="QTYFULFI" SortExpression="QTYFULFI"

UniqueName="QTYFULFI">

</telerik:GridBoundColumn>

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

SortExpression="LOCNCODE" UniqueName="LOCNCODE">

</telerik:GridBoundColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<CommandItemSettings ExportToPdfText="Export to Pdf" ShowAddNewRecordButton="False"

ShowExportToExcelButton="True" ShowExportToPdfButton="True"></CommandItemSettings>

<ExpandCollapseColumn Visible="True">

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn UniqueName="Color"

AllowFiltering="False" Groupable="False">

<ItemTemplate>

<telerik:RadComboBox ID="cboColorChanger" Runat="server" AutoPostBack="True"

DataTextField="Color" DataValueField="SOPNUMBE"

onselectedindexchanged="cboColorChanger0_SelectedIndexChanged"

SelectedValue='<%# GetColor() %>' Skin="Telerik" Width="65px" >

<Items>

<telerik:RadComboBoxItem runat="server" Owner="cboColorChanger" Text="None"

Value="None" />

<telerik:RadComboBoxItem runat="server" BackColor="Red" ForeColor="Red"

Owner="cboColorChanger" Text="Red" Value="Red" />

<telerik:RadComboBoxItem runat="server" BackColor="#FF8000" ForeColor="#FF8000"

Owner="cboColorChanger" Text="Orange" Value="Orange" />

<telerik:RadComboBoxItem runat="server" BackColor="Yellow" ForeColor="Yellow"

Owner="cboColorChanger" Text="Yellow" Value="Yellow" />

<telerik:RadComboBoxItem runat="server" BackColor="Lime" ForeColor="Lime"

Owner="cboColorChanger" Text="Green" Value="Green" />

<telerik:RadComboBoxItem runat="server" BackColor="Cyan" ForeColor="Cyan"

Owner="cboColorChanger" Text="Blue" Value="Blue" />

<telerik:RadComboBoxItem runat="server" BackColor="Fuchsia" ForeColor="Fuchsia"

Owner="cboColorChanger" Text="Pink" Value="Pink" />

</Items>

</telerik:RadComboBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

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

ReadOnly="True" SortExpression="CUSTNMBR" UniqueName="CUSTNMBR"

HeaderTooltip="Customer Number">

</telerik:GridBoundColumn>

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

ReadOnly="True" SortExpression="CUSTNAME" UniqueName="CUSTNAME"

Visible="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SOPNUMBE" HeaderText="SOP"

ReadOnly="True" SortExpression="SOPNUMBE" UniqueName="SOPNUMBE"

HeaderTooltip="SOP Number">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PO" HeaderText="PO" ReadOnly="True"

SortExpression="PO" UniqueName="PO">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ReqShipDate"

DataFormatString="{0:MM/dd/yyyy}" HeaderText="RSD" ReadOnly="True"

SortExpression="ReqShipDate" UniqueName="ReqShipDate"

HeaderTooltip="Required Ship Date">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ORDRDATE" DataFormatString="{0:MM/dd/yyyy}"

HeaderText="OD" ReadOnly="True" SortExpression="ORDRDATE"

UniqueName="ORDRDATE" HeaderTooltip="Order Date">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CITY" HeaderText="CITY" ReadOnly="True"

SortExpression="CITY" UniqueName="CITY">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="STATE" HeaderText="ST" ReadOnly="True"

SortExpression="STATE" UniqueName="STATE"

HeaderTooltip="State">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DOCID" HeaderText="DOCID" ReadOnly="True"

SortExpression="DOCID" UniqueName="DOCID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OREMSUBT" DataFormatString="{0:C}"

HeaderText="OREMSUBT" ReadOnly="True" SortExpression="OREMSUBT"

UniqueName="OREMSUBT" HeaderTooltip="Original Remaining Subtotal">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="NumLines" DataType="System.Int32"

HeaderText="NL" ReadOnly="True" SortExpression="NumLines"

UniqueName="NumLines"

HeaderTooltip="Number of Lines">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn AllowFiltering="False" Groupable="False"

HeaderText="Notes" Reorderable="False" UniqueName="Notes" Visible="False">

<%--<ItemTemplate>

<table style="border-width: 0px; border-style: none; text-align: center;">

<tr><td>

<telerik:RadTextBox ID="txtNotes" Runat="server" Height="50px" Skin="Telerik"

Text="<%# GetNotes() %>" TextMode="MultiLine" Width="250px">

</telerik:RadTextBox>

</td></tr>

<tr><td>

<telerik:RadButton ID="btnUpdateNotes" runat="server" Skin="Telerik"

Text="Update Notes" onclick="btnUpdateNotes_Click">

</telerik:RadButton>

</td></tr>

</table>

</ItemTemplate>--%>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" HeaderText="Note"

Resizable="False" UniqueName="Notes Icon">

<ItemTemplate>

<asp:Panel ID="NotesPanel" Visible="true" runat="server">

<asp:ImageButton ID="imgNote" runat="server" AlternateText="<%# GetNotes() %>"

ImageUrl="<%# NoteImage() %>" onclick="ImageButton1_Click"

ToolTip="<%# GetNotes() %>" />

</asp:Panel>

<asp:Panel ID="EditNotesPanel" Visible="false" runat="server">

<table style="border-width: 0px; border-style: none; text-align: center;">

<tr><td>

<telerik:RadTextBox ID="txtNotes" Runat="server" Height="50px" Skin="Telerik"

Text="<%# GetNotes() %>" TextMode="MultiLine" Width="250px">

</telerik:RadTextBox>

</td></tr>

<tr><td>

<telerik:RadButton ID="btnUpdateNotes" runat="server" Skin="Telerik"

Text="Update Notes" onclick="btnUpdateNotes_Click">

</telerik:RadButton>

</td></tr>

</table>

</asp:Panel>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<PagerStyle Mode="NextPrevNumericAndAdvanced" />

</MasterTableView>

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

</telerik:RadGrid>

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

ConnectionString="<%$ ConnectionStrings:OrdersConString %>" SelectCommand="SELECT        RTRIM(SOP10100.CUSTNAME) AS CUSTNAME, RTRIM(SOP10100.SOPNUMBE) AS SOPNUMBE, RTRIM(SOP10100.CSTPONBR) AS PO,

(SOP10100.ReqShipDate) AS ReqShipDate, (SOP10100.ORDRDATE) AS ORDRDATE, RTRIM(SOP10100.CITY) AS CITY, RTRIM(SOP10100.STATE)

AS STATE, RTRIM(SOP10100.CUSTNMBR) AS CUSTNMBR, RTRIM(SOP10100.DOCID) AS DOCID, (SOP10100.OREMSUBT) AS OREMSUBT,

COUNT(SOP10200.ITEMNMBR) AS NumLines

FROM SOP10100 INNER JOIN

SOP10200 ON SOP10100.SOPNUMBE = SOP10200.SOPNUMBE AND SOP10100.SOPTYPE = SOP10200.SOPTYPE

WHERE        (SOP10100.CUSTNMBR NOT LIKE 'WALCANA') AND (SOP10100.CUSTNMBR NOT LIKE 'WALMART') AND (SOP10100.SOPTYPE = 2) AND VOIDSTTS = 0

GROUP BY RTRIM(SOP10100.CUSTNAME), RTRIM(SOP10100.SOPNUMBE), RTRIM(SOP10100.CSTPONBR), (SOP10100.ReqShipDate), (SOP10100.ORDRDATE),

RTRIM(SOP10100.CITY), RTRIM(SOP10100.STATE), RTRIM(SOP10100.CUSTNMBR), RTRIM(SOP10100.DOCID), (SOP10100.OREMSUBT)

ORDER BY RTRIM(SOP10100.CUSTNAME)"></asp:SqlDataSource>

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

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

SelectCommand="SELECT RTRIM(SOP10100.SOPNUMBE) AS SOPNUMBE, RTRIM(IV00101.ITMSHNAM) AS ITMSHNAM, RTRIM(SOP10200.ITEMDESC) AS ITEMDESC, RTRIM(IV00101.USCATVLS_5) AS STATUS, ROUND(SOP10200.QTYREMAI,0) AS Qty, ROUND(SOP10200.ATYALLOC,0) AS ATYALLOC, ROUND(SOP10200.QTYFULFI,0) AS QTYFULFI, RTRIM(SOP10200.LOCNCODE) AS LOCNCODE FROM SOP10200 INNER JOIN IV00101 ON SOP10200.ITEMNMBR = IV00101.ITEMNMBR INNER JOIN SOP10100 ON SOP10200.SOPNUMBE = SOP10100.SOPNUMBE AND SOP10200.SOPTYPE = SOP10100.SOPTYPE WHERE (SOP10100.CUSTNMBR NOT LIKE 'WALCANA') AND (SOP10100.CUSTNMBR NOT LIKE 'WALMART') AND (SOP10200.SOPTYPE = 2) AND (SOP10100.VOIDSTTS = 0) AND (SOP10100.SOPNUMBE = @SOPNUMBE) ORDER BY SOPNUMBE DESC">

<SelectParameters>

<asp:Parameter Name="SOPNUMBE" />

</SelectParameters>

</asp:SqlDataSource>

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

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

SelectCommand="SELECT * FROM [OrdersTableRowColor]"></asp:SqlDataSource>

<telerik:RadWindowManager ID="RadWindowManager1" runat="server" Skin="Black">

<Windows>

<telerik:RadWindow ID="NotesWindow" runat="server" Animation="Fade"

AutoSize="True" EnableShadow="True" KeepInScreenBounds="True" Skin="Telerik"

style="display:none;" VisibleStatusbar="False" DestroyOnClose="True"

Overlay="True" Title="Update Note" Behavior="Close" Behaviors="Close"

Modal="True">

</telerik:RadWindow>

</Windows>

</telerik:RadWindowManager>

</asp:Content>

Code Behind:

Imports Telerik.Web.UI

Imports System.Data

Imports System.Data.SqlClient

Partial Class Management_Dashboard_AllOrders

Inherits System.Web.UI.Page

Dim conString As String = "Data Source=PDC-SQL1;Initial Catalog=Intranet;Integrated Security=True"

Dim conn As SqlConnection = New SqlConnection(conString)

Dim notesURL As String = "images/Note.png"

Dim noNotesURL As String = "images/noNote.png"

Protected Sub RadButton1_Click(sender As Object, e As System.EventArgs) Handles btnExportToExcel.Click

OrdersGrid.MasterTableView.ExportToExcel()

End Sub

Protected Function GetNotes() As String

Dim getTheNotes As SqlCommand = New SqlCommand("SELECT Notes FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim notes As String = ""

Dim s As String = ""

Try

s = Eval("SOPNUMBE")

Catch

Try

s = Session("SOP")

Catch

End Try

Try

getTheNotes.Connection.Open()

getTheNotes.Parameters.AddWithValue("@sopnumbe", s)

notes = If(TypeOf getTheNotes.ExecuteScalar() Is DBNull, "", getTheNotes.ExecuteScalar())

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

getTheNotes.Connection.Close()

End Try

If notes <> Nothing Then

Return notes

Else

Return ""

End If

End Function

Protected Function GetColor() As String

Dim getTheColor As SqlCommand = New SqlCommand("SELECT color FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim col As String = ""

Try

getTheColor.Connection.Open()

getTheColor.Parameters.AddWithValue("@sopnumbe", Eval("SOPNUMBE").ToString)

col = getTheColor.ExecuteScalar()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

getTheColor.Connection.Close()

End Try

If col <> Nothing Then

Return col

Else

Return "None"

End If

End Function

Protected Sub ColorRow(ByVal r As GridDataItem, col As String)

Select Case col

Case "None"

r.BackColor = Drawing.Color.Empty

Case "Red"

r.BackColor = Drawing.Color.Red

Case "Orange"

r.BackColor = Drawing.Color.Orange

Case "Yellow"

r.BackColor = Drawing.Color.Yellow

Case "Green"

r.BackColor = Drawing.Color.Lime

Case "Blue"

r.BackColor = Drawing.Color.Cyan

Case "Pink"

r.BackColor = Drawing.Color.Fuchsia

Case Else

r.BackColor = Drawing.Color.Empty

End Select

End Sub

Protected Sub cboColorChanger0_SelectedIndexChanged(sender As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs)

Dim color As String = CType(sender, RadComboBox).SelectedValue

Dim r As GridDataItem = CType(sender.parent.parent, GridDataItem)

Dim sop As String = r("SOPNUMBE").Text

Dim colorPresent As SqlCommand = New SqlCommand("SELECT * FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim getColor As SqlCommand = New SqlCommand("SELECT color FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim insertColor As SqlCommand = New SqlCommand("INSERT INTO [OrdersTableEX] ([SOPNUMBE],[color]) VALUES (@sopnumbe,@col)", conn)

Dim updateColor As SqlCommand = New SqlCommand("UPDATE [OrdersTableEX] SET [color] = @col WHERE SOPNUMBE = @sopnumbe", conn)

colorPresent.Parameters.AddWithValue("@sopnumbe", sop)

Dim present As String = ""

Try

colorPresent.Connection.Open()

present = colorPresent.ExecuteScalar()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

colorPresent.Connection.Close()

End Try

If present <> sop Then

Try

insertColor.Connection.Open()

insertColor.Parameters.AddWithValue("@sopnumbe", sop)

insertColor.Parameters.AddWithValue("@col", color)

insertColor.ExecuteNonQuery()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

insertColor.Connection.Close()

End Try

Else

Try

updateColor.Connection.Open()

updateColor.Parameters.AddWithValue("@col", color)

updateColor.Parameters.AddWithValue("@sopnumbe", sop)

updateColor.ExecuteNonQuery()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

updateColor.Connection.Close()

End Try

End If

Dim col As String = ""

Try

getColor.Connection.Open()

getColor.Parameters.AddWithValue("@sopnumbe", sop)

col = getColor.ExecuteScalar()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

getColor.Connection.Close()

End Try

ColorRow(r, col)

End Sub

Protected Sub OrdersGrid_DataBound(sender As Object, e As System.EventArgs) Handles OrdersGrid.DataBound

For Each r As GridDataItem In OrdersGrid.Items

ColorRow(r, CType(r("Color").FindControl("cboColorChanger"), RadComboBox).SelectedValue)

Next

End Sub

Protected Sub btnUpdateNotes_Click(sender As Object, e As System.EventArgs)

Dim notes As String = CType(CType(sender.parent.parent, GridTableCell).FindControl("txtNotes"), RadTextBox).Text

Dim r As GridDataItem = CType(sender.parent.parent.parent, GridDataItem)

Dim sop As String = r("SOPNUMBE").Text

Dim colorPresent As SqlCommand = New SqlCommand("SELECT * FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim getNotes As SqlCommand = New SqlCommand("SELECT Notes FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim insertNotes As SqlCommand = New SqlCommand("INSERT INTO [OrdersTableEX] ([SOPNUMBE],[Notes]) VALUES (@sopnumbe,@col)", conn)

Dim updateNotes As SqlCommand = New SqlCommand("UPDATE [OrdersTableEX] SET [Notes] = @col WHERE SOPNUMBE = @sopnumbe", conn)

colorPresent.Parameters.AddWithValue("@sopnumbe", sop)

Dim present As String = ""

Try

colorPresent.Connection.Open()

present = colorPresent.ExecuteScalar()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

colorPresent.Connection.Close()

End Try

If present <> sop Then

Try

insertNotes.Connection.Open()

insertNotes.Parameters.AddWithValue("@sopnumbe", sop)

insertNotes.Parameters.AddWithValue("@col", notes)

insertNotes.ExecuteNonQuery()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

insertNotes.Connection.Close()

End Try

Else

Try

updateNotes.Connection.Open()

updateNotes.Parameters.AddWithValue("@col", notes)

updateNotes.Parameters.AddWithValue("@sopnumbe", sop)

updateNotes.ExecuteNonQuery()

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

updateNotes.Connection.Close()

End Try

End If

CType(CType(sender.parent.parent, GridTableCell).FindControl("NotesPanel"), Panel).Visible = True

CType(CType(sender.parent.parent, GridTableCell).FindControl("EditNotesPanel"), Panel).Visible = False

Session("SOP") = sop

CType(CType(sender.parent.parent, GridTableCell).FindControl("imgNote"), ImageButton).DataBind()

End Sub

Protected Function NoteImage() As String

Dim getTheNotes As SqlCommand = New SqlCommand("SELECT Notes FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn)

Dim notes As String = ""

Dim s As String = ""

Try

s = Eval("SOPNUMBE")

Catch

Try

s = Session("SOP")

Catch

End Try

Try

getTheNotes.Connection.Open()

getTheNotes.Parameters.AddWithValue("@sopnumbe", s)

notes = If(TypeOf getTheNotes.ExecuteScalar() Is DBNull, "", getTheNotes.ExecuteScalar())

Catch

MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR")

Finally

getTheNotes.Connection.Close()

End Try

If notes <> Nothing Then

Return notesURL

Else

Return noNotesURL

End If

End Function

Protected Sub ImageButton1_Click(sender As Object, e As System.Web.UI.ImageClickEventArgs)

Dim r As GridDataItem = CType(sender.parent.parent.parent, GridDataItem)

Dim c As GridTableCell = CType(sender.parent.parent, GridTableCell)

CType(c.FindControl("NotesPanel"), Panel).Visible = False

CType(c.FindControl("EditNotesPanel"), Panel).Visible = True

'RadWindowManager1.Windows(0).NavigateUrl = "notesEditor.aspx?SOP=" + r("SOPNUMBE").Text

'RadWindowManager1.Windows(0).VisibleOnPageLoad = True

End Sub

Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load

If IsPostBack Then

RadWindowManager1.Windows(0).VisibleOnPageLoad = False

End If

End Sub

End Class

3 Answers, 1 is accepted

answered on 24 May 2011, 04:42 PM

I read through the article but it did not seem to fix my issue.

After using the site a bit more, I'm realizing that none of my ajax requests are firing properly, they are all doing full postbacks. I have a master/content page setup. I have a script manager and ajax manager on my master page, and proxy ajax managers on each of the content pages. Could you possibly take a look through and check to make sure my ajax manager is setup properly.

Master page:

<%@ Master Language="VB" AutoEventWireup="false" CodeFile="Site.Master.vb" Inherits="Site" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

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

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

<head runat="server">

<title>Echo Bridge Entertainment</title>

<link rel="shortcut icon" href="../favicon.ico" />

<link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />

<asp:ContentPlaceHolder ID="HeadContent" runat="server">

</asp:ContentPlaceHolder>

</head>

<body>

<form runat="server">

<div class="page">

<div class="header">

<div class="title">

<h1>

Echo bridge Entertainment

</h1>

</div>

<div class="loginDisplay">

<asp:LoginView ID="LoginView1" runat="server" Visible="False">

</asp:LoginView>

<a href="../Account/ChangePassword.aspx"><asp:LoginName ID="LoginName1" runat="server" /></a>

<br />

<asp:LoginStatus ID="LoginStatus1" runat="server" />

</div>

<div class="clear hideSkiplink">

<asp:Menu ID="NavigationMenu" runat="server" CssClass="menu" EnableViewState="false" IncludeStyleBlock="false" Orientation="Horizontal">

<Items>

<asp:MenuItem NavigateUrl="~/Default.aspx" Text="Home">

<asp:MenuItem NavigateUrl="~/Management/Dashboard/Dashboard.aspx"

Text="Dashboard" Value="Dashboard"></asp:MenuItem>

<asp:MenuItem NavigateUrl="~/All/About.aspx" Text="About" Value="About">

</asp:MenuItem>

<asp:MenuItem NavigateUrl="~/All/InternalScreeners.aspx"

Text="Internal Screeners" Value="Internal Screeners"></asp:MenuItem>

<asp:MenuItem NavigateUrl="~/All/Metadata/Metadata.aspx" Text="Metadata"

Value="Metadata"></asp:MenuItem>

</asp:MenuItem>

<asp:MenuItem Text="Warehouse" Value="Warehouse">

<asp:MenuItem NavigateUrl="~/All/Default.aspx" Text="Employee Dept. Login"

Value="Employee Dept. Login"></asp:MenuItem>

<asp:MenuItem NavigateUrl="~/Management/EmployeeLoginManage.aspx"

Text="Employee Management" Value="Employee Management"></asp:MenuItem>

</asp:MenuItem>

<asp:MenuItem NavigateUrl="~/All/HR.aspx" Text="Human Resources"

Value="Human Resources">

<asp:MenuItem NavigateUrl="~/All/Jobs.aspx" Text="Job Postings"

Value="Job Postings"></asp:MenuItem>

</asp:MenuItem>

<asp:MenuItem NavigateUrl="~/All/IT.aspx"

Text="Information Technology" Value="Information Technology"></asp:MenuItem>

<asp:MenuItem Text="Sales" Value="Sales">

<asp:MenuItem NavigateUrl="~/Sales/SalesPresentationGenerator.aspx"

Text="Presentation PDF Generator" Value="Presentation PDF Generator">

</asp:MenuItem>

</Items>

</asp:Menu>

</div>

<div class="main">

<asp:ContentPlaceHolder ID="MainContent" runat="server"/>

</div>

<div class="clear" style="text-align: center">

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"

DefaultLoadingPanelID="RadAjaxLoadingPanel1">

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"

InitialDelayTime="5" MinDisplayTime="5" Skin="Default" Transparency="20">

</telerik:RadAjaxLoadingPanel>

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

</telerik:RadScriptManager>

<br />

<hr style="width:40%; color:#3a4f63; background-color:#3a4f63; height: 1px; border:0;" />

<a href="~/Admin/Admin.aspx" runat="server" style="color: #696969; text-decoration: none;">Modified:</a>

<SCRIPT LANGUAGE="JavaScript">

<!-- Begin

var days = new Array(8);

days[1] = "Sunday";

days[2] = "Monday";

days[3] = "Tuesday";

days[4] = "Wednesday";

days[5] = "Thursday";

days[6] = "Friday";

days[7] = "Saturday";

var months = new Array(13);

months[1] = "January";

months[2] = "February";

months[3] = "March";

months[4] = "April";

months[5] = "May";

months[6] = "June";

months[7] = "July";

months[8] = "August";

months[9] = "September";

months[10] = "October";

months[11] = "November";

months[12] = "December";

var dateObj = new Date(document.lastModified)

var wday = days[dateObj.getDay() + 1]

var lmonth = months[dateObj.getMonth() + 1]

var date = dateObj.getDate()

var fyear = dateObj.getYear()

if (fyear < 2000)

fyear = fyear + 1900

document.write(wday + ", " + lmonth + " " + date + ", " + fyear)

// End -->

</SCRIPT>

</div>

<div class="footer">

</div>

</form>

</body>

</html>

Content page:

<%@ Page Title="" Language="VB" MasterPageFile="~/All/Site.master" EnableEventValidation="false" AutoEventWireup="false" CodeFile="Orders.aspx.vb" Inherits="Management_Dashboard_AllOrders" %>

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

<%@ Register src="../../Controls/DashboardSelector.ascx" tagname="DashboardSelector" tagprefix="uc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">

<style type="text/css">

.style4

{

width: 100%;

}

</style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel2" Runat="server"

Skin="Default" InitialDelayTime="5" MinDisplayTime="5">

</telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="btnApplyCheckBoxes">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="OrdersGrid" />

<telerik:AjaxUpdatedControl ControlID="GPOrderHeadersDataSource" />

<telerik:AjaxUpdatedControl ControlID="DetailsDataSource" />

<telerik:AjaxUpdatedControl ControlID="ColorsDataSource" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="OrdersGrid">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="OrdersGrid"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="GPOrderHeadersDataSource" />

<telerik:AjaxUpdatedControl ControlID="DetailsDataSource" />

<telerik:AjaxUpdatedControl ControlID="ColorsDataSource" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="GPOrderHeadersDataSource">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="OrdersGrid"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="GPOrderHeadersDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="DetailsDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="ColorsDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="DetailsDataSource">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="OrdersGrid"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="GPOrderHeadersDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="DetailsDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="ColorsDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="ColorsDataSource">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="OrdersGrid"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="GPOrderHeadersDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="DetailsDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

<telerik:AjaxUpdatedControl ControlID="ColorsDataSource"

LoadingPanelID="RadAjaxLoadingPanel2" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManagerProxy>

<div style="width:50%; float:left">

<uc1:DashboardSelector ID="DashboardSelector1" runat="server" />

<h4>New Orders</h4>

<telerik:RadButton ID="btnExportToExcel" runat="server"

Text="Export to Excel" Visible="False">

</telerik:RadButton>

</div>

<div style="width:50%; float:left">

<fieldset>

<legend>Field Selection</legend>

<table class="style4">

<tr>

<td>

<asp:CheckBox ID="chkCUSTNMBR" runat="server"

Checked="True" Text="Customer Number" />

</td>

<td>

<asp:CheckBox ID="chkSOP" runat="server" Checked="True"

Text="SOP" />

</td>

<td>

<asp:CheckBox ID="chkPO" runat="server" Checked="True"

Text="PO" />

</td>

</tr>

<tr>

<td>

<asp:CheckBox ID="chkRSD" runat="server" Checked="True"

Text="Requested Ship Date" />

</td>

<td>

<asp:CheckBox ID="chkOD" runat="server" Checked="True"

Text="Order Date" />

</td>

<td>

<asp:CheckBox ID="chkCityState" runat="server"

Checked="True" Text="City, State" />

</td>

</tr>

<tr>

<td>

<asp:CheckBox ID="chkDOCID" runat="server" Checked="True"

Text="DOCID" />

</td>

<td>

<asp:CheckBox ID="chkOREMSUBT" runat="server"

Checked="True" Text="Subtotal" />

</td>

<td>

<asp:CheckBox ID="chkNL" runat="server" Checked="True"

Text="# of Lines" />

</td>

</tr>

<tr>

<td>

<asp:CheckBox ID="chkUnallocated" runat="server"

Checked="True" Text="Unallocated" />

</td>

<td>

</td>

<td>

<telerik:RadButton ID="btnApplyCheckBoxes" runat="server" Skin="Telerik"

Text="Apply">

</telerik:RadButton>

</td>

</tr>

</table>

</fieldset>

</div>

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

AllowPaging="True" DataSourceID="GPOrderHeadersDataSource" GridLines="None"

Skin="Telerik" AllowSorting="True" ShowGroupPanel="True">

<ExportSettings FileName="OrdersExport" IgnorePaging="True"

ExportOnlyData="True">

<Excel Format="ExcelML" />

<Excel Format="ExcelML"></Excel>

</ExportSettings>

<ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True"

ReorderColumnsOnClient="True">

</ClientSettings>

<MasterTableView AutoGenerateColumns="False" DataKeyNames="SOPNUMBE"

DataSourceID="GPOrderHeadersDataSource" PageSize="50">

<DetailTables>

<telerik:GridTableView runat="server" DataKeyNames="SOPNUMBE"

AllowFilteringByColumn="False" AllowPaging="False" AutoGenerateColumns="False"

DataSourceID="DetailsDataSource">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="SOPNUMBE"

MasterKeyField="SOPNUMBE" />

</ParentTableRelation>

<CommandItemSettings ExportToPdfText="Export to Pdf" />

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

<Columns>

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

SortExpression="SHIP" UniqueName="SHIP">

</telerik:GridBoundColumn>

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

SortExpression="ISSUE" UniqueName="ISSUE">

</telerik:GridBoundColumn>

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

SortExpression="SOPNUMBE" UniqueName="SOPNUMBE" Visible="False"

HeaderTooltip="All Orders Qty Outstanding">

</telerik:GridBoundColumn>

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

SortExpression="ITMSHNAM" UniqueName="ITMSHNAM">

</telerik:GridBoundColumn>

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

SortExpression="ITEMDESC" UniqueName="ITEMDESC">

</telerik:GridBoundColumn>

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

SortExpression="STATUS" UniqueName="STATUS">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Qty" DataFormatString="{0:0}"

DataType="System.Double" HeaderText="Qty" SortExpression="Qty" UniqueName="Qty">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ATYALLOC" DataFormatString="{0:0}"

DataType="System.Double" HeaderText="ATYALLOC" SortExpression="ATYALLOC"

UniqueName="ATYALLOC">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="VARIANCE" DataFormatString="{0:0}" HeaderText="VARIANCE"

SortExpression="VARIANCE" UniqueName="VARIANCE"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="GPAVAIL" DataFormatString="{0:0}"

HeaderText="GPAVAIL" HeaderTooltip="Available Qty in GP"

SortExpression="GPAVAIL" UniqueName="GPAVAIL">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AOQO" DataFormatString="{0:0}"

HeaderText="AOQO" SortExpression="AOQO" UniqueName="AOQO">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="QTYFULFI" DataFormatString="{0:0}"

DataType="System.Double" HeaderText="QTYFULFI" SortExpression="QTYFULFI"

UniqueName="QTYFULFI" Visible="False">

</telerik:GridBoundColumn>

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

SortExpression="LOCNCODE" UniqueName="LOCNCODE">

</telerik:GridBoundColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<CommandItemSettings ExportToPdfText="Export to Pdf" ShowAddNewRecordButton="False"

ShowExportToExcelButton="True" ShowExportToPdfButton="True"></CommandItemSettings>

<ExpandCollapseColumn Visible="True">

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn

GroupByExpression="SHIP, ISSUE Group By SHIP, ISSUE" HeaderText="Flag"

UniqueName="Flag" AllowFiltering="False">

<ItemTemplate>

<asp:Image ID="Image1" runat="server" Height="20px" ImageUrl="<%# GetFlag %>"

Width="20px" />

</ItemTemplate>

<FilterTemplate>

<telerik:RadComboBox ID="cboFlagFilter" Runat="server" Skin="Telerik"

onselectedindexchanged="cboFlagFilter_SelectedIndexChanged" Width="53px">

<Items>

<telerik:RadComboBoxItem runat="server" Selected="True" Text="All"

Value="All" />

<telerik:RadComboBoxItem runat="server" Text="Good" Value="Good" />

<telerik:RadComboBoxItem runat="server" Text="Bad"

Value="Bad" />

</Items>

</telerik:RadComboBox>

</FilterTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Color"

AllowFiltering="False" Groupable="False">

<ItemTemplate>

<telerik:RadComboBox ID="cboColorChanger" Runat="server" AutoPostBack="True"

DataTextField="Color" DataValueField="SOPNUMBE"

onselectedindexchanged="cboColorChanger0_SelectedIndexChanged"

SelectedValue='<%# GetColor() %>' Skin="Telerik" Width="65px" >

<Items>

<telerik:RadComboBoxItem runat="server" Owner="cboColorChanger" Text="None"

Value="None" />

<telerik:RadComboBoxItem runat="server" BackColor="Red" ForeColor="Red"

Owner="cboColorChanger" Text="Red" Value="Red" />

<telerik:RadComboBoxItem runat="server" BackColor="#FF8000" ForeColor="#FF8000"

Owner="cboColorChanger" Text="Orange" Value="Orange" />

<telerik:RadComboBoxItem runat="server" BackColor="Yellow" ForeColor="Yellow"

Owner="cboColorChanger" Text="Yellow" Value="Yellow" />

<telerik:RadComboBoxItem runat="server" BackColor="Lime" ForeColor="Lime"

Owner="cboColorChanger" Text="Green" Value="Green" />

<telerik:RadComboBoxItem runat="server" BackColor="Cyan" ForeColor="Cyan"

Owner="cboColorChanger" Text="Blue" Value="Blue" />

<telerik:RadComboBoxItem runat="server" BackColor="Fuchsia" ForeColor="Fuchsia"

Owner="cboColorChanger" Text="Pink" Value="Pink" />

</Items>

</telerik:RadComboBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

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

ReadOnly="True" SortExpression="CUSTNMBR" UniqueName="CUSTNMBR"

HeaderTooltip="Customer Number">

</telerik:GridBoundColumn>

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

ReadOnly="True" SortExpression="CUSTNAME" UniqueName="CUSTNAME"

Visible="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SOPNUMBE" HeaderText="SOP"

ReadOnly="True" SortExpression="SOPNUMBE" UniqueName="SOPNUMBE"

HeaderTooltip="SOP Number">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PO" HeaderText="PO" ReadOnly="True"

SortExpression="PO" UniqueName="PO">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ReqShipDate"

DataFormatString="{0:MM/dd/yyyy}" HeaderText="RSD" ReadOnly="True"

SortExpression="ReqShipDate" UniqueName="ReqShipDate"

HeaderTooltip="Requested Ship Date">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ORDRDATE" DataFormatString="{0:MM/dd/yyyy}"

HeaderText="OD" ReadOnly="True" SortExpression="ORDRDATE"

UniqueName="ORDRDATE" HeaderTooltip="Order Date">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn DataField="CITY"

GroupByExpression="GROUP BY STATE,CITY" HeaderText="CITY, STATE"

SortExpression="CITY" UniqueName="CITY">

<ItemTemplate>

<asp:Label ID="CITYLabel" runat="server" Text='<%# Eval("CITY") %>'></asp:Label>

,

<asp:Label ID="STATELabel" runat="server" Text='<%# Eval("STATE") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="STATE" HeaderText="ST" ReadOnly="True"

SortExpression="STATE" UniqueName="STATE" HeaderTooltip="State"

Visible="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DOCID" HeaderText="DOCID" ReadOnly="True"

SortExpression="DOCID" UniqueName="DOCID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OREMSUBT" DataFormatString="{0:C}"

HeaderText="OREMSUBT" ReadOnly="True" SortExpression="OREMSUBT"

UniqueName="OREMSUBT" HeaderTooltip="Subtotal">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="NumLines" DataType="System.Int32"

HeaderText="NL" ReadOnly="True" SortExpression="NumLines"

UniqueName="NumLines"

HeaderTooltip="Number of Lines">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="VARIANCE" DataFormatString="{0:0}"

HeaderText="UNALLOCATED" SortExpression="VARIANCE" UniqueName="VARIANCE">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn AllowFiltering="False" Groupable="False"

HeaderText="Notes" Reorderable="False" UniqueName="Notes" Visible="False">

<%--<ItemTemplate>

<table style="border-width: 0px; border-style: none; text-align: center;">

<tr><td>

<telerik:RadTextBox ID="txtNotes" Runat="server" Height="50px" Skin="Telerik"

Text="<%# GetNotes() %>" TextMode="MultiLine" Width="250px">

</telerik:RadTextBox>

</td></tr>

<tr><td>

<telerik:RadButton ID="btnUpdateNotes" runat="server" Skin="Telerik"

Text="Update Notes" onclick="btnUpdateNotes_Click">

</telerik:RadButton>

</td></tr>

</table>

</ItemTemplate>--%>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" HeaderText="Note"

Resizable="False" UniqueName="Notes Icon">

<ItemTemplate>

<asp:Panel ID="NotesPanel" Visible="true" runat="server">

<div style="text-align:center">

<asp:ImageButton ID="imgNote" runat="server" AlternateText="<%# GetNotes() %>"

ImageUrl="<%# NoteImage() %>" onclick="ImageButton1_Click"

ToolTip="<%# GetNotes() %>" Height="20px" Width="20px" />

</div>

</asp:Panel>

<asp:Panel ID="EditNotesPanel" Visible="false" runat="server">

<table style="border-width: 0px; border-style: none; text-align: center;">

<tr><td>

<telerik:RadTextBox ID="txtNotes" Runat="server" Height="50px" Skin="Telerik"

Text="<%# GetNotes() %>" TextMode="MultiLine" Width="250px">

</telerik:RadTextBox>

</td></tr>

<tr><td>

<telerik:RadButton ID="btnUpdateNotes" runat="server" Skin="Telerik"

Text="Update Notes" onclick="btnUpdateNotes_Click">

</telerik:RadButton>

</td></tr>

</table>

</asp:Panel>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<PagerStyle Mode="NextPrevNumericAndAdvanced" />

</MasterTableView>

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

</telerik:RadGrid>

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

ConnectionString="<%$ ConnectionStrings:OrdersConString %>" SelectCommand="SELECT

MAX(i.SHIP) AS SHIP,

MAX(i.ISSUE) AS ISSUE,

MAX(VARIANCE) AS VARIANCE,

RTRIM(SOP10100.CUSTNAME) AS CUSTNAME, RTRIM(SOP10100.SOPNUMBE) AS SOPNUMBE, RTRIM(SOP10100.CSTPONBR) AS PO,

(SOP10100.ReqShipDate) AS ReqShipDate, (SOP10100.ORDRDATE) AS ORDRDATE, RTRIM(SOP10100.CITY) AS CITY, RTRIM(SOP10100.STATE)

AS STATE, RTRIM(SOP10100.CUSTNMBR) AS CUSTNMBR, RTRIM(SOP10100.DOCID) AS DOCID, (SOP10100.OREMSUBT) AS OREMSUBT,

COUNT(SOP10200.ITEMNMBR) AS NumLines

FROM SOP10100 INNER JOIN

SOP10200

ON SOP10100.SOPNUMBE = SOP10200.SOPNUMBE AND SOP10100.SOPTYPE = SOP10200.SOPTYPE

INNER JOIN IntranetOrdersHeaderIssueFlags i ON i.SOPNUMBE = SOP10100.SOPNUMBE

WHERE        (SOP10100.CUSTNMBR NOT LIKE 'WALCANA') AND (SOP10100.CUSTNMBR NOT LIKE 'WALMART') AND (SOP10100.SOPTYPE = 2) AND VOIDSTTS = 0

GROUP BY RTRIM(SOP10100.CUSTNAME), RTRIM(SOP10100.SOPNUMBE), RTRIM(SOP10100.CSTPONBR), (SOP10100.ReqShipDate), (SOP10100.ORDRDATE),

RTRIM(SOP10100.CITY), RTRIM(SOP10100.STATE), RTRIM(SOP10100.CUSTNMBR), RTRIM(SOP10100.DOCID), (SOP10100.OREMSUBT)

ORDER BY RTRIM(SOP10100.CUSTNAME);"></asp:SqlDataSource>

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

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

SelectCommand="SELECT

CASE

WHEN ROUND(SOP10200.QTYREMAI-SOP10200.ATYALLOC,0) > ROUND(IV00102.QTYONHND,0) - ROUND(IV00102.ATYALLOC,0)

THEN 'N'

WHEN ROUND(SOP10200.QTYREMAI-SOP10200.ATYALLOC,0) <= ROUND(IV00102.QTYONHND,0) - ROUND(IV00102.ATYALLOC,0)

THEN ''

END AS SHIP,

CASE

WHEN MAX(ao.ALLORDERSQTYOUTSTANDING) > (ROUND(IV00102.QTYONHND,0) - ROUND(IV00102.ATYALLOC,0)) --AOQO>GPAVAIL

THEN 'Y'

WHEN MAX(ao.ALLORDERSQTYOUTSTANDING) <= (ROUND(IV00102.QTYONHND,0) - ROUND(IV00102.ATYALLOC,0)) --AOQO<=GPAVAIL

THEN ''

END AS ISSUE,

RTRIM(SOP10100.SOPNUMBE) AS SOPNUMBE,

RTRIM(IV00101.ITMSHNAM) AS ITMSHNAM,

RTRIM(SOP10200.ITEMDESC) AS ITEMDESC,

RTRIM(IV00101.USCATVLS_5) AS STATUS,

ROUND(SOP10200.QTYREMAI,0) AS Qty,

ROUND(SOP10200.ATYALLOC,0) AS ATYALLOC,

SOP10200.QTYREMAI-SOP10200.ATYALLOC AS VARIANCE,

ROUND(SOP10200.QTYFULFI,0) AS QTYFULFI,

SUM(IV00102.QTYONHND) AS GPQTYONHAND, --GPQTYONHAND

SUM(IV00102.ATYALLOC) AS GPALLOCATED, --GPALLOCATED

ROUND(IV00102.QTYONHND,0) - ROUND(IV00102.ATYALLOC,0) AS GPAVAIL,

--CAST(Sum(SOP10200.QTYREMAI) AS INT) - Cast(Sum(SOP10200.ATYALLOC) AS INT) AS AOQO, --ALLORDERSQTYOUTSTANDING

MAX(ao.ALLORDERSQTYOUTSTANDING) AS AOQO,

RTRIM(SOP10200.LOCNCODE) AS LOCNCODE

FROM SOP10200

INNER JOIN IV00101 ON SOP10200.ITEMNMBR = IV00101.ITEMNMBR

INNER JOIN IV00102 ON IV00102.ITEMNMBR = SOP10200.ITEMNMBR

INNER JOIN SOP10100 ON SOP10200.SOPNUMBE = SOP10100.SOPNUMBE AND SOP10200.SOPTYPE = SOP10100.SOPTYPE

INNER JOIN IntranetOrdersDetailAOQO ao on ao.ITEMNMBR = IV00101.ITMSHNAM

WHERE

(SOP10100.CUSTNMBR NOT LIKE 'WALCANA') AND

(SOP10100.CUSTNMBR NOT LIKE 'WALMART') AND

(SOP10200.SOPTYPE = 2) AND

(IV00102.LOCNCODE)='O_FGMAIN' AND

(IV00102.RCRDTYPE)=2 AND

(SOP10100.VOIDSTTS = 0) AND

(SOP10100.SOPNUMBE = @SOPNUMBE)

GROUP BY

SOP10100.SOPNUMBE,

IV00101.ITMSHNAM,

SOP10200.ITEMDESC,

IV00101.USCATVLS_5,

SOP10200.QTYREMAI,

SOP10200.ATYALLOC,

SOP10200.QTYFULFI,

IV00102.QTYONHND, --GPQTYONHAND

IV00102.ATYALLOC, --GPALLOCATED

IV00102.BINNMBR,

SOP10200.LOCNCODE

ORDER BY SOPNUMBE DESC;">

<SelectParameters>

<asp:Parameter Name="SOPNUMBE" />

</SelectParameters>

</asp:SqlDataSource>

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

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

SelectCommand="SELECT * FROM [OrdersTableRowColor]"></asp:SqlDataSource>

</asp:Content>

answered on 26 May 2011, 03:41 PM

Hello Brad,

Note that if you want the RadAjax to work properly you should place the RadScriptManager before the RadAjaxManager on the page:
ASPX:

<div class="clear" style="text-align: center">

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

</telerik:RadScriptManager>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"

DefaultLoadingPanelID="RadAjaxLoadingPanel1">

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"

InitialDelayTime="5" MinDisplayTime="5" Skin="Default" Transparency="20">

</telerik:RadAjaxLoadingPanel>

Give it a try and see if it helps.

Kind regards,
Pavlina
the Telerik team

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