<telerik:RadGrid ID ="rgSkills" runat ="server" DataSourceID ="sdsEmployee" AutoGenerateColumns="False" EnableAjax="true" OnInsertCommand ="rgSkills_InsertCommand"
OnUpdateCommand ="rgSkills_UpdateCommand" OnNeedDataSource ="rgSkills_NeedDataSource"
EnableValidation ="True" GridLines="None">
<MasterTableView GridLines ="None" DataSourceID ="sdsEmployee" DataKeyNames ="emp_skill_set_id"
EditMode="Inplace" AutoGenerateColumns ="False" CommandItemDisplay ="Top" runat ="server"
allowcustompaging="False" allownaturalsort="False" AllowAutomaticUpdates ="false">
<Columns>
<telerik:GridTemplateColumn DataField="Skill Description" HeaderText="Skills" >
<ItemTemplate>
<asp:LinkButton id="Skills" runat="server" text='<%# Eval("Skill Description") %>'
CommandName ="Update" />
</ItemTemplate>
</telerik:GridTemplateColumn><telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName ="EditCommandColumn"
EditText ="Edit" />
<telerik:GridBoundColumn UniqueName="Skill Description" DataField="Skill Description"
HeaderText="Skill Set Rating" ItemStyle-Font-Size ="Smaller" >
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="Comment" DataField="Comment" HeaderText="Comment"
ItemStyle-Font-Size ="Smaller" >
</telerik:GridBoundColumn>
''
'
'
psk

Hi,
I have set up some code that fires when the "save changes" link it clicked during a batchedit session. The only goal I have here is to set the border color to red if the number entered does not fall into a certain range. I've left the test for the range out of the code below because it isn't important.
I have looked through countless telerik posts and finally came upon a line of code to set the bordercolor of the cell to red that doesn't blow up and tell me that some part of the line of code has a property or method that doesn't exist in the idcell object (see below); the line of code does execute with no error:
idCell.style.backgroundColor == "red";
However the cell border does not turn red;
I am confident that the code I'm using does access the cell because this line does work:
var id = batchManager.getCellValue(idCell);
So basically I can't figure out how to turn the border color to red. Here is a boiled down version of the code to give you an idea of what code I'm using. Any help would be appreciated:
if (args.get_commandName() == "BatchEdit") {
var masterTable = sender.get_masterTableView();
var batchManager = sender.get_batchEditingManager();
var dataItems = masterTable.get_dataItems();
var idCell = dataItems[i].get_cell("LINE")
var id = batchManager.getCellValue(idCell);
var regexpString = "^\\d+\\.\\d{0,decimal}$";
var fieldValid = regexp.test(id);
if (fieldValid)
batchManager.changeCellValue(idCell, id);
idCell.style.backgroundColor == "red"; //THIS DOES NOT TURN TO BORDER TO RED
}

Over the last few weeks we've started to get reports from multiple users that have a radwindow sizing issue on Apple Mobile devices. When the window launches it launches off the screen and the scroll doesn't work. We've isolated it to instances where the button that launches the radwindow is below radtabs or a block of text. It is as if the device can no longer find the window size/location. The same radwindows worked fine before the most recent Apple IOS update. We can replicate the issue on updated Apple iPhones and can replicate that the issue doesn't happen on Apple iPhones without the update.
Is there something we can do to overcome the issue?
I have a GridBoundColumn in my RadGrid that displays a true or false value. In the database, this is stored as a 1 or a 0. During the ItemDataBound event, I check the incoming value for this column and override it to either be the string "TRUE" or the string "FALSE". However, the RadGrid is still identifying the column's datatype as an integer so the filter menu doesn't have certain filtering options like "Contains". I tried to manually set the DataType to "System.String" on both the column itself and during the ItemDataBound event and, while this provides me the filter menu I want, the functions inside don't work (clicking "contains", for example, does nothing at all).
Is there anyway for me to force the filter options to match the values after DataBound?
Thanks!

Dear All,
i am trying to create form as amount inputter, using RadNumericText and CompareValidator (to compare min max value between RadNumeric) through code behind. CompareValidator work perfectly where value of RadNumeric doesn't contain digit behind commas (attached images : data no 1), but, when i'm inputted value with commas, it's doesn't working as expected, as shown in the attached images.
No City Min Max
1 Aceh $ 100.001,00 $ 100.000,00
*Amount min cannot be greater than amount max
2. Yogya $ 100.000,00 $ 100.000,00
3. Banten $ 100.000,88 $ 100.000,99
*Amount min cannot be greater than amount max
From data above, no 1, CompareValidator working perfectly, but not for data no 3, where value has any digit behind commas. Any advice how to compare min max value with commas at data no 3 ?
Regard,
Ragil
protected RadNumericTextBox mytextbox;public void InstantiateIn(System.Web.UI.Control container){ mytextbox = new RadNumericTextBox(); mytextbox.AutoPostBack = false; mytextbox.ID = rankName + typeName + "MyTextBox"; mytextbox.NumberFormat.DecimalDigits = 2; mytextbox.NumberFormat.GroupSeparator = "."; mytextbox.NumberFormat.DecimalSeparator = ","; mytextbox.Type = NumericType.Currency; //mytextbox.DataType = "System.Decimal"; reqValid = new RequiredFieldValidator(); reqValid.ForeColor = System.Drawing.Color.Red; reqValid.ErrorMessage = "* Required field"; reqValid.CssClass = "has-error"; reqValid.ControlToValidate = rankName + typeName + "MyTextBox"; reqValid.Display = ValidatorDisplay.Dynamic; if (typeName == "Max") { compValid = new CompareValidator(); compValid.ForeColor = System.Drawing.Color.Red; compValid.ErrorMessage = "* Amount Min can not be greater than Amount Max"; compValid.CssClass = "has-error"; compValid.Display = ValidatorDisplay.Dynamic; compValid.ControlToValidate = rankName + "Max" + "MyTextBox"; compValid.ControlToCompare = rankName + "Min" + "MyTextBox"; compValid.Operator = ValidationCompareOperator.GreaterThanEqual; compValid.Type = ValidationDataType.Currency; compValid.ValidationGroup = "ValidateAmount"; } container.Controls.Add(mytextbox); container.Controls.Add(reqValid); if (typeName == "Max") { container.Controls.Add(compValid); }}
Hello,
I have a radcombobox, and when I disable it, I can still enter text in the textbox. How can I also disable the textbox so no text can be enter when my combobox is desabled ?
Thanx for your help.

<telerik:RadGrid ID="rgd_TaskPermissions" runat="server" GridLines="None" AutoGenerateColumns="False" Width="320px"> <MasterTableView> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="Object" HeaderText="Table" SortExpression="Object" UniqueName="Object" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Select" HeaderText="Select" SortExpression="Select" UniqueName="Select" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Update" HeaderText="Update" SortExpression="Update" UniqueName="Update" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Insert" HeaderText="Insert" SortExpression="Insert" UniqueName="Insert" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Delete" HeaderText="Delete" SortExpression="Delete" UniqueName="Delete" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn UniqueName="TemplateColumn"> <ItemTemplate> <asp:Button ID="btn_ModifyPerms" runat="server" Text="Modify" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid> Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load Label1.Text = Session("Object") rgd_TaskPermissions.DataSource = GetPermissions() rgd_TaskPermissions.DataBind() End SubPrivate Function GetPermissions() As DataTable Dim Table As String = Session("Object") Dim DatabaseName As String = Session("DBName") Dim Grantee As String = Session("TaskRole") Dim connectionString = New SqlConnection("server=DO-IT-AB\MSSQLAB;database=AeriesAdmin;UID=XXX;PWD=XXX;") Dim command = New SqlCommand("aa_task_table_permissions_by_object", connectionString) command.CommandType = CommandType.StoredProcedure command.Parameters.Add("@DBName", SqlDbType.VarChar).Value = DatabaseName command.Parameters.Add("@Grantee", SqlDbType.VarChar).Value = Grantee command.Parameters.Add("@Table", SqlDbType.VarChar).Value = Table command.Connection.Open() Dim myDataAdapter As New SqlDataAdapter(command) Dim myDataSet As New DataSet Dim dtData As New DataTable myDataAdapter.Fill(myDataSet) Return myDataSet.Tables(0) command.Connection.Close() End FunctionUSE [AeriesAdmin] GO SET ANSI_NULLS ONGO SET QUOTED_IDENTIFIER ONGO CREATE PROCEDURE [dbo].[aa_task_table_permissions_by_object] @dbname sysname, @Grantee varchar(25), @Table varchar(25) AS BEGIN IF OBJECT_ID('tempdb..#tmpResults') IS NOT NULL DROP TABLE #tmpResults CREATE TABLE #tmpResults ( [Owner] NVARCHAR(MAX), [Object] NVARCHAR(MAX), [Grantee] NVARCHAR(MAX), [Grantor] NVARCHAR(MAX), [ProtectType] NVARCHAR(MAX), [Action] NVARCHAR(MAX), [Column] NVARCHAR(MAX) ) DECLARE @sp_executesql nvarchar(1024) SELECT @sp_executesql = @dbname + '.sys.sp_executesql' INSERT INTO #tmpResults ( [Owner], [Object], [Grantee], [Grantor], [ProtectType], [Action], [Column] ) EXECUTE @sp_ExecuteSQL N'sp_Helprotect' ;with cte as (select Object, Grantee, Action, row_number() over (partition by Object, Grantee ORDER BY Action) as Row from #TmpResults) select Object, Grantee, max(case when Action = 'Delete' then char(88) end) as [Delete], max(case when Action = 'Insert' then char(88) end) as [Insert], max(case when Action = 'Select' then char(88) end) as [Select], max(case when Action = 'Update' then char(88) end) as [Update] from #TmpResults WHERE Grantee = @Grantee AND [Object] LIKE @Table GROUP by Object, Grantee END GO
ASPX:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TelerikUpload.aspx.cs" Inherits="ImportMPV2_WebTest.TelerikUpload" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> <div> <telerik:RadAsyncUpload AllowedFileExtensions="xlsx" EnableInlineProgress="true" ID="RadAsyncUpload1" MaxFileInputsCount="1" MultipleFileSelection="Disabled" OnFileUploaded="RadAsyncUpload1_FileUploaded" RenderMode="Lightweight" runat="server" Skin="Telerik" TargetDir="Uploads"> <FileFilters> <telerik:FileFilter Description="Excel Files(xlsx)" Extensions="xlsx" /> </FileFilters> </telerik:RadAsyncUpload> </div> <br /> <telerik:RadButton AutoPostBack="true" runat="server" Text="Import" Skin="Telerik" /> </form> <pre><asp:label id="lblUploadResults" runat="server"></asp:label> </pre> <pre><asp:label id="lblSSISResults" runat="server"></asp:label> </pre></body></html>
Code behind:
protected void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e){ UploadedFile uploadFile = e.File; string xlFilePath = Path.Combine(Server.MapPath(WebConfigurationManager.AppSettings["uploadDir"]), uploadFile.FileName); // Display upload results lblUploadResults.Text = "File Uploaded\n" + "File name: " + uploadFile.FileName + "\n" + "Content type: " + uploadFile.ContentType + "\n" + "Content length: " + uploadFile.ContentLength + "\n" + "Last modified date: " + uploadFile.LastModifiedDate + "\n"; // Execute SSIS package SSISExecutor ssisExecutor = new SSISExecutor( xlFilePath , "Balance Import" , "gregorym" , false , WebConfigurationManager.AppSettings["logFilePath"] , WebConfigurationManager.ConnectionStrings["DatabasePEP1"].ConnectionString ); ssisExecutor.Exec(out List<string> resultList); // Display SSIS results string s = "SSIS results:\n" + xlFilePath + ":\n\n"; foreach (string result in resultList) { s += result + "\n"; } lblSSISResults.Text = s;}
Output:
File UploadedFile name: ImportV2_Sample.xlsxContent type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheetContent length: 326210Last modified date: 1/13/2020 4:47:40 PM SSIS results:C:\ImportMPV2_WebTest\Uploads\ImportV2_Sample.xlsx:Error: File "C:\ImportMPV2_WebTest\Uploads\ImportV2_Sample.xlsx" not found
Hoping somebody can help me here. I am following an example posted by Telerik on how to do this in this forum. I am getting "" returned as the value for every column value (.Text). All of my grid columns are GridtTmplateColumns and the column values are labels within the template.
How do accomplish this with GridTemplateColumns? I have been struggling with this for the entire day. Can I somehow use item.findcontrol here?
Dim dtRecs As DataTable = New DataTable
For Each col As GridColumn In rgbt.Columns
If (col.ColumnType = "GridTemplateColumn") Then
Dim colstring As String
colstring = col.UniqueName
dtRecs.Columns.Add(colstring)
End If
Next
For Each item As GridDataItem In rgbt.Items
Dim newRow As DataRow = dtRecs.NewRow()
For Each column As GridColumn In rgbt.Columns
If (column.ColumnType = "GridTemplateColumn") Then
newRow(column.UniqueName) = item.(column.UniqueName).Text 'RETURNS ""
dtRecs.Rows.Add(newRow)
End If
Next
Next
Thanks!
Hi,
I get an error [HttpException (0x80004005): Cannot use a leading .. to exit above the top directory.]
with:
<telerik:radButton ButtonType="LinkButton" NavigateUrl="~/shop/shoppingcart.aspx" id="btn_nextsteptop" runat="server"><ContentTemplate>
<asp:Literal ID="Literal1" Text="Jippeee" runat="server"></asp:Literal></ContentTemplate></telerik:radButton>
When I remove the tilde then the error is not occuring, so probably the relative path functionality is broken here?
Marc
