or
protected function fixdate(byref dt as datatable) as datatable for each myrow in dt.rows try myrow("send_date") = cdate(myow("send_date")).tostring("dd/MM/yyyy") catch ex as exception ... end try next return dtwhen I debug - everything works fine, but when I open the grid in my server application (at run time) - the date change format to "mm/dd/yyyy"
that's the grid code:
<telerik:RadGrid Skin="innovation" EnableEmbeddedSkins="false" ID="RadGrid1" dir="rtl" HeaderStyle-ForeColor="White" AllowFilteringByColumn="True" AllowSorting="True" AllowPaging="True" BorderColor="#74ABAE" BackColor="White" BorderWidth="2px" runat="server" HeaderStyle-Font-Size="Small" ItemStyle-Font-Size="Small" AlternatingItemStyle-Font-Size="Small" ItemStyle-BackColor="White" ItemStyle-ForeColor="Black" PageSize="7" AutoGenerateColumns="False" PagerStyle-Font-Size="Small" AlternatingItemStyle-ForeColor="Black" Culture="Hebrew" GridLines="Vertical" Width="666px" style="margin-right: 30px"> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Black"> </HeaderContextMenu> <ItemStyle BackColor="White" Font-Size="Small" ForeColor="Black" /> <PagerStyle mode="NumericPages" ShowPagerText="false"></PagerStyle> <MasterTableView> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <Columns> <telerik:GridBoundColumn CurrentFilterFunction="Contains" DataField="IDEA_CODE" UniqueName="IDEA_CODE" HeaderText="ideanum" AutoPostBackOnFilter="true" DataType="System.Int32"> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="LINK" DataField="LINK" HeaderText="" DataType="System.String" Display="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ROWNUM" HeaderText="#" Visible="false" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.Int32"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SENDER_ID" HeaderText="id" UniqueName="SENDER_ID" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.String"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="FULLNAME" HeaderText="namef" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.String"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SUBJECT" HeaderText="sub" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.String"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DESCRIPTION" HeaderText="status" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.String"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SEND_DATE" HeaderText="sdate" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.DateTime" DataFormatString="{0:dd/MM/yy}"> </telerik:GridBoundColumn> <telerik:GridImageColumn HeaderText="comments" UniqueName="FBIMG"> </telerik:GridImageColumn> </Columns> ........can you tell me what causing that problem?
kind regards, Dana
<telerik:AjaxSetting AjaxControlID="BtnSelectItem"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="pnlProjectDetails" /> <telerik:AjaxUpdatedControl ControlID="PnlLocalMenu" /> <telerik:AjaxUpdatedControl ControlID="pnlItemDetails" /> <telerik:AjaxUpdatedControl ControlID="navBarFader" /> </UpdatedControls></telerik:AjaxSetting><asp:Panel ID="pnlSelectedItem" runat="server"> <asp:Panel ID="pnlItemDetails" CssClass="ProjectDetails" runat="server"> <asp:PlaceHolder ID="phItemDetails" runat="server"></asp:PlaceHolder> </asp:Panel></asp:Panel>protected void Page_Load(object sender, EventArgs e) { } protected void RadMenu1_ItemClick(object sender, Telerik.Web.UI.RadMenuEventArgs e) { lblContent.Text = "u clicked " + e.Item.Text; } protected void RadToolBar1_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e) { lblContent.Text = "u clicked " + e.Item.Text; } protected void RadTabStrip1_TabClick(object sender, Telerik.Web.UI.RadTabStripEventArgs e) { lblContent.Text = "u clicked " + e.Tab.Text; } protected void RadButton_addControl_Click(object sender, EventArgs e) { int i; for (i = 0; i < 4; i++) { CheckBox ch = new CheckBox(); ch.ID = "ch" + i.ToString(); this.form1.Controls.Add(ch); } }<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><%@ 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> <style type="text/css" media="screen"> #content { height: 165px; width: 500px; margin-left: 75px; vertical-align: top; } #tabs { margin-left: 75px; width: 500px; vertical-align: bottom; } </style></head><body style="height: 437px"> <form id="form1" runat="server"> <asp:ScriptManager ID = "ScriptManager1" runat = "server"></asp:ScriptManager> <div> <telerik:RadMenu ID="RadMenu1" Runat="server" style="top: 0px; left: 0px" onitemclick="RadMenu1_ItemClick"> <Items> <telerik:RadMenuItem runat="server" Text="Edit"> <Items> <telerik:RadMenuItem runat="server" Text="copy"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Text="cut"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Text="paste"> </telerik:RadMenuItem> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Text="print"> </telerik:RadMenuItem> </Items> </telerik:RadMenu> </div> <br /> <br /> <div> <telerik:RadToolBar ID="RadToolBar1" Runat="server" onbuttonclick="RadToolBar1_ButtonClick" Orientation="Vertical" Width="70px"> <Items> <telerik:RadToolBarDropDown runat="server" Text="edit"> <Buttons> <telerik:RadToolBarButton runat="server" Text="copy"> </telerik:RadToolBarButton> <telerik:RadToolBarButton runat="server" Text="cut"> </telerik:RadToolBarButton> <telerik:RadToolBarButton runat="server" Text="paste"> </telerik:RadToolBarButton> </Buttons> </telerik:RadToolBarDropDown> <telerik:RadToolBarSplitButton runat="server" Text="print"> </telerik:RadToolBarSplitButton> </Items> </telerik:RadToolBar> </div> <br /> <br /> <div id="content" runat="server"> <asp:Label ID="lblContent" runat="server" Text="Label"></asp:Label> <div id="tabs" runat="server"> <telerik:RadTabStrip ID="RadTabStrip1" runat="server" Orientation="HorizontalBottom" Skin="WebBlue" OnTabClick="RadTabStrip1_TabClick" SelectedIndex="0" Width="500px"> </telerik:RadTabStrip> </div> </div> <telerik:RadButton ID="RadButton_addControl" runat="server" </form> </body></html>