Questions on UI for ASP.NET AJAX Forum

1 answer

123 views

Need help to uplaod XML Files to a SQL database XML type field

I have simplified it to a ID field and a single XML field for testing. I tried RadUpload and AyncUpload in templates. Have tried gridattachmentcolumn. It will create records, allow me to select the file but it does not upload anything to the XML field/column in the table. So, I have started over and I will place the page here. Currently nothing in code behind.

If you can please help me to do this I would appreciate it. I am novice and taking courses, but already working for a company while attending school.

I already know that the SQLDatasource parameter type "Object" is wrong for XML. How to change that SqlDataSource insert and update parameter in code behind? Is that a good strategy? I have tried other types in the SQLDataSource control and have tried to figure out how to make parameters for the SQLDataSource control in code behind but no luck.

Ultimately, I would like to upload the small SVG files to the sql server table and view them within the Radgrid. I seem to have some luck using HTML Object tag in the <ItemTemplate> but cannot test it because I have yet to be able to upload one of the SVG files to the table.

I also had luck setting it up to upload images and view them in a different page. Just cannot figure out how to do this with svg files.

Please help. Since I am learning, a very thorough explanation and example would be appreciated. I have had no luck searching the examples, documentation etc... available here and on searching Google. I have tried a lot of stuff and now pulling my hair out!



<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="testing.aspx.cs" Inherits="testing" %><asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">     <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" GroupPanelPosition="Top" DataSourceID="SqlDataSource1">         <MasterTableView CommandItemDisplay="Top" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">             <Columns>                 <telerik:GridTemplateColumn DataField="SVGFile" HeaderText="SVGFile" SortExpression="SVGFile" UniqueName="SVGFile" FilterControlAltText="Filter SVGFile column">                     <EditItemTemplate>                         <asp:TextBox runat="server" ID="SVGFileTextBox" Text='<%# Bind("SVGFile") %>'></asp:TextBox>                     </EditItemTemplate>                     <ItemTemplate>                         <asp:Label runat="server" ID="SVGFileLabel" Text='<%# Eval("SVGFile") %>'></asp:Label>                     </ItemTemplate>                 </telerik:GridTemplateColumn>  
                <telerik:GridBoundColumn DataField="ID" ReadOnly="True" HeaderText="ID" SortExpression="ID" UniqueName="ID" DataType="System.Int32" FilterControlAltText="Filter ID column"></telerik:GridBoundColumn>             </Columns>         </MasterTableView>     </telerik:RadGrid>     <asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:IGWiringConnectionString %>' DeleteCommand="DELETE FROM [TestSVG] WHERE [ID] = @ID" InsertCommand="INSERT INTO [TestSVG] ([SVGFile]) VALUES (@SVGFile)" SelectCommand="SELECT [SVGFile], [ID] FROM [TestSVG]" UpdateCommand="UPDATE [TestSVG] SET [SVGFile] = @SVGFile WHERE [ID] = @ID">         <DeleteParameters>             <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>         </DeleteParameters>         <InsertParameters>             <asp:Parameter Name="SVGFile" Type="Object"></asp:Parameter>         </InsertParameters>         <UpdateParameters>             <asp:Parameter Name="SVGFile" Type="Object"></asp:Parameter>             <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>         </UpdateParameters>     </asp:SqlDataSource></asp:Content><asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server"></asp:Content>

Grid

answered on 21 Oct 2015

3 answers

105 views

RadGrid Goes out of Broswer window

Hi There..
I have a pblm. My radGrid has alignment issue. Some of the rows goes out Browser window. Please see the attached picture.

Grid

answered on 21 Oct 2015

1 answer

163 views

How to remove blinking cursor from page size combobox.

I am using RadGrid control inside which I have paging combo box [Please refer to the attached image].

The issue is the blinking cursor inside combo box.I want the combo box as read only.Unable to find appropriate property for that.

Please help as issue is in high priority!!!

Thanks.

Grid

answered on 21 Oct 2015

7 answers

610 views

RadHtmlChart set Xaxis Min Value C#

Hi I am having problems with a RadHtmlChart I am using within an Asp page. It is a scatter chart which the data is applied to in the code behind. This all works correctly and plots fine the problem I am having is with trying to set the Min Value on the Xaxis. As I am using date ranges to decrease the amounts of data the chart shows the minimum value on the Xaxis changes so I would like the chart to start at the minimum value + 5. If I set the minimum value for the Xaxis within the configuration wizard this works fine but isn't dynamic enough for what I need. So I am trying in the code behind using the below code:

PcrInfeasPlot.PlotArea.XAxis.MinValue = lowestValue - 5;

This assigns the value correctly as I have checked the value in the debugger but the chart never reflects this change. How would I go about changing the minimum value so that I can see more on the chart.

Regards,

Charlie

Chart (HTML5)

answered on 21 Oct 2015

3 answers

138 views

ContextMenuID -- Does not work

I am attempting to use the new ContextMenuID feature with no success. Here is a simplified version of what I'm doing.

    
            <tel:RadScheduler ID="RadScheduler1" runat="server"> 
        
                <TimeSlotContextMenus> 
        
                    <tel:RadSchedulerContextMenu ID="TimeSlotMenu" runat="server" > 
        
                        <Items> 
        
                            <tel:RadMenuItem Text="Menu Item 1" Value="1" /> 
        
                        </Items> 
        
                    </tel:RadSchedulerContextMenu> 
        
                </TimeSlotContextMenus> 
        
                <AppointmentContextMenus> 
        
                    <tel:RadSchedulerContextMenu ID="AppointmentMenu1" runat="server" > 
        
                        <Items> 
        
                            <tel:RadMenuItem Text="Menu Item 2" Value="2" /> 
        
                        </Items> 
        
                    </tel:RadSchedulerContextMenu>    
        
                    <tel:RadSchedulerContextMenu ID="AppointmentMenu2" runat="server" > 
        
                        <Items> 
        
                            <tel:RadMenuItem Text="Menu Item 3" Value="3" /> 
        
                        </Items> 
        
                    </tel:RadSchedulerContextMenu>    
        
                </AppointmentContextMenus> 
        
            </tel:RadScheduler>

    
            public class TestApt { 
        
                public int ID { get; set; } 
        
                public string Description { get; set; } 
        
                public DateTime StartTime { get; set; } 
        
                public DateTime EndTime { get; set; } 
        
            } 
        
            protected void Page_Init(object sender, EventArgs e) { 
        
                RadScheduler1.DataKeyField = "ID"; 
        
                RadScheduler1.DataSubjectField = "Description"; 
        
                RadScheduler1.DataStartField = "StartTime"; 
        
                RadScheduler1.DataEndField = "EndTime"; 
        
                RadScheduler1.AppointmentDataBound += new AppointmentDataBoundEventHandler(RadScheduler1_AppointmentDataBound); 
        
            } 
        
            void RadScheduler1_AppointmentDataBound(object sender, SchedulerEventArgs e) { 
        
                if ((int)e.Appointment.ID == 1) { 
        
                    e.Appointment.ContextMenuID = "AppointmentMenu1"; 
        
                } else if ((int)e.Appointment.ID == 2) { 
        
                    e.Appointment.ContextMenuID = "AppointmentMenu2"; 
        
                } else { 
        
                    e.Appointment.ContextMenuID = ""; 
        
                } 
        
            } 
        
            protected void Page_Load(object sender, EventArgs e) { 
        
                if (!Page.IsPostBack) { 
        
                    List<TestApt> apts = new List<TestApt>(); 
        
                    apts.Add(new TestApt { ID = 1, Description = "Test1", StartTime = new DateTime(2009, 11, 9, 10, 0, 0), EndTime = new DateTime(2009, 11, 9, 11, 0, 0) }); 
        
                    apts.Add(new TestApt { ID = 2, Description = "Test2", StartTime = new DateTime(2009, 11, 9, 11, 0, 0), EndTime = new DateTime(2009, 11, 9, 12, 0, 0) }); 
        
                    apts.Add(new TestApt { ID = 3, Description = "Test3", StartTime = new DateTime(2009, 11, 9, 12, 0, 0), EndTime = new DateTime(2009, 11, 9, 13, 0, 0) }); 
        
                    RadScheduler1.DataSource = apts; 
        
                    RadScheduler1.DataBind(); 
        
                } 
        
            }

There are a couple of things that don't work here.
#1 All appointments are using "AppointmentMenu1" as their context menu.
#2 By setting the ContextMenuID equal to empty string, I am still getting a context menu on appointment 3. (if this is by design, how can I accomplish this?)

Thanks,

Sean

Scheduler

answered on 21 Oct 2015

1 answer

750 views

How to hide a cell (not a column) in radgrid prerender?

I worked in radgrid itemdatabound for hiding cells, but how can i do it in radgridprerender event?

Grid

answered on 21 Oct 2015

5 answers

2.1K+ views

Telerik.Web.UI.WebResource.axd 404 error not found

Hi All,

I'm getting the following not found. Are there any tips on how to solve this? I'm using .NET 4.0 framework in Visual Web Developer 2010 Express. I have been looking at this for hours now and can't get it to work.

The call stems from this:

<telerik:RadScriptManager ID="ScriptManager1" runat="server" />

And gives a console error of the missing resource:

http://localhost:51383/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=navTop_ScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d4.0.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3ac9cbdec3-c810-4e87-846c-fb25a7c08002%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2011.2.712.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3a326e32e2-cd52-462c-ba2c-db5128e4371b%3a16e4e7cd%3af7645509%3a24ee1bba%3a874f8ea2%3adc7e0bd%3a1569bb5f%3a63b115ed%3a30f1f089%3af46195d3%3a19620875%3a490a9d4e

Not Found (404)

I've tried adding that location fix to my web config, removed references to runtimeversion2.0 etc. Scoured the web but nothing is helping, and leads anyone can give me would be super appreciated. I'm simply trying to get the HTML editor to function...

General Discussions

answered on 21 Oct 2015

1 answer

251 views

Drag and drop functionality is not working in Rad Grid

Hi Team,

Drag and Drop control is not working it is throwing error message because of e.DestDataItem is null in the RowDrop event. The radgrid is inside the user control and the user control is added dynamically to the page.

Please provide the possible solution.

Thank You

Main Page :

-----------------

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" BackColor="white" CssClass="radLoadingPanel" Transparency="25">
<h1>Proof Generation in Process...</h1>
</telerik:RadAjaxLoadingPanel>
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1">
<asp:Panel ID="pnlVariables" runat="server">
</asp:Panel>
<div class="clear">
</div>
<div class="clear">
<asp:Label ID="lblNoOptions" runat="server" CssClass="errorMessage" Visible="False"></asp:Label><br />
<asp:Label ID="lblErrorMessage" runat="server" CssClass="errorMessage" Visible="False"></asp:Label>
</div>
<asp:Panel ID="pnlButton" runat="server">
<label id="lblProcessTimeWarning" runat="server" style="display: block; margin-bottom: 10px;" visible="false">
</label>
<asp:Button ID="btnCreateProofs" runat="server" Text="Save" />
</asp:Panel>
</telerik:RadAjaxPanel>

Main Page code Behind

-------------------------------

Dim tuc As Modules_Controls_BookBuilderControl = CType(LoadControl("~/Modules/Controls/BookBuilderControl.ascx"), Modules_Controls_BookBuilderControl)
tuc.ID = oRow("FriendlyName").ToString()
tuc.CartID = CType(oRow("CartID"), Long)
pnlVariables.Controls.Add(tuc)

Usercontrol.ascx

----------------------

<telerik:RadGrid ID="Parts" runat="server" ClientIDMode="AutoID" AllowPaging="True" AllowSorting="True" ClientSettings-AllowAutoScrollOnDragDrop="true"
AutoGenerateColumns="False" GridLines="None" ShowStatusBar="True" CssClass="Parts" ClientSettings-AllowDragToGroup="true" ClientSettings-AllowRowsDragDrop="true">
<ClientSettings AllowRowsDragDrop="True" AllowColumnsReorder="true" ReorderColumnsOnClient="true">
<Selecting AllowRowSelect="True" EnableDragToSelectRows="false"></Selecting>
<ClientEvents OnBatchEditOpening="batchEditOpening"></ClientEvents>
<Scrolling AllowScroll="true" UseStaticHeaders="true"></Scrolling>
</ClientSettings>
<MasterTableView Name="PartsTableView" ClientIDMode="AutoID" DataKeyNames="InventoryID" AllowSorting="True" NoDetailRecordsText="No Items" HierarchyLoadMode="ServerBind"
NoMasterRecordsText="No Items Added" CommandItemDisplay="Bottom" EditMode="Batch">
<CommandItemSettings ShowAddNewRecordButton="false" ShowCancelChangesButton="false" ShowRefreshButton="false"/>
<BatchEditingSettings EditType="Cell" />
<DetailTables>
<telerik:GridTableView Name="ComponentDetails" Caption="Component Details" DataKeyNames="InventoryID"
runat="server">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="ParentID" MasterKeyField="InventoryID" />
</ParentTableRelation>
<Columns>
<telerik:GridTemplateColumn UniqueName="ThumbNail">
<ItemTemplate>
<asp:Image ID="imgThumbNail" runat="server" ImageUrl='<%#Eval("Thumbnail")%>' />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="ParentID" Display="false" UniqueName="ParentID" />
<telerik:GridBoundColumn DataField="InventoryID" Display="false" UniqueName="InventoryID" />
<telerik:GridBoundColumn DataField="FormNumber" HeaderText="Product Code" UniqueName="FormNumber" />
<telerik:GridBoundColumn DataField="Description" HeaderText="Title" ReadOnly="true"
UniqueName="Description" Display="True" />
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridTemplateColumn UniqueName="ThumbNail">
<ItemTemplate>
<asp:Image ID="imgThumbNail" runat="server" ImageUrl='<%#Eval("ImageUrl")%>' />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="InventoryID" UniqueName="FormNumber" Display="false" />
<telerik:GridBoundColumn DataField="Text" ItemStyle-Width="150px" HeaderText="Product Code" />
<telerik:GridBoundColumn DataField="Description" HeaderText="Title" Display="true" />
<telerik:GridBoundColumn DataField="Type" Display="false" />
<telerik:GridButtonColumn ButtonType="LinkButton"
CommandName="DeleteInventory" Text="Remove" UniqueName="Delete">
<ItemStyle HorizontalAlign="Center" CssClass="buttonContainer"></ItemStyle>
<HeaderStyle ></HeaderStyle>
</telerik:GridButtonColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
<asp:XmlDataSource ID="XMLBookBuilderSource" runat="server" EnableCaching="false">
</asp:XmlDataSource>

UserControl Code Behind

--------------------------------------

Protected Sub Parts_RowDrop(sender As Object, e As GridDragDropEventArgs) Handles Parts.RowDrop
Try
Dim element As XElement
Dim root As New XElement("BookBuilder")
element = XMLDoc.Root.Elements("Node")(e.DraggedItems(0).ItemIndex)
XMLDoc.Root.Elements("Node")(e.DraggedItems(0).ItemIndex).Remove()
If (XMLDoc.Root.Elements("Node").Count = e.DestDataItem.ItemIndex) Then
XMLDoc.Root.Elements("Node")(e.DestDataItem.ItemIndex - 1).AddBeforeSelf(element)
Else
XMLDoc.Root.Elements("Node")(e.DestDataItem.ItemIndex).AddBeforeSelf(element)
End If
Session("XMLDoc") = XMLDoc
Parts.Rebind()
Catch ex As Exception
WriteLog4Net("Unable to Drag and Drop:: ", ex)
End Try
End Sub

Grid

answered on 20 Oct 2015

3 answers

168 views

CheckedItems.Count returns 0 if enabled = false when loading page

Hello,

I i have a RadListBox with checkboxes named "myCkList".
Im my case, i check some boxes and i observe CheckedItems in server side after clicking button. I'm suprised because myCkList.CheckedItems.Count = 0 ...

In fact, it's because i added property Enabled=false to myCkList in aspx page (of course i enable it client side before clicking checkboxes) !

Is it a normal behavior in asp.net ?

I can work with Enabled=true and set_enabled(false) from pageLoad..., no problem.

ListBox

answered on 20 Oct 2015

1 answer

68 views

Set level in radmenu in SharePoint 2013

I am trying to use rad menu for the top navigation in sharepoint custom master page. I noticed that it shows the home tab and every thing under that as a dropdown (2nd level) menu. Is there a way to display it from the second level, so that i see the second levels as the top level.

Is there is a solution for this issue through Telerik Controls or not ?

Menu

answered on 20 Oct 2015