<
telerik:GridDateTimeColumn DataField="Date_input" HeaderText="Date"
UniqueName="Date_input" ReadOnly ="true"
DataType="System.DateTime">
<ItemStyle Width="130px" />
</telerik:GridDateTimeColumn>
OR
<
telerik:GridDateTimeColumn DataField="Date_input" HeaderText="Date"
UniqueName="Date_input" ReadOnly ="true"
DataFormatString="{0:dd/MM/yyyy}" DataType="System.DateTime">
<ItemStyle Width="130px" />
</telerik:GridDateTimeColumn>
In my MSSQL database it is a datetime value ex : 20/01/2009 11:20:10
My problem it is when a put exat date value in filter field, only date ... that don't work... per exemple : 20/01/2009, my row with 20/01/2009 11:20:10, not display ...
i try http://www.telerik.com/help/aspnet-ajax/grdfilteringfordatetimecolumnwithdataformatstring.html for other date format but i is not ... that work when i make greatthan filter .... i suppose that 20/01/2009 11:20:10 is not same than 20/01/2009 , it is correct in fact ...
Do you have a solution for have results with 20/01/2009 ?
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" CellSpacing="0" AllowPaging="True" GridLines="None" Skin="Default"> <MasterTableView> <Columns> <telerik:GridTemplateColumn DataField="AREA_ZIP_CODE" UniqueName="AREA_ZIP_CODE"> <HeaderTemplate> <asp:Label ID="Label2" runat="server" Text="AREA_ZIP_CODE"></asp:Label> </HeaderTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("AREA_ZIP_CODE") %>' Visible=false></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="AREA_ZIP_DESC" UniqueName="AREA_ZIP_DESC"> <HeaderTemplate> <asp:Label ID="Label3" runat="server" Text="AREA_ZIP_DESC"></asp:Label> </HeaderTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%# Eval("AREA_ZIP_DESC") %>' Visible=false></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="ACTIVE_FLAG" HeaderText="ACTIVE_FLAG" SortExpression="ACTIVE_FLAG" UniqueName="ACTIVE_FLAG"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Delete" UniqueName="Delete"> <ItemTemplate> <asp:Button ID="Button1" runat="server" Text="Delete" CommandName="Delete" /> <asp:Button ID="Button2" runat="server" Text="Cancel" CommandName="Cancel" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <PagerStyle AlwaysVisible="True" /></MasterTableView><FilterMenu EnableImageSprites="False"></FilterMenu> </telerik:RadGrid>
Protected Sub RadGrid1_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand
If e.CommandName = "Delete" Then
Delete(sender, e)
ElseIf e.CommandName = "Cancel" Then
Cancel(sender, e)
End If
End Sub
Protected Sub Delete(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs)
Dim rowNum As Integer = Convert.ToInt32(e.Item.ItemIndex)
Dim item As GridDataItem = RadGrid1.Items(rowNum)
Dim lb As Label
For Each row As GridDataItem In RadGrid1.Items
lb = item.FindControl("Label1")
If row.ItemIndex <> rowNum Then
lb.Visible = False
ElseIf row.ItemIndex = rowNum Then
lb.Visible = True
End If
Next
End Sub
Protected Sub RadGrid1_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
Dim da As New SqlDataAdapter
Dim con As New SqlConnection
Dim com As New SqlCommand
con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db.mdf;Integrated Security=True;User Instance=True"
con.Open()
com.Connection = con
com.CommandText = "SELECT * FROM [area_zip_table]"
da.SelectCommand = com
Dim dt As New DataTable
da.Fill(dt)
RadGrid1.DataSource = dt
End Sub
<telerik:RadWindowManager
ID="RadWindowManager1"
ShowContentDuringLoad="false" VisibleStatusbar="false"
runat="server"
VisibleOnPageLoad="false"
Width="894px"
Modal="true"
Behaviors="None"
EnableEmbeddedSkins="false"
EnableShadow="true"
OnClientClose="OnClientClose"
ReloadOnShow="false">
<Windows>
<telerik:RadWindow ID="radPopup" runat="server" KeepInScreenBounds="true" EnableShadow="true" />
</Windows>
</telerik:RadWindowManager><telerik:RadGrid runat="server" ID="radgrid" AutoGenerateColumns="false" OnNeedDataSource="radgrid_NeedDataSource"> <MasterTableView> <Columns> <telerik:GridTemplateColumn DataField="Text" HeaderText="foo"> <ItemTemplate> <%# Eval("Text") %> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="Text" HeaderText="bar" Visible="false" /> <telerik:GridEditCommandColumn HeaderText="Edit" /> </Columns> </MasterTableView></telerik:RadGrid>