hi
I hope you could help me on this.
This is my sample:
routes.MapPageRoute("template1", "{name}/template1", "~/area/template1.aspx")
routes.MapPageRoute("template2", "{name}/template2", "~/area/template2.aspx")
routes.MapPageRoute("template3", "{name}/template3", "~/area/template3.aspx")
routes.MapPageRoute("template4", "{name}/template4", "~/area/template4.aspx")
routes.MapPageRoute("template5", "{name}/template5", "~/area/template5.aspx")
routes.MapPageRoute("template6", "{name}/template6", "~/area/template6.aspx")
routes.MapPageRoute("template7", "{name}/template7", "~/area/template7.aspx")
routes.MapPageRoute("template8", "{name}/template8", "~/area/template8.aspx")
routes.MapPageRoute("template9", "{name}/template9", "~/area/template9.aspx")
routes.MapPageRoute("template10", "{name}/template10", "~/area/template10.aspx")
routes.MapPageRoute("template11", "{name}/template11", "~/area/template11.aspx")
routes.MapPageRoute("template12", "{name}/template12", "~/area/template12.aspx")
I have a problem here is that whenever i add a new template say template13.aspx, i would need to add a new line into my global file.
Is there a way that i could just shorten it that represent everything? Thanks a lot
Hi! can you help me.
i have a radgrid with a lot of data ( more 10 pages, and 14 items/pages) , i want
i have add 1 column "auto number to radgrid" to display numbers record.
<Columns>
<telerik:GridBoundColumn DataField="STT" HeaderText="STT" DataType="System.Int32" UniqueName="STT"
<HeaderStyle Width="70px" />
</telerik:GridBoundColumn>
...
<Columns />
- Database i don't have field "STT".
in "RadGrid1_ItemDataBound" is
--- int rowCount = (RadGrid1.MasterTableView.CurrentPageIndex * RadGrid1.MasterTableView.PageSize) + (e.Item.ItemIndex + 1);
---------- item["STT"].Text = rowCount.ToString();
- set of export
---<ExportSettings Excel-Format="Html"
---- HideStructureColumns="true"
---- ExportOnlyData="true"
---- IgnorePaging="true"
--- OpenInNewWindow="true">
---- </ExportSettings>
and exportExcel_OnClick
--- RadGrid1.MasterTableView.ExportToExcel();
Proplem: when I was opening in pages 3 ( other first page) of datagirdview.( rowcount from 33 to 44 ex) . so item [STT ] is 33 to 44
I click button “Export excel” , file excel was exported include : all record of database but
IN ITEM [STT] DISLAY FROM 33 to ALL. (NOT FROM 1)
. I WANT WHEN I OPEN AT RANDOM PAGE (other first page) , I EXPORT ALL DATABASE, AND item [STT ] is 1 to ALL
THANKS YOU! PLEASE HELP ME
.
<script type="text/javascript"> function onRequestStart(sender, args) { if (args.get_eventTarget().indexOf("exportButton") >= 0) { args.set_enableAjax(false); } }; </script> <telerik:RadGrid ID="dgDetalles" runat="server" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowSorting="True" AutoGenerateColumns="False" CellSpacing="0" CssClass="GridStyle" Culture="Spanish (Spain)" GridLines="None" PageSize="100" ShowFooter="True" ShowStatusBar="True" Skin="Forest" Style="left: 5px; top: -21px;" Width="99%" ClientSettings-Scrolling-AllowScroll="true" > <ExportSettings HideStructureColumns="true" /> <clientsettings> <Scrolling UseStaticHeaders="True" AllowScroll="True" SaveScrollPosition="true" /> <Resizing AllowResizeToFit="false" AllowColumnResize="false" ResizeGridOnColumnResize="false" /> </clientsettings> <mastertableview TableLayout="Fixed" Width="100%" NoMasterRecordsText="No se encontraron resultados para los filtros seleccionados" NoDetailRecordsText="No se encontraron resultados para los filtros seleccionados" commanditemdisplay="Top" datakeynames="NombrePais,NombreBodega,NOMBREDEPARTAMENTO" editmode="PopUp" CssClass="opa"> <commanditemtemplate> <div style="padding: 5px 5px; float: right;"> <asp:ImageButton ID="btnRefresh" ToolTip="Refrescar" ClientIDMode="Static" runat="server" CommandName="RebindGrid" style="border:0px;vertical-align:middle;width:32px;height:32px;" ImageUrl="../DkImages/Refresh.png" /> </div> </commanditemtemplate> <Columns> <telerik:GridBoundColumn DataField="NombrePais" HeaderText="Pais" UniqueName="NombrePais" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="NombreBodega" HeaderText="Bodega" UniqueName="NombreBodega" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="NOMBREDEPARTAMENTO" HeaderText="Departamento" UniqueName="NOMBREDEPARTAMENTO" Visible="False" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="BoletaSalida" HeaderText="Boleta de Salida" UniqueName="BoletaSalida" Visible="False" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="FechaMovimiento" HeaderText="Fecha Movimiento" UniqueName="FechaMovimiento" Visible="False" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DescripcionMaterial" HeaderText="Material" UniqueName="DescripcionMaterial" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TipoMovimiento" HeaderText="Tipo de Movimiento" UniqueName="TipoMovimiento" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="150px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DescripcionTipoPOP" HeaderText="Tipo de Material" UniqueName="DescripcionTipoPOP" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DescripcionMotivo" HeaderText="Motivo" UniqueName="DescripcionMotivo" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="175px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="pkOE" HeaderText="Orden Entrada" UniqueName="pkOE" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="pkOAAsociadas" HeaderText="OA's Asociadas" UniqueName="pkOAAsociadas" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="175px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Cantidad" HeaderText="Cantidad" UniqueName="Cantidad" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="75px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CostoUnitarioMaterial" HeaderText="Costo Unitario" UniqueName="CostoUnitarioMaterial" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Estado" HeaderText="Estado" UniqueName="Estado" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="80px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="NombreUsuario" HeaderText="Usuario" UniqueName="NombreUsuario" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PersonaEntregaMaterial" HeaderText="Entrega Material" UniqueName="PersonaEntregaMaterial" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PersonaAutoriza" HeaderText="Autoriza" UniqueName="PersonaAutoriza" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Destino" HeaderText="Destino" UniqueName="Destino" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="75px"/> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OrdenCompra" HeaderText="Orden de Compra" UniqueName="OrdenCompra" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="75px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Proveedor" HeaderText="Proveedor" UniqueName="Proveedor" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="125px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DescripcionPlanInversion" HeaderText="Plan de Inversion" UniqueName="DescripcionPlanInversion" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="200px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MesEjecucion" HeaderText="Mes de Ejecucion" UniqueName="MesEjecucion" ItemStyle-HorizontalAlign="Left"> <HeaderStyle Font-Bold="True" ForeColor="White" HorizontalAlign="Left" Width="80px" /> </telerik:GridBoundColumn> </Columns> </mastertableview> <PagerStyle Mode="NumericPages" /> <filtermenu enableimagesprites="False"> </filtermenu> </telerik:RadGrid><telerik:RadMaskedTextBox ID="TxtSoc_Sec_Num" runat="server" Mask="###-##-####" CssClass="gridTextBox" Text='<%# Bind( "Soc_Sec_Num") %>'> </telerik:RadMaskedTextBox><asp:RegularExpressionValidator ID="RegularExpressionValidatorTxtSoc_Sec_Num" runat="server" Display="None" ErrorMessage="! Soc. Sec# must be in: 999-99-999 Format." ValidationExpression="\d{3}-\d{2}-\d{4}" SetFocusOnError="true" ControlToValidate="TxtSoc_Sec_Num"></asp:RegularExpressionValidator>
public DataTable PivotTable(DataTable source)
{
DataTable dest = new DataTable("Pivoted" + source.TableName);
dest.Columns.Add(
" ");
foreach (DataRow r in source.Rows)
dest.Columns.Add(r[0].ToString());
for (int i = 0; i < source.Columns.Count - 1; i++)
{
dest.Rows.Add(dest.NewRow());
}
for (int r = 0; r < dest.Rows.Count; r++)
{
for (int c = 0; c < dest.Columns.Count; c++)
{
if (c == 0)
dest.Rows[r][0] = source.Columns[r + 1].ColumnName;
else
dest.Rows[r][c] = source.Rows[c - 1][r + 1];
}
}
dest.AcceptChanges();
return dest;
}
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
RadGrid1.DataSource = PivotTable(GetDataTable(
"SELECT CONVERT(varchar,StatDate,101) StatDate,FelonyArrests,MisdArrests,NTA,FSAO,TrafficArrests,WarrantArrests,DispCalls,SelfInitActivities,[BackUp] BackUps,FIR," +
"VehRecov,TrafficCitations,CourtesyNotices,TrafficStops,WarrantsServed,WarrantsObtained,NewGangFiles,GangFileUpd,Presentations,InvestHours," +
"IntelRpts,PropValRecov,GunsRecov,IntelBullitens,SearchWarrantHours,TasksAssigned,TasksTrans,TasksCleared,AssignedActive,Transfered," +
"ClearedByArrest,EC,Unfounded,Closed,Inactive,Surveillance,Callouts,SearchWarrants FROM Gang_Stats ORDER BY StatDate asc"));
}
protected void RadGrid1_ColumnCreated(object sender, Telerik.Web.UI.GridColumnCreatedEventArgs e)
{
if (e.Column.UniqueName == "StatDate")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.DataFormatString =
"{0:d}";
boundColumn.ItemStyle.Font.Bold =
true;
}
}
foreach (GridDataItem item in RadGrid1.Items) { item.Edit = true; } RadGrid1.MasterTableView.Rebind();