I am trying to format a date column to MM/dd/yyyy but reguardless of what formatting I attempt it continues to return M/d/yyyy hh:mm:ss AM.
On load of the page I set the ObjetDataSource and convert to a datatable
public static DataTable LoadGrid()
{
using (Model.Entities db = new Model.Entities())
{
List<
Model.FileDetailViewNew
> fileView = (from filing in db.FileDetailViewNews
select filing).ToList();
DataTable table = ToDataTable(fileView);
return table;
}
}
private static DataTable ToDataTable<
T
>(List<
T
> items)
{
DataTable dataTable = new DataTable(typeof(T).Name);
//Get all the properties
PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (PropertyInfo prop in Props)
{
//Setting column names as Property names
dataTable.Columns.Add(prop.Name);
}
foreach (T item in items)
{
var values = new object[Props.Length];
for (int i = 0; i < Props.Length; i++)
{
//inserting property values to datatable rows
values[i] = Props[i].GetValue(item, null);
}
dataTable.Rows.Add(values);
}
//put a breakpoint here and check datatable
return dataTable;
}
I then on the page set the grid to the datasource
<
asp:ObjectDataSource
ID
=
"ObjectDataSource1"
runat
=
"server"
TypeName
=
"AllFilings"
SelectMethod
=
"LoadGrid"
></
asp:ObjectDataSource
>
<
div
id
=
"load"
style
=
"display: none; color: Red"
>
<
b
> Updating filing status please wait...</
b
>
</
div
>
<
div
id
=
"status"
style
=
"color: Red"
>
</
div
>
<
telerik:RadGrid
ID
=
"gridFilings"
runat
=
"server"
PageSize
=
"20"
AllowPaging
=
"True"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
EnableAJAX
=
"True"
DataSourceID
=
"ObjectDataSource1"
EnableAJAXLoadingTemplate
=
"True"
GridLines
=
"None"
LoadingTemplateTransparency
=
"50"
EnableLinqExpressions
=
"false"
ShowStatusBar
=
"True"
Skin
=
"Outlook"
Width
=
"98%"
ShowGroupPanel
=
"True"
>
<
ClientSettings
AllowDragToGroup
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
></
PagerStyle
>
<
MasterTableView
DataKeyNames
=
"FileID"
DataSourceID
=
"ObjectDataSource1"
AllowCustomSorting
=
"true"
>
and then on the grid item
<
telerik:GridTemplateColumn
DataField
=
"DateIn"
HeaderText
=
"Date In"
SortExpression
=
"DateIn"
UniqueName
=
"DateIn"
GroupByExpression
=
"DateIn Group By DateIn"
>
<
ItemTemplate
>
<%# Eval("DateIn","{0:yyyy MMMM/dd}")%>
</
ItemTemplate
>
<
HeaderStyle
CssClass
=
"headerLeft"
/>
</
telerik:GridTemplateColumn
>
I have tried numerous different formatting styles with no success. I have also tried to change it to a DateTimeColumn and format it there and it stiil continues to show for example 6/4/2014 12:00:00 AM
Hi
I have incorporated a RadHtmlChart on my application and have all the data binding and series set up done client side. The chart displays and has the required functionality except for one thing:
The first time I click on a legend item nothing happens. After this any subsequent clicks have the desired outcome i.e. the series' and legend item's visibility changes. I am not sure why the initial click does not perform these default functions but the 2nd, 3rd, etc clicks do. Can you help? Is there an initialisation I am missing that is triggered by the first click? Is there an extra bind/refresh/redraw needed?
I appreciate there is no code listed but I'm hoping this is a generic question that someone can help me with.
Thanks
Michael
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
<script type="text/javascript"> |
function OnRequestStart(sender, args) |
{ |
args.set_enableAjax(true); |
} |
function OnResponseEnd(sender, args) |
{ |
args.set_enableAjax(false); |
} |
</script> |
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> |
<AjaxSettings> |
<telerik:AjaxSetting AjaxControlID="radGrid"> |
<UpdatedControls> |
<telerik:AjaxUpdatedControl ControlID="radGrid" LoadingPanelID="alpGrid" /> |
</UpdatedControls> |
</telerik:AjaxSetting> |
</AjaxSettings> |
<ClientEvents OnRequestStart="OnRequestStart" OnResponseEnd="OnResponseEnd" /> |
</telerik:RadAjaxManager> |
<telerik:RadAjaxPanel ID="radPanel" runat="server" ClientEvents-OnRequestStart="OnResponseEnd" ClientEvents-OnResponseEnd="OnRequestStart"> |
<asp:ImageButton ID="cmdExportToExcel" Style="cursor: pointer;" ImageUrl="~/DesktopModules/Slideshow/Images/excel-tips-tricks.png" |
AlternateText="Export to Excel" runat="server" |
onclick="cmdExportToExcel_Click"></asp:ImageButton> |
<asp:ImageButton ID="cmdExportToWord" Style="cursor: pointer;" ImageUrl="~/DesktopModules/Slideshow/Images/word-tips-tricks.png" |
AlternateText="Export to Word" runat="server" |
onclick="cmdExportToWord_Click"></asp:ImageButton> |
<asp:ImageButton ID="cmdExportToPdf" Style="cursor: pointer;" ImageUrl="~/DesktopModules/Slideshow/Images/pdf_icon.gif" Width="35px" |
AlternateText="Export to Pdf" runat="server" |
onclick="cmdExportToPdf_Click"></asp:ImageButton> |
<asp:Label ID="lblExport" runat="server" /> |
</telerik:RadAjaxPanel> |
<telerik:RadAjaxLoadingPanel ID="alpGrid" runat="server" Transparency="30"> |
<asp:Image ID="Image1" ImageUrl="~/DesktopModules/Slideshow/images/loading.gif" AlternateText="Loading. Please wait..." BorderWidth="0px" runat="server"></asp:Image> |
</telerik:RadAjaxLoadingPanel> |
/* RadSlider for ASP.NET AJAX Default Skin */
.RadSlider .rslTrack
{
border-color:#b9b9b9 #939393 #939393 #b9b9b9;
height:400px;
}
.RadSlider .rslHorizontal a.rslHandle
{
background-image:url('Slider/Handles.gif');
}
.RadSlider .rslHorizontal a.rslDraghandle
{
background-image:url('Slider/DragHandle.gif');
}
.RadSlider .rslTop a.rslDraghandle
{
background-image:url('Slider/DragHandleDown.gif');
}
.RadSlider .rslHorizontal .rslTrack
{
background:url('Slider/TrackBgr.gif') repeat-x;
}
.RadSlider .rslHorizontal .rslSelectedregion
{
background:url('Slider/SelectedRegionHorizontalBgr.gif') right top no-repeat;
}
/* vertical slider */
.RadSlider .rslVertical
{
}
.RadSlider .rslVertical a.rslHandle
{
background-image:url('Slider/HandlesVertical.gif');
}
.RadSlider .rslVertical .rslTrack
{
height:500px;
background: url('Slider/TrackVerticalBgr.gif') repeat-y ;
}
.RadSlider .rslVertical .rslSelectedregion
{
height:100px;
background:url('Slider/SelectedRegionVerticalBgr.gif') left bottom no-repeat;
}
.RadSlider .rslVertical a.rslDraghandle
{
background:url('Slider/DragVerticalHandle.gif') no-repeat;
}
.RadSlider .rslLeft a.rslDraghandle
{
background:url('Slider/DragVerticalHandleRight.gif') no-repeat;
}
.RadSlider .rslItem,
.RadSlider .rslLargeTick span
{
color:#333;
}
.RadSlider .rslItemsWrapper .rslItemSelected
{
color:#000;
}
/* horizontal slider items */
.RadSlider .rslHorizontal .rslItem
{
background-image:url('Slider/ItemHorizontalBgr.gif');
}
/* vertical slider items */
.RadSlider .rslVertical .rslItem
{
background-image:url('Slider/ItemVerticalBgr.gif');
}
/* horizontal slider - TrackPosition=Top/Bottom */
.RadSlider .rslTop .rslSmallTick,
.RadSlider .rslBottom .rslSmallTick
{
background-image:url('Slider/SmallChangeHorizontal.gif');
}
.RadSlider .rslTop .rslLargeTick,
.RadSlider .rslBottom .rslLargeTick
{
background-image:url('Slider/LargeChangeHorizontal.gif');
}
/* vertical slider - TrackPosition=Left/Right */
.RadSlider .rslLeft .rslSmallTick,
.RadSlider .rslRight .rslSmallTick
{
background-image:url('Slider/SmallChangeVertical.gif');
}
.RadSlider .rslLeft .rslLargeTick,
.RadSlider .rslRight .rslLargeTick
{
background-image:url('Slider/LargelChangeVertical.gif');
}
/* horizontal slider - TrackPosition=Center */
.RadSlider .rslMiddle .rslSmallTick
{
background-image:url('Slider/SmallChangeMiddleHorizontal.gif');
}
.RadSlider .rslMiddle .rslLargeTick
{
background-image:url('Slider/LargeChangeMiddleHorizontal.gif');
}
/* vertical slider - TrackPosition=Center */
.RadSlider .rslCenter .rslSmallTick
{
background-image:url('Slider/SmallChangeCenterVertical.gif');
}
.RadSlider .rslCenter .rslLargeTick
{
background-image:url('Slider/LargelChangeCenterVertical.gif');
}
DIV.RadSlider .rslTrack {
WIDTH: 500px;
}
<
ChartTitle
Text
=
"Total"
>
<
Appearance
Align
=
"Center"
BackgroundColor
=
"White"
Position
=
"Top"
></
Appearance
>
</
ChartTitle
>
<
Legend
>
<
Appearance
BackgroundColor
=
"White"
Position
=
"Right"
Visible
=
"true"
></
Appearance
>
</
Legend
>
<telerik:GridBoundColumn DataField="contactmobile" HeaderText="Mobile"
SortExpression="mobile" UniqueName="contactmobile">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn DataField="address" HeaderText="Address"
SortExpression="Address" UniqueName="Address">
<EditItemTemplate>
<asp:TextBox ID="addressTextBox" TextMode="MultiLine" Width="300px" Height="75px"
runat="server" Text='<%# Bind("address") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="addressLabel" runat="server" Text='<%# Eval("address") %>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
code behind:
protected void RadGrid1_ItemInserted(object source, GridInsertedEventArgs e)
{
GridEditFormInsertItem editformItem = (GridEditFormInsertItem)e.Item;
TextBox contactmobile = (TextBox)editformItem["contactmobile"].Controls[0];
// working fine
TextBox address = (TextBox)editformItem["address"].Controls[0];
// working fine not working
// dumps with Cannot find cell bound to column with unique name 'address'
}
How do I read the value from Address here ??
Thx
Torben
Hello,
I have implemented a drag-drop from one Radgrid to another. When the target grid receives a drop, it updates a SQL table. The target grid is using a DataSourceID to the said SQL table. I have placed a Radgrid.Rebind() in the postback call. Everything works great - except for the first time. When I drop the first item, the target grid does not update but I can see that it updated the SQL table. After the first item, I can continuously drop more items from the source grid and the target grid will refresh every time to represent the data in the SQL table using the Rebind in postback. What would cause the first instance of a rebind to not work properly?
I saw on some posts to place the Rebind in the page's PreRender event but that also did not work. Any suggestions are much appreciated. Thank you.