Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
264 views
Hi, I am using

<MasterTableView AutoGenerateColumns="true" AllowFilteringByColumn="True"

to auto generate columns in grid and allow filtering, I would like to allow user to press enter to apply filter, and limit each filter by to 50px only for their width.

I was using this when i used to predefine the columns :

<telerik:GridBoundColumn FilterControlWidth="50px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo"

how to do this with auto generated columns?  Thanks.

Regards,
Alex
Jayesh Goyani
Top achievements
Rank 2
 answered on 04 Sep 2014
6 answers
258 views
I have two asp panels with ID's Panelcombo and PanelGrid .Panelcombo contains 6 comboxes and Panel Grid contains 1 radgrid. After filling all comboboxes I am showing Radgrid.I have RadAjaxManger with the following setting
<telerik:RadAjaxManager ID="ajman" runat="server">
 
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="Panelcombo">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="Panelcombo"/>
                  <telerik:AjaxUpdatedControl ControlID="PanelGrid"/>
            </UpdatedControls>
        </telerik:AjaxSetting>
 </AjaxSettings>
</telerik:RadAjaxManager>
                   Radgrid contains RadNumerictextbox which has Client event as follows
<ClientEvents OnValueChanged="ValueChanged" />
    which is not firing
Konstantin Dikov
Telerik team
 answered on 04 Sep 2014
7 answers
164 views
Hi,
When I set the hierarchyloadmode to client I am having a strange issue. The first row is supposed to have one detail table row but it has over 50 blank ones. The problem only seems to happen for the first row of the master table, the rest are fine. When I set the mode back to default, the issue is not there. Has anyone else seen this?
Angel Petrov
Telerik team
 answered on 04 Sep 2014
1 answer
149 views
I need some control like Image Manager from RadEditor. Does telerik have seperate control like ImageManager because i do not want to use it with RadEditor.

i need to exactly same funcationality like Image Manager

Ianko
Telerik team
 answered on 04 Sep 2014
1 answer
154 views
hi everybody,
i am tring to refill the marker.
when the page first loading no problem very thing works perfect. But if i want to re bind the maps. Markers again same place how can i solve this problem


    Private Sub FillHareket(ByVal Usrid As String, ByVal strv As String)
        Try
            bastar = StartDate.SelectedDate
            BitTar = EndDate.SelectedDate
        Catch ex As Exception

        End Try

        Dim str As String = ""
        If CheckBox1.Checked Then
            str = "0"
        End If

        If CheckBox2.Checked Then
            If str <> "" Then
                str += ",1"
            Else
                str = "1"
            End If
        End If

        Dim test As String = " "
        'Usrid = "HEPSI"

        Dim ds As DataSet
        test = " SELECT * FROM ("
        If Usrid = "HEPSI" Then
            test += "SELECT (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) as renk,Userid, tarih, (CASE WHEN tipi=0 THEN 'Ziyaret' ELSE 'SipariÅŸ' END) AS Tipi, TCari.Unvan, (CASE WHEN THareket.Enlem=0 THEN 41.058175  ELSE THareket.Enlem END) AS Enlem , (CASE WHEN THareket.Boylam=0 THEN 28.80995+RAND(ROW_NUMBER() OVER (ORDER BY Tarih))/1000 ELSE THareket.Boylam END) AS Boylam, Miktar, Tutar,cast( resim1 as nvarchar(200)) as resim1,cast( resim2 as nvarchar(200)) as resim2,cast( resim3 as nvarchar(200)) as resim3,cast( resim4 as nvarchar(200)) as resim4,THareket.EvrakNo, (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) AS GPSYOK ,'' as carino ,'' as BolgeKodu FROM THareket INNER JOIN TCari ON THareket.CariNo=TCari.CariNo  WHERE (Tarih>=@Tarihbas AND Tarih<@Tarihbit) and thareket.tipi in (" + str + ") "
            'test += "SELECT (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) as renk,Userid, tarih, (CASE WHEN tipi=0 THEN 'Ziyaret' ELSE 'SipariÅŸ' END) AS Tipi, TCari.Unvan, (CASE WHEN THareket.Enlem=0 THEN 41.058175  ELSE THareket.Enlem END) AS Enlem , (CASE WHEN THareket.Boylam=0 THEN 28.80995+RAND(ROW_NUMBER() OVER (ORDER BY Tarih))/1000 ELSE THareket.Boylam END) AS Boylam, Miktar, Tutar,cast( resim1 as nvarchar(200)) as resim1,cast( resim2 as nvarchar(200)) as resim2,cast( resim3 as nvarchar(200)) as resim3,cast( resim4 as nvarchar(200)) as resim4,THareket.EvrakNo, (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) AS GPSYOK ,'' as carino ,'' as BolgeKodu FROM THareket INNER JOIN TCari ON THareket.CariNo=TCari.CariNo  WHERE thareket.tipi='0' "
        Else
            test += "SELECT (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) as renk,Userid, tarih, (CASE WHEN tipi=0 THEN 'Ziyaret' ELSE 'SipariÅŸ' END) AS Tipi, TCari.Unvan, (CASE WHEN THareket.Enlem=0 THEN 41.058175  ELSE THareket.Enlem END) AS Enlem , (CASE WHEN THareket.Boylam=0 THEN 28.80995+RAND(ROW_NUMBER() OVER (ORDER BY Tarih))/1000 ELSE THareket.Boylam END) AS Boylam, Miktar, Tutar,cast( resim1 as nvarchar(200)) as resim1,cast( resim2 as nvarchar(200)) as resim2,cast( resim3 as nvarchar(200)) as resim3,cast( resim4 as nvarchar(200)) as resim4,THareket.EvrakNo, (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) AS GPSYOK ,'' as carino ,'' as BolgeKodu FROM THareket INNER JOIN TCari ON THareket.CariNo=TCari.CariNo  WHERE " & IIf(Usrid <> "", "Userid='" & Usrid & "' AND", "") & "  (Tarih>=@Tarihbas AND Tarih<@Tarihbit) and thareket.tipi in (" + str + ") "
        End If

        If CheckBox3.Checked Then
            test += IIf(CheckBox1.Checked Or CheckBox2.Checked, " union ", "")
            test += "SELECT '3' as renk,'' as Userid,''as tarih,'Bayi' as Tipi, TCari.Unvan AS Unvan, MAX(TDHareket.Enlem) AS Enlem, MAX(TDHareket.Boylam) AS Boylam,0 as Miktar,0 as Tutar,'' as resim1,'' as  resim2,'' as resim3,'' as resim4,'' as EvrakNo,0 as GPSYOK  ,TDHareket.carino AS CariNo, TCari.BolgeKodu FROM TDHareket INNER JOIN TCari ON TDHareket.Carino=TCari.carino where   TDHareket.Enlem<>0 AND TDHareket.Boylam<>0 "
            If Usrid = "HEPSI" Then
                test += " GROUP BY TDHareket.carino, TCari.Unvan, TCari.BolgeKodu"
            Else
                test += " and TCari.BolgeKodu='" + HiddenField5.Value + "' GROUP BY TDHareket.carino, TCari.Unvan, TCari.BolgeKodu"
            End If

        End If

        Dim _param(1) As SqlParameter
        _param(0) = New SqlParameter("@Tarihbas", bastar)
        _param(1) = New SqlParameter("@Tarihbit", BitTar)
        test += " )as G ORDER BY GPSYOK,Tipi desc,Tarih desc"
        ds = GetData(test, _param, Nothing)

        If ds.Tables.Count > 0 Then
            RadGrid2.DataSource = ds
            RadGrid2.DataBind()
        End If

        RadMap1.DataSource = ds
        RadMap1.DataBind()

    End Sub
Ianko
Telerik team
 answered on 04 Sep 2014
10 answers
480 views
Hi all,
I have a RadGrid to display all the data from a SqlDataSource which is calling a stored procedure that generate dynamic column name and data.
The first column of the RadGrid is a link column and the following column is generated from the SP.
Due to the dynamic columns, so i cannot pre-set any column setting in the RadGrid such as $ currency sign and thousand separator,
I have to set it during the RadGrid1_ItemDataBound event, but the RadGrid doesn't show the currency format when it first load,
the RadGrid only show the correct currency format after Column Grouping (Ajax).

Anyway to show the correct currency format during the RadGrid first load?

Thanks!
George


<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AllowSorting="false"
            DataSourceID="SqlDataSource1" ShowGroupPanel="True" Font-Size="3pt" Width="950px" Height="600px">
            <ExportSettings FileName="ExportToExcel">
            </ExportSettings>
            <ClientSettings AllowColumnsReorder="false" AllowDragToGroup="True" ReorderColumnsOnClient="True">
                <Scrolling AllowScroll="True" UseStaticHeaders="false" />
                <Resizing AllowColumnResize="false" AllowRowResize="false" ResizeGridOnColumnResize="false"
                    ClipCellContentOnResize="False" EnableRealTimeResize="True" AllowResizeToFit="True" />
            </ClientSettings>
            <MasterTableView DataSourceID="SqlDataSource1">
                <CommandItemSettings ShowRefreshButton="false" ShowExportToCsvButton="True" ShowExportToExcelButton="True" ShowExportToPdfButton="True" ShowExportToWordButton="True" />
                <Columns>
                    <telerik:GridHyperLinkColumn UniqueName="Link" DataNavigateUrlFields="MasterID" DataNavigateUrlFormatString="JavaScript:openwindow('{0}');" Text ="View"
                    </telerik:GridHyperLinkColumn>
                </Columns>
 
            </MasterTableView>
        </telerik:RadGrid>


Code Behind:
Private Sub RadGrid1_ItemDataBound(sender As Object, e As GridItemEventArgs) Handles RadGrid1.ItemDataBound
 
    If TypeOf e.Item Is GridDataItem AndAlso e.Item.ItemIndex = 0 Then
        Dim dataItem As GridDataItem = TryCast(e.Item, GridDataItem)
        For Each col As GridColumn In dataItem.OwnerTableView.RenderColumns
            Dim numCol As GridNumericColumn = TryCast(col, GridNumericColumn)
            If numCol IsNot Nothing Then
                numCol.DataFormatString = "{0:C2}"
                numCol.ItemStyle.HorizontalAlign = HorizontalAlign.Right
 
            End If
        Next
    End If
 
End Sub



Konstantin Dikov
Telerik team
 answered on 04 Sep 2014
1 answer
80 views
We have localized our RadEditor for a French client, but they noted that the Bold (B) and Underline (U) icons should be G and S in French environments.
Do we have to create our own G and S images and override the background-image styles using CSS, or do you have another recommendation?

--Tom
Ianko
Telerik team
 answered on 04 Sep 2014
4 answers
225 views
How to draw horizontal line, just like dashed or dotted.
Danail Vasilev
Telerik team
 answered on 04 Sep 2014
1 answer
143 views
i have a plain asp radio button in Rad Grid and Checked property is set as "true" in aspx.

i am not changing the radio button selection neither code behind nor java script.

when i bind data to grid in page load then radio button is appearing as selected but after re-bind data through Ajax manager call then this radio button is getting un-selected.

i have a asp check box also like radio button but its not un-selected. but what went wrong with radio button alone?

does any one came across this issue.

Appreciate your help.

Eyup
Telerik team
 answered on 04 Sep 2014
1 answer
183 views
Hi All,

I am getting a javascript error from the telerik script manager. It does not happen all the time and seems to happen in different places in the code (there are no set steps I can repeat to generate it).

The error is 12031, I can't seem to find anything helpful in google and I was just wondering if anyone has seen this before and knows where to look to track it down.

Dan.
Viktor Tachev
Telerik team
 answered on 04 Sep 2014
Narrow your results
Selected tags
Tags
+? more
Top users last month
Shiori
Top achievements
Rank 2
Iron
Tien
Top achievements
Rank 1
Iron
Robert
Top achievements
Rank 1
Rob
Top achievements
Rank 4
Bronze
Bronze
Iron
Geoff
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Shiori
Top achievements
Rank 2
Iron
Tien
Top achievements
Rank 1
Iron
Robert
Top achievements
Rank 1
Rob
Top achievements
Rank 4
Bronze
Bronze
Iron
Geoff
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?