or
Public
Sub
LlenaGrid()
Strsql =
"Select Empresa,Corr,NomPuesto,Salario from templeo where codusuario = "
& Session(
"CodUsuario"
) &
""
cn.Open()
daData.SelectCommand =
New
OleDb.OleDbCommand(Strsql, cn)
daData.Fill(dsGen,
"DATA"
)
GrdEmpleo.DataSource = dsGen
GrdEmpleo.DataMember =
"DATA"
GrdEmpleo.DataBind()
cn.Close()
dsGen.Tables(
"DATA"
).Clear()
End
Sub
<
telerik:RadGrid
runat
=
"server"
ID
=
"GrdEmpleo"
PageSize
=
"5"
AutoGenerateColumns
=
"False"
Width
=
"100%"
AllowSorting
=
"True"
AllowPaging
=
"True"
GridLines
=
"None"
TabIndex
=
"17"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
NextPageText
=
"Siguiente"
PrevPageText
=
"Anterior"
PagerTextFormat="Change page: {4} Pagina <strong>{0}</
strong
> de <
strong
>{1}</
strong
>, registros <
strong
>{2}</
strong
> a <
strong
>{3}</
strong
> de <
strong
>{5}</
strong
>."
PageSizeLabelText="Regitros"/>
<
MasterTableView
DataKeyNames
=
"Empresa,Corr,NomPuesto,Salario"
>
<
Columns
>
<
telerik:GridButtonColumn
DataTextField
=
"Empresa"
UniqueName
=
"Empresa"
HeaderText
=
"Empresa"
></
telerik:GridButtonColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corr"
UniqueName
=
"Corr"
Visible
=
"false"
HeaderStyle-Width
=
"75px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Nompuesto"
UniqueName
=
"NomPuesto"
HeaderText
=
"Puesto"
HeaderStyle-Width
=
"75px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Salario"
HeaderText
=
"Salario"
HeaderStyle-Width
=
"75px"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
clientsettings
>
<
selecting
allowrowselect
=
"True"
/>
</
clientsettings
>
<
FilterMenu
EnableTheming
=
"true"
>
<
CollapseAnimation
Duration
=
"200"
Type
=
"InOutQuint"
/>
</
FilterMenu
>
</
telerik:RadGrid
>
Private
Sub
GrdEmpleo_PageIndexChanged(
ByVal
sender
As
Object
,
ByVal
e
As
Telerik.Web.UI.GridPageChangedEventArgs)
Handles
GrdEmpleo.PageIndexChanged
Try
LlenaGrid()
Catch
ex
As
Exception
LblMensaje.Text = ex.Message
End
Try
End
Sub
protected
void
rgApplications_NeedDataSource(
object
sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
LaundryLogicDAL.ARApplicationsCollection oARAC =
new
LaundryLogicDAL.ARApplicationsCollection();
LaundryLogicDAL.ARApplicationsQuery oARAQ =
new
LaundryLogicDAL.ARApplicationsQuery(
"ara"
);
LaundryLogicDAL.ARCreditsQuery oARCQ =
new
LaundryLogicDAL.ARCreditsQuery(
"arc"
);
LaundryLogicDAL.ARDebitsQuery oARDQ =
new
LaundryLogicDAL.ARDebitsQuery(
"ard"
);
try
{
oARAC.es.Connection.Name =
"NAS"
;
oARAC.es.Connection.SqlAccessType = esSqlAccessType.DynamicSQL;
oARAQ.es2.Connection.Name =
"NAS"
;
oARAQ.es2.Connection.SqlAccessType = esSqlAccessType.DynamicSQL;
oARCQ.es2.Connection.Name =
"NAS"
;
oARCQ.es2.Connection.SqlAccessType = esSqlAccessType.DynamicSQL;
oARDQ.es2.Connection.Name =
"NAS"
;
oARDQ.es2.Connection.SqlAccessType = esSqlAccessType.DynamicSQL;
oARAQ.Select(
oARCQ.CreditIdentifier,
oARCQ.CreditDate,
oARCQ.OriginalAmount.As(
"CreditAmount"
),
oARAQ.ApplicationDate,
oARAQ.Amount.As(
"ApplicationAmount"
),
oARAQ.Notes.As(
"ApplicationNotes"
),
oARDQ.DebitIdentifier,
oARDQ.DebitDate,
oARDQ.OriginalAmount.As(
"DebitAmount"
)
);
oARAQ.InnerJoin(oARCQ).On(
oARAQ.CreditID == oARCQ.Id);
oARAQ.InnerJoin(oARDQ).On(
oARAQ.DebitID == oARDQ.Id);
//if (Session["DebitID"] != null)
if
(ViewState[
"DebitID"
] !=
null
&& (
int
)ViewState[
"DebitID"
] >= 0)
{
oARAQ.Where(
//oARAC.Query.DebitID == (int)Session["DebitID"]
oARAQ.DebitID == (
int
)ViewState[
"DebitID"
]
);
}
else
if
(ViewState[
"CreditID"
] !=
null
&& (
int
)ViewState[
"CreditID"
] >= 0)
{
oARAQ.Where(
//oARAC.Query.DebitID == (int)Session["DebitID"]
oARAQ.DebitID == (
int
)ViewState[
"CreditID"
]
);
}
if
(oARAC.Load(oARAQ))
{
rgApplications.DataSource = oARAC;
}
else
{
rgApplications.DataSource =
new
object
[0];
}
}
catch
(Exception ex)
{
rgApplications.DataSource =
new
object
[0];
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(
this
, ex);
}
finally
{
oARAC.Dispose();
oARAC =
null
;
oARAQ =
null
;
oARCQ =
null
;
oARDQ =
null
;
}
}
<
telerik:RadGrid
ID
=
"rgApplications"
runat
=
"server"
AllowFilteringByColumn
=
"True"
AllowPaging
=
"True"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
GridLines
=
"None"
OnNeedDataSource
=
"rgApplications_NeedDataSource"
>
<
HeaderContextMenu
CssClass
=
"GridContextMenu GridContextMenu_Default"
>
</
HeaderContextMenu
>
<
MasterTableView
AllowMultiColumnSorting
=
"True"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
></
CommandItemSettings
>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
FilterControlAltText
=
"Filter ExpandColumn column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"CreditIdentifier"
FilterControlAltText
=
"Filter CreditIdentifier column"
HeaderText
=
"Credit ID"
UniqueName
=
"CreditIdentifier"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
>
</
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
>
</
FilterMenu
>
</
telerik:RadGrid
>
Hi,
It seems that Korean Culture of RadDateTimePicker of Q2 version has something wrong which although I select time with PM but it is always selected only AM.
(but, it works with en-US culture)
please, refer to below details and let me know.
Many thanks,
Joey
<telerik:RadDateTimePicker ID="rdpReservationDate" runat="server" MinDate="2006/1/1" ToolTip="Please Select datetime.." Culture="Korean (Korea)" Width="170px"> |
<DateInput runat="server" ID="DateInput"> |
</DateInput> |
<Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x"></Calendar> |
<TimeView CellSpacing="-1" Culture="Korean (Korea)"></TimeView> |
<TimePopupButton ImageUrl="" HoverImageUrl=""></TimePopupButton> |
<DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton> |
</telerik:RadDateTimePicker> |
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default14.aspx.cs" Inherits="Default14" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!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
>
<
telerik:RadScriptBlock
runat
=
"server"
ID
=
"RadScriptBlock1"
>
<
script
type
=
"text/javascript"
>
//
function openFilterBuilderDialog() {
$find('<%=RadWindow1.ClientID %>').show();
}
function hideFilterBuilderDialog() {
$find('<%=RadWindow1.ClientID %>').close();
}
function OnHeaderMenuItemClicked(sender, args)
{
if (args.get_item().get_value() == "FilterBuilder")
{
openFilterBuilderDialog();
}
}
function onPanelBarItemClicked(sender, args)
{
if (args.get_item().get_commandName() == "OpenRadFilter")
{
openFilterBuilderDialog();
}
}
</
script
>
</
telerik:RadScriptBlock
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
asp:Button
ID
=
"Button1"
runat
=
"server"
Text
=
"Refresh"
OnClick
=
"Button1_Click"
/>
<
telerik:RadAjaxManager
runat
=
"server"
ID
=
"RadAjaxManager1"
DefaultLoadingPanelID
=
"RadAjaxLoadingPanel1"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadFilter1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadFilter1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"ApplyButton"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadGrid1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
runat
=
"server"
ID
=
"RadAjaxLoadingPanel1"
/>
<
telerik:RadWindow
ID
=
"RadWindow1"
runat
=
"server"
Behaviors
=
"Move,Close,Resize"
Title
=
"Filter Builder"
Modal
=
"true"
Width
=
"500"
Height
=
"350"
>
<
ContentTemplate
>
<
telerik:RadFilter
runat
=
"server"
ID
=
"RadFilter1"
FilterContainerID
=
"RadGrid1"
ShowApplyButton
=
"false"
style
=
"margin:10px 0 0 10px"
/>
<
asp:Panel
ID
=
"FilterButtonPanel"
runat
=
"server"
style
=
"margin:10px 0 0 10px;font-size:medium"
>
<
asp:LinkButton
runat
=
"server"
ID
=
"ApplyButton"
OnClick
=
"ApplyButton_Click"
Font-Names
=
"Verdana"
Font-Size
=
"Small"
Text
=
"Apply Expressions"
OnClientClick
=
"hideFilterBuilderDialog()"
/>
</
asp:Panel
>
</
ContentTemplate
>
</
telerik:RadWindow
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowPaging
=
"true"
PageSize
=
"5"
AllowSorting
=
"true"
OnItemCommand
=
"RadGrid1_ItemCommand"
AllowFilteringByColumn
=
"True"
>
<
MasterTableView
AutoGenerateColumns
=
"false"
DataKeyNames
=
"ID"
IsFilterItemExpanded
=
"false"
CommandItemDisplay
=
"Top"
>
<
CommandItemTemplate
>
<
telerik:RadToolBar
runat
=
"server"
ID
=
"RadToolBar1"
OnClientButtonClicked
=
"onPanelBarItemClicked"
>
<
Items
>
<
telerik:RadToolBarButton
Text
=
"Show filter"
CommandName
=
"OpenRadFilter"
ImageUrl="<%#GetFilterIcon() %>"
ImagePosition="Right"/>
</
Items
>
</
telerik:RadToolBar
>
</
CommandItemTemplate
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
></
CommandItemSettings
>
<
PagerStyle
Mode
=
"NumericPages"
/>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
></
CommandItemSettings
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"ID"
HeaderText
=
"ID"
UniqueName
=
"ID"
ReadOnly
=
"true"
HeaderButtonType
=
"None"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Description"
HeaderText
=
"Description"
UniqueName
=
"Description"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
form
>
</
body
>
</
html
>
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
Telerik.Web.UI;
using
System.Data;
using
System.Collections;
public
partial
class
Default14 : System.Web.UI.Page
{
protected
void
Page_Load(
object
sender, EventArgs e)
{
}
protected
void
Button1_Click(
object
sender, EventArgs e)
{
RadGrid1.DataSource = Data ;
RadGrid1.DataBind();
}
protected
void
RadGrid1_ItemCommand(
object
sender, GridCommandEventArgs e)
{
if
(e.CommandName == RadGrid.PageCommandName)
{
e.Item.OwnerTableView.CurrentPageIndex = (e
as
GridPageChangedEventArgs).NewPageIndex;
RadGrid1.DataSource = Data;
RadGrid1.DataBind();
}
if
(e.CommandName == RadGrid.SortCommandName)
{
RadGrid1.DataSource = Data ;
RadGrid1.DataBind();
}
}
public
DataTable Data
{
get
{
if
(Session[
"Data"
] ==
null
)
{
DataTable table =
new
DataTable();
table.Columns.Add(
"ID"
);
table.Columns.Add(
"Description"
);
for
(
int
i = 0; i < 10; i++)
{
table.Rows.Add(i,
"Description"
+ i.ToString());
}
Session[
"Data"
] = table;
}
return
(DataTable)Session[
"Data"
];
}
set
{
Session[
"Data"
] = value;
}
}
protected
string
GetFilterIcon()
{
//RadGrid1.Skin = RadSkinManager1.Skin ;
//RadGrid1.Rebind();
return
RadAjaxLoadingPanel.GetWebResourceUrl(Page,
string
.Format(
"Telerik.Web.UI.Skins.{0}.Grid.Filter.gif"
,
"Vista"
));
}
protected
void
ApplyButton_Click(
object
sender, EventArgs e)
{
RadFilter1.FireApplyCommand();
RadGrid1.DataSource = Data ;
RadGrid1.Rebind();
}
}
strPending = Convert.ToDouble(dataView.Table.Rows[0]["Pending"]);
strProposed = Convert.ToDouble(dataView.Table.Rows[0]["Proposed"]);
strSold = Convert.ToDouble(dataView.Table.Rows[0]["Sold"]);
strPerformed = Convert.ToDouble(dataView.Table.Rows[0]["Performed"]);
strTotal = Convert.ToDouble(dataView.Table.Rows[0]["TotalLeads"]);
//RadChart radChart = new RadChart();
RadChartLeads.ChartTitle.TextBlock.Text = "Sales Statistics";
// Create a ChartSeries and assign its name and chart type
ChartSeries chartSeries = new ChartSeries();
chartSeries.Name = "Sales";
chartSeries.Type = ChartSeriesType.Bar;
// add new items to the series,
// passing a value and a label string
//chartSeries.AddItem(double ValueType,string label, color)
chartSeries.AddItem(strPending, "Pending");
chartSeries.AddItem(strProposed, "Proposed");
chartSeries.AddItem(strSold, "Sold");
chartSeries.AddItem(strPerformed, "Performed");
chartSeries.AddItem(strTotal, "Total Leads");
// add the series to the RadChart Series collection
RadChartLeads.Series.Add(chartSeries);
// add the RadChart to the page.
//this.Page.Controls.Add(RadChartLeads);
//RadChart radChart = new RadChart();
//radChart.ChartTitle.TextBlock.Text = "Sales Statistics";
//ChartSeries chartSeries = new ChartSeries();
//chartSeries.Name = "Sales";
//chartSeries.Type = ChartSeriesType.Bar;
//chartSeries.AddItem(strPending, "Pending");
//chartSeries.AddItem(strProposed, "Proposed");
//chartSeries.AddItem(strSold, "Sold");
//chartSeries.AddItem(strPerformed, "Performed");
//chartSeries.AddItem(strTotal, "Total Leads");
//radChart.Series.Add(chartSeries);
//this.pchChart.Controls.Add(radChart);
RadChartLeads
and then in the codebehind I create theChartSeries
ect.. as you can see in the code above.