<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="editormem.aspx.vb" Inherits="WebApplication4.editormem" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"ccc"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
div
>
<
asp:UpdatePanel
ID
=
"up"
runat
=
"server"
ChildrenAsTriggers
=
"true"
UpdateMode
=
"Conditional"
>
<
ContentTemplate
>
<
asp:Button
ID
=
"aa"
runat
=
"server"
Text
=
"Hit me multiple times"
/>
<
telerik:RadEditor
ID
=
"re"
runat
=
"server"
ContentAreaMode
=
"Div"
>
<
Content
>
Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test<
br
/>Test
</
Content
>
</
telerik:RadEditor
>
</
ContentTemplate
>
</
asp:UpdatePanel
>
</
div
>
</
form
>
</
body
>
</
html
>
protected
void
RadButton2_Click(
object
sender, EventArgs e)
{
foreach
(GridDataItem item
in
RadGrid1.SelectedItems)
{
//GridDataItem item = (GridDataItem)RadGrid1.SelectedItems;
int
UserID = Convert.ToInt16(item[
"UserID"
].ToString());
string
Type =
"D"
;
DateTime Date = DateTime.Now;
string
Description =
"Monthly Storage Fee - Tag: "
+ (item[
"PackageTag"
].ToString()) + Label3.Text;
Int32 AmountDue = Convert.ToInt32((item[
"AmtDue"
].ToString()));
string
connectionString = ConfigurationManager.ConnectionStrings[
"foo"
].ConnectionString;
SqlConnection connection =
new
SqlConnection(connectionString);
try
{
SqlCommand cmd =
new
SqlCommand(
"INSERT INTO Billing (UserID, Type, Date, Description, Amount) VALUES (@UserID, @Type, @Date, @Description, @AmountDue)"
, connection);
cmd.Parameters.AddWithValue(
"@UserID"
, UserID);
cmd.Parameters.AddWithValue(
"@Type"
, Type);
cmd.Parameters.AddWithValue(
"@Date"
, Date);
cmd.Parameters.AddWithValue(
"@Description"
, Description);
cmd.Parameters.AddWithValue(
"@AmountDue"
, AmountDue);
connection.Open();
cmd.ExecuteNonQuery();
}
catch
{
Label4.Text =
"uh oh"
;
}
finally
{
connection.Close();
}
}
//Label4.Text = "Fees successfully inserted";
}
ASPX:
<
telerik:RadChart
ID
=
"chrtSiteCompleted"
runat
=
"server"
Width
=
"400px"
Height
=
"400px"
Skin
=
"LightBlue"
AutoLayout
=
"true"
SeriesOrientation
=
"Vertical"
>
<
ChartTitle
>
<
TextBlock
Visible
=
"false"
></
TextBlock
>
</
ChartTitle
>
<
Legend
Visible
=
"false"
></
Legend
>
<
Appearance
Corners
=
"Round,Round,Round,Round,7"
></
Appearance
>
<
PlotArea
>
<
Appearance
Corners
=
"Round,Round,Round,Round,7"
></
Appearance
>
</
PlotArea
>
<
Series
>
<
telerik:ChartSeries
Name
=
"Complete Sites per Day"
Type
=
"Line"
>
<
Appearance
></
Appearance
>
<
Items
>
</
Items
>
</
telerik:ChartSeries
>
</
Series
>
<
ClientSettings
EnableZoom
=
"false"
ScrollMode
=
"XOnly"
XScale
=
"2"
/>
</
telerik:RadChart
>
Code Behind:
//Get Sites Completed per day
DataSet dsCompleteSites = Customer.GetCompleteSitesDay();
chrtSiteCompleted.DataSource = dsCompleteSites;
chrtSiteCompleted.Series[0].DataYColumn =
"CntPerday"
;
chrtSiteCompleted.PlotArea.XAxis.DataLabelsColumn =
"DateCompleted"
;
chrtSiteCompleted.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = -45;
chrtSiteCompleted.PlotArea.XAxis.Appearance.LabelAppearance.Position.AlignedPosition = AlignedPositions.Left;
chrtSiteCompleted.DataBind();
I have a 2 list boxes on a page the master list box is loaded from code behind. I have a second list box on the page which I want populated dynamically. I have a sqldatasource which calls an parameterized sql strored procedure to load the data. The control parameter is tied to a text box on the page. Each time a item or series of items are selected from my first radio list, it populates the textbox with the item values and that in turn should call the sproc with the values as a parameter to load into the second list box. It works in theory J, but I’m having a problem loading my second list box. I really don’t want to have the form post back, because it’s not very optimized even with the ajax controls that can give the same effect as it not posting back. Any help would be greatly appreciated.
Below is an example of the scenario that I have.
<telerik:RadTextBox ID="txtMerch" runat="server" Visible="true"> </telerik:RadTextBox>
<telerik:RadListBox ID="RadListBox1" runat="server" Height="200px" Skin="Forest" CheckBoxes="true" Width="200px" AutoPostBack="false" OnClientItemChecked="onItemChecked" OnClientItemChecking="onItemChecking" >
</telerik:RadListBox>
<telerik:RadListBox ID="RadListBox2" runat="server" DataSourceID="SqlDataSource2"
DataKeyField="mykey" DataTextField="Locations" Height="200px" Skin="Forest" AllowAutomaticUpdates="true" AutoPostBack="false"
CheckBoxes="true" Width="200px">
</telerik:RadListBox>
<asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:MyConnectstring %>"
runat="server"
SelectCommand= "[dbo].[RptMgr_GetLocations]"
ProviderName="<%$ ConnectionStrings:MyConnectstring.ProviderName %>"
SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
<SelectParameters>
<asp:ControlParameter ControlID="txtMerch" Name="merch"
PropertyName="Text" Type="String" />
<asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>