I am new to the updatepanel and need some help. I have a gridview control and a detailsview control. The detailsview control is displayed for edits on the gridview row select command. These controls are wrapped in an updatepanel, there are 2 textboxes that I want to update with calculated values based on the selected value of the dropdownlist. I was trying to accomplish this by using the SelectedIndexChanged of the ddlScheduleType dropdownlist in codbehind.
How do I get this to work, am I on the right track? Any help would be greatly appreciated, code is below.
Protected
Sub
ddlScheduleType_SelectedIndexChanged(ByVal
senderAs
Object
,ByVal
eAs
System.EventArgs)'Get a refernce to the dropdownlist:
Dim
ddlScheduleTypeAs
DropDownList =CType
(CType
(sender, DetailsView).FindControl("ddlScheduleType"
), DropDownList)Dim
nDistroyDaysAs
Integer
= Utility.GetBoxCatDestroyDays(ddlScheduleType.SelectedValue)Dim
ctrlTbDYAs
TextBox =CType
(CType
(sender, DetailsView).FindControl("tbDestroyYear"
), TextBox)Dim
ctrlTbDMAs
TextBox =CType
(CType
(sender, DetailsView).FindControl("tbDestroyMonth"
), TextBox)Dim
ctrlTbDEAs
TextBox =CType
(CType
(sender, DetailsView).FindControl("tbDateEnd"
), TextBox)
<%
@dotnet.itags.org.PageLanguage="VB"MasterPageFile="~/Default.master"AutoEventWireup="false"CodeFile="drEdit.aspx.vb"Inherits="drEdit"title="Untitled Page" %><%
@dotnet.itags.org.RegisterAssembly="AjaxControlToolkit"Namespace="AjaxControlToolkit"TagPrefix="ajaxtoolkit" %><%
@dotnet.itags.org.RegisterNamespace="CustomBoundField"TagPrefix="custom" %><
asp:ContentID="Content1"ContentPlaceHolderID="MainContent"Runat="Server"><
ajax:ScriptManagerid="sm1"EnablePartialRendering="True"runat="server"/><table><tr><td
align="Center"
valign="Top"><ajax:UpdatePanel
id="up2"
runat="server"><contentTemplate><asp:GridView
Runat="server"Id="gvDrMaster"GridLines="Both"cellpadding="1"cellspacing="0"Headerstyle-BackColor="#BDCFE7"Headerstyle-Font-Names="Verdana,Helvetica,Arial;"Headerstyle-Font-Size="8"BackColor="#E7EFFF"Font-Names="Verdana,Helvetica,Arial;"Font-Size="8"BorderColor="Black"DataSourceID="SqlDsMaster"DataKeyNames="dr_id"AllowPaging="True"AllowSorting="True"PageSize="50"AutoGenerateColumns="False"><Columns><asp:CommandField
ShowSelectButton="True"
/><asp:BoundField
DataField="box_barcode"
HeaderText="Barcode"
/><asp:BoundField
DataField="box_description"
HeaderText="Description"
HeaderStyle-HorizontalAlign=Left
ItemStyle-HorizontalAlign=left
/><asp:BoundField
DataField="box_location"
HeaderText="Location"
/><asp:BoundField
DataField="status_name"
HeaderText="Status"
/><asp:BoundField
DataField="site_name"
HeaderText="Site"
/><asp:BoundField
DataField="dr_id"
ReadOnly="True"
HeaderText=""
HeaderStyle-Width="0"
/><asp:BoundField
DataField="box_site"
ReadOnly=true
HeaderText=""
HeaderStyle-Width="0"
/></Columns><SelectedRowStyle
BackColor=AliceBlue/></asp:GridView><triggers><ajax:controlValueTrigger
controlid="gvDrmaster"
propertyname="Select"
/></triggers>
</contentTemplate></ajax:UpdatePanel></td><td
align="Left"
valign="Top"><ajax:UpdatePanel
id="up1"
UpdateMode=Always
runat="server"><contentTemplate><asp:DetailsViewDataKeyNames="dr_id"
DataSourceID="SqlDsDetail"GridLines="Both"cellpadding="1"cellspacing="0"Headerstyle-BackColor="#BDCFE7"Headerstyle-Font-Names="Verdana,Helvetica,Arial;"Headerstyle-Font-Size="8"BackColor="#E7EFFF"Font-Names="Arial"Font-Size="8"BorderColor="Black"HeaderText="Author Details"
AutoGenerateRows="False"HeaderStyle-Font-Bold="True"OnItemUpdated="DVAfterUpdate"ID="dvDrMaster"
runat="server"><Fields><asp:BoundField
DataField="dr_id"
HeaderText="ID"
ReadOnly="True"
ControlStyle-CssClass="dvDataField"
/><asp:BoundField
DataField="box_barcode"
HeaderText="Barcode"
ControlStyle-CssClass="dvDataField"
/><custom:BoundTextBoxField
CssClass="dvDataField"
DataField="box_description"
HeaderText="Description"
TextMode="MultiLine"
Rows="5"
Columns="50"
Wrap="True"
/><asp:TemplateField
HeaderText="Box Category"><ItemTemplate><asp:Label
id="lblScheduleType"
runat="server"
Text='<%
# Container.DataItem("schedule_record_type")%>'
/></ItemTemplate><EditItemTemplate><asp:DropDownList
runat="server"id="ddlScheduleType"
DataSourceID="dsScheduleType"
SkinID=ddl
BackColor="Pink"
DataTextField="schedule_record_type"
DataValueField="schedule_id"
AutoPostBack=true
OnSelectedIndexChanged="ddlScheduleType_SelectedIndexChanged"SelectedValue='<%
# Bind("box_schedule_type")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Status"><ItemTemplate><asp:Label
id="lblStatus"
runat="server"
Text='<%
# Container.DataItem("status_name")%>'
/></ItemTemplate><EditItemTemplate><asp:DropDownList
runat="server"id="ddlStatus"
DataSourceID="dsStatus"
SkinID=ddl
BackColor="Pink"
DataTextField="status_name"
DataValueField="status_id"
SelectedValue='<%
# Bind("box_status")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Site"><ItemTemplate><asp:Label
id="lblSiteName"
runat="server"
Text='<%
# Container.DataItem("site_name")%>'
/></ItemTemplate><EditItemTemplate><asp:DropDownList
runat="server"id="ddlSite"
DataSourceID="dsSite"
BackColor="Pink"
SkinID=ddl
DataTextField="site_name"
DataValueField="site_id"
SelectedValue='<%
# Bind("box_site")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Box Location"><ItemTemplate><asp:Label
id="lblLocation"
runat="server"
Text='<%
# Container.DataItem("box_location")%>'
/></ItemTemplate><EditItemTemplate><asp:DropDownList
runat="server"id="ddlBoxLocation"
DataSourceID="SQLDSLocation"
BackColor="Pink"
SkinID=ddl
DataTextField="location_id"
DataValueField="location_id"
SelectedValue='<%
# Bind("box_location")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Cardholder Data"><ItemTemplate><asp:Label
id="lblCardholder"
runat="server"
Text='<%
# Container.DataItem("box_cardholder_desc")%>'
/></ItemTemplate><EditItemTemplate><asp:DropDownList
runat="server"id="ddlCardholder"
BackColor="Pink"
SkinID=ddl
DataTextField="box_cardholder_desc"
DataValueField="box_cardholder"
SelectedValue='<%
# Bind("box_cardholder")%>'
>
<asp:ListItem
Selected="True"
Value=""
Text=""
/><asp:ListItem
Value="Y"
Text="Yes"
/><asp:ListItem
Value="N"
Text="No"
/></asp:DropDownList>
</EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Dept"><ItemTemplate><asp:Label
id="lblDept"
runat="server"
Text='<%
# Container.DataItem("dept_name")%>'
/></ItemTemplate><EditItemTemplate><asp:DropDownList
runat="server"id="ddlDept"
DataSourceID="SQLdsDepartment"
BackColor="Pink"
SkinID=ddl
DataTextField="dept_name"
DataValueField="dept_id"
SelectedValue='<%
# Bind("fiserv_dept")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:BoundField
DataField="date_start"
HeaderText="Start Date"
ControlStyle-CssClass="dvDataField"
/>
<asp:TemplateField
HeaderText="End Date"><ItemTemplate><asp:Label
id="lblDateEnd"
runat="server"
Text='<%
# Container.DataItem("date_end")%>'
/></ItemTemplate><EditItemTemplate><asp:TextBox
ID="tbDateEnd"
SkinID=tb
runat="server"
Text='<%
# Bind("date_end")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Destroy Month"><ItemTemplate><asp:Label
id="lblDestroyMonth"
runat="server"
Text='<%
# Container.DataItem("date_dest_month")%>'
/></ItemTemplate><EditItemTemplate><asp:TextBox
ID="tbDestroyMonth"
SkinID=tb
runat="server"
ReadOnly=true
Text='<%
# Bind("date_dest_month")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:TemplateField
HeaderText="Destroy Year"><ItemTemplate><asp:Label
id="lblDestroyYear"
runat="server"
Text='<%
# Container.DataItem("date_dest_year")%>'
/></ItemTemplate><EditItemTemplate><asp:TextBox
ID="tbDestroyYear"
SkinID=tb
runat="server"
ReadOnly=true
Text='<%
# Bind("date_dest_year")%>'
/></EditItemTemplate></asp:TemplateField>
<asp:CommandField
ShowEditButton="True"
/></Fields></asp:DetailsView><Triggers><atlas:ControlEventTrigger
ControlID="ddlScheduleType"
EventName="SelectedIndexChanged"
/></Triggers></contentTemplate>
</ajax:UpdatePanel>
</td></tr></table><asp:SqlDataSource
ID="SqlDsMaster"
runat="server"SelectCommand="select dr_id, box_barcode, box_description, box_location, status_name, box_site, site_name from view_dr_master where box_site not in(97,98)"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"></asp:SqlDataSource><asp:SqlDataSource
ID="SqlDsDetail"runat="server"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"
SelectCommand="SELECT dr_id, box_barcode, box_schedule_type, box_description, box_location, box_status, status_name, box_site, site_name, fiserv_dept, dept_name,
date_start, date_end, date_dest_month, date_dest_year, box_cardholder, box_cardholder_desc
FROM view_dr_master WHERE (dr_id = @dotnet.itags.org.dr_id)">
<SelectParameters><asp:ControlParameter
ControlID="gvDrMaster"
Name="dr_id"PropertyName="SelectedValue"Type="String"
/></SelectParameters></asp:SqlDataSource>
<asp:SQLDataSource
ID="dsScheduleType"Runat="Server"SelectCommand
=
"SELECT schedule_id, schedule_record_type from dr_schedule GROUP BY schedule_id, schedule_record_type Union Select 0 schedule_id, 'Please select a box category' schedule_record_type From dr_schedule ORDER BY schedule_record_type"DataSourceMode="DataSet"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"></asp:SQLDataSource>
<asp:SQLDataSource
ID="dsStatus"Runat="Server"SelectCommand
=
"SELECT status_id, status_name from dr_status Union Select '' status_id, 'Please select a box status.' status_name from dr_status ORDER BY status_id "DataSourceMode="DataSet"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"
/><asp:SQLDataSource
ID="dsSite"Runat="Server"SelectCommand
=
"select site_id, site_name from dr_site order by site_id"DataSourceMode="DataSet"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"
/><asp:SQLDataSource
ID="SQLDSLocation"Runat="Server"DataSourceMode="DataSet"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"
></asp:SQLDataSource>
<asp:SQLDataSource
ID="SQLdsDepartment"Runat="Server"SelectCommand
=
"select dept_id, dept_name from dr_departments"DataSourceMode="DataSet"ConnectionString="<%
$ ConnectionStrings:RetentionConnectionString%>"
/>
</
asp:Content>Dim
dtDestroyDateAs
DateTime = dtDestroyDate.AddDays(nDistroyDays)ctrlTbDY.Text = dtDestroyDate.Year
ctrlTbDM.Text = dtDestroyDate.Month
End
Sub
Never mind figured it out, removed
<Triggers><atlas:ControlEventTriggerControlID="ddlScheduleType"EventName="SelectedIndexChanged"/></Triggers>