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;
}
}