<%
@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
<script language="javascript" type="text/javascript">
function onRequestStart(sender, args) {
if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0) {
args.set_enableAjax(false);
}
}
</script>
</telerik:RadScriptBlock>
<table>
<tr>
<td style="width: 100px; height: 21px">
<asp:Label ID="LblTituloReporte" runat="server" SkinID="TituloPaginasAdm" Text="Clientes"
Width="786px"></asp:Label><br />
<br />
</td>
</tr>
<tr>
<td>
<table>
<tr>
<td>
<asp:Label ID="LbClientes" runat="server" CssClass="FormatLabels" SkinID="TitleLabel"
Text="Cliente" Width="145px"></asp:Label>
</td>
<td style="width: 245px">
<asp:DropDownList ID="DropDownList1Abecedario" runat="server" Font-Names="verdana"
AutoPostBack="true" Font-Size="10pt" Width="150px" OnSelectedIndexChanged="DropDownList1Abecedario_OnSelectedIndexChanged">
<asp:ListItem Value="0">----</asp:ListItem>
<asp:ListItem Value="1">A-C</asp:ListItem>
<asp:ListItem Value="2">D-F</asp:ListItem>
<asp:ListItem Value="3">G-I</asp:ListItem>
<asp:ListItem Value="4">J-L</asp:ListItem>
<asp:ListItem Value="5">M-O</asp:ListItem>
<asp:ListItem Value="6">P-R</asp:ListItem>
<asp:ListItem Value="7">S-U</asp:ListItem>
<asp:ListItem Value="8">V-Z</asp:ListItem>
</asp:DropDownList>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:DropDownList ID="DropDownList1Organizador" runat="server" Font-Names="verdana"
Font-Size="10pt" Width="380px">
</asp:DropDownList>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="DropDownList1Abecedario" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>
</td>
<td style="width: 99px;">
<telerik:RadButton ID="ImgConsultar" Text="Consultar" runat="server" Skin="Hay" OnClick="ImgConsultar_Click">
</telerik:RadButton>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:CheckBox ID="chkVerTodos" Text="Ver todos los clientes" AutoPostBack="true"
OnCheckedChanged="chkVerTodos_OnCheckedChanged" runat="server" />
</td>
<td>
</td>
</tr>
</table>
<br />
</td>
</tr>
</table>
<table>
<tr>
<td style="width: 121px">
<asp:Label ID="LbTituloCliente" runat="server" CssClass="FormatLabels" SkinID="TituloPaginasAdm"
Text="Cliente" Visible="false" Width="660px"></asp:Label>
<asp:Label ID="LbIngresoDatos" runat="server" CssClass="FormatLabels" Enabled="false"
SkinID="TituloPaginasAdm" Text="Ingreso de datos" Visible="false" Width="160px"></asp:Label>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<ClientEvents OnRequestStart="onRequestStart" />
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadAjaxPanel1">
</telerik:AjaxSetting>
<telerik:AjaxSetting AjaxControlID="RadGridHistorico">
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Height="200px" HorizontalAlign="NotSet"
Width="1195px">
<telerik:RadGrid ID="RadGridHistorico" runat="server" Skin="Hay" AllowPaging="True"
AutoGenerateColumns="False" GridLines="None" AllowFilteringByColumn="True" AllowSorting="True"
ShowGroupPanel="True" ViewStateMode="Enabled" OnPreRender="RadGridHistorico_OnPreRender">
<ExportSettings ExportOnlyData="true" FileName="Log clientes" HideStructureColumns="true"
IgnorePaging="true" OpenInNewWindow="true" />
<ClientSettings AllowDragToGroup="True">
</ClientSettings>
<MasterTableView CommandItemDisplay="Top">
<CommandItemSettings ShowExportToExcelButton="true" />
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
</RowIndicatorColumn>
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn AndCurrentFilterFunction="Contains" DataField="NitCliete"
FilterControlAltText="Filter column column" HeaderText="NitCliete" UniqueName="column">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn AndCurrentFilterFunction="Contains" DataField="NombreCliente"
FilterControlAltText="Filter column1 column" HeaderText="NombreCliente" UniqueName="column1">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn AndCurrentFilterFunction="Contains" DataField="ModificadoEliminado"
FilterControlAltText="Filter column2 column" HeaderText="ModificadoEliminado"
UniqueName="column2">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
</MasterTableView>
<ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True" ReorderColumnsOnClient="True">
</ClientSettings>
<GroupPanel Text="Arrastre la cabecera de la columna y sueltela sobre esta área para agrupar los registros por esa columna.">
</GroupPanel>
<FilterMenu EnableImageSprites="False">
</FilterMenu>
<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Hay">
</HeaderContextMenu>
</telerik:RadGrid>
</telerik:RadAjaxPanel>
</td>
</td>
</tr>
</table>
<table>
<tr>
<td style="width: 100px">
</td>
</tr>
</table>
</asp:Content>
<telerik:RadWindowManager ID="RadWindowManager1" <br>ShowContentDuringLoad="false" VisibleStatusbar="false" ReloadOnShow="true" runat="server" EnableShadow="True" <br>VisibleTitlebar="true" EnableTheming="True" AutoSize="true" Behaviors="None" Skin="Forest"><br> <Windows><br> <telerik:RadWindow ID="rwChemicalCropApplicationRates" runat="server" <br> Behaviors="Close, Move"<br> OnClientClose="rwChemicalCropApplicationRates_Close"<br> NavigateUrl="Dialogs/ModifyCropApplicationRate.aspx" Skin="Telerik"><br> </telerik:RadWindow><br> </Windows><br></telerik:RadWindowManager>
try
{
BlowDownDataLayer.InsertBlowDownEvents(this.ToString(),
Int32.Parse(RadComboboxPlant.SelectedValue.ToString()),
Int32.Parse(RadComboboxEquip.SelectedValue.ToString()),
txtEventDesc.Text.ToString(),
Int32.Parse(RadComboboxBldGasType.SelectedValue.ToString()),
Int32.Parse((insertedItem["BlowDownEmissionColumn"].Controls[0] as RadNumericTextBox).Text.ToString()),
Int32.Parse((insertedItem["NumberofBlowdownEvents"].Controls[0] as RadNumericTextBox).Text.ToString()),
DateTime.Parse(EventdtTime.SelectedDate.ToString()));
}
catch (Exception ex)
{
GridBlowDown.Controls.Add(
new LiteralControl("Unable to insert Event. If the problem persists, please contact IT Service Center (x8765)."));
e.Canceled =
true;
}
thanks,
Minh Bui
SELECT * FROM WTO_LinkGroups WHERE (Convert.ToString(it["group_name"]) = "3")<telerik:GridBoundColumn DataField="group_name" HeaderText="Group Name" SortExpression="group_name" UniqueName="group_name"> <FilterTemplate> <telerik:RadComboBox runat="server" ID="GroupNameComboBox" DataSourceID="SqlDataSource1" DataTextField="group_name" DataValueField="group_id" Height="200px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("group_name").CurrentFilterValue %>' OnClientSelectedIndexChanged="GroupNameIndexChanged"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server"> <script type="text/javascript"> function GroupNameIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("group_name", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> </telerik:GridBoundColumn>protected void RefreshCombos() { SqlDataSource1.SelectCommand = "SELECT * FROM WTO_LinkGroups WHERE " + RadGrid1.MasterTableView.FilterExpression.ToString(); SqlDataSource1.SelectCommandType = System.Web.UI.WebControls.SqlDataSourceCommandType.Text; RadGrid1.MasterTableView.Rebind(); }<telerik:RadComboBox ID="ddlRadComboBox" Runat="server" EmptyMessage="Enter a skill name" MarkFirstMatch="True" MaxLength="200" ShowDropDownOnTextboxClick="True" OnItemsRequested="ddlRadComboBox_ItemsRequested" EnableVirtualScrolling="True" ItemsPerRequest="10" ShowMoreResultsBox="true" EnableLoadOnDemand="True" />private DataTable GetData(string text) { try { //using() requires no close() using (connection = new SqlConnection(ConnectionString)) { //open connection to db connection.Open(); //change command query based on dropdown myCommand = new SqlCommand(FillComboBox(), connection); using (adapter = new SqlDataAdapter(myCommand)) { comboBoxDT = new DataTable(); adapter.Fill(comboBoxDT); return comboBoxDT; } } } catch (Exception ex) { HandleException(ex); } return comboBoxDT; }protected void ddlRadComboBox_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { DataTable data = GetData(e.Text); int itemOffset = e.NumberOfItems; int endOffset = Math.Min(itemOffset + ItemsPerRequest, data.Rows.Count); e.EndOfItems = endOffset == data.Rows.Count; for (int i = itemOffset; i < endOffset; i++) { ddlRadComboBox.Items.Add(new RadComboBoxItem(data.Rows[i]["SkillName"].ToString(), data.Rows[i]["SkillName"].ToString())); } }radchart1.PlotArea.YAxis.MaxItemsCount = 10; does not seem to work.
Let me know if you need more information.
Thanks in advance.