I have a RadAutoCompleteBox along with a RadODataDataSource.
Every time I load the page I am prompted for username/password.
The website is on the intranet and so it the odata source.
The Odata source wizard always shows error so it must be set manually.
Once I present credentials it pulls the data.
How can I make it stop asking for credentials?
Hi
I am having a RadMenu. In this RadMenu for a perticular RadMenuItem i am using ItemTemplet. For this RadMenuItem
"OnClientMouseOver" is not firing when i hover on this RadMenuItem. If i remove this ItemTemplet its working fine.
Can you please tell me how can i fire "OnClientMouseOver" event for ItemTemplet RadMenuItem.
Thanks
Srikanth Gunnala

.aspx page
<telerik:RadClientDataSource runat="server" ID="RadClientDataSource1">
<DataSource>
<WebServiceDataSourceSettings ServiceType="OData">
<Select Url="Products" DataType="JSON" />
</WebServiceDataSourceSettings>
</DataSource>
<Schema DataName="d.results">
</Schema>
</telerik:RadClientDataSource>
<div >
<telerik:RadComboBox ID="RadComboBox1" runat="server" ClientDataSourceID="RadClientDataSource1"
EnableLoadOnDemand="true" DataTextField="ProductName" DataValueField="ProducasdtID"
ShowMoreResultsBox="true" ItemsPerRequest="10" EnableVirtualScrolling="true" Width="300px">
</telerik:RadComboBox>
</div>
.cs Page
protected void Page_Load(object sender, EventArgs e)
{
RadClientDataSource1.DataSource.WebServiceDataSourceSettings.BaseUrl = ResolveUrl("http://demos.telerik.com/aspnet-ajax/combobox/examples/populatingwithdata/client-side-data-binding/Services/NorthwindWcfService.svc/");
}
how to bind this in page base event instated of webserviceDatasourcesetting but in my another application i am use this code
<telerik:RadComboBox ID="cbCommodity" Height="100px" Width="200px"
runat="server" ItemsPerRequest="10" ShowMoreResultsBox="true" EnableVirtualScrolling="true"
EnableAutomaticLoadOnDemand="true" AccessKey="T" MarkFirstMatch="true" EmptyMessage="Select"
HighlightTemplatedItems="true">
<HeaderTemplate>
<ul>
<li class="col1">HS Code</li>
<li class="col2">Description</li>
</ul>
</HeaderTemplate>
<ItemTemplate>
<ul>
<li class="col1">
<%# DataBinder.Eval(Container.DataItem, "HSCode")%></li>
<li class="col2">
<%# DataBinder.Eval(Container.DataItem, "Description")%></li>
</ul>
</ItemTemplate>
</telerik:RadComboBox>
Can i do databind at client side using page base method please give me any demo
Hello everyone,
I have a project with a radgrid and checklist filtering. I need the selected values to be stored aswell as loaded after a refresh of the page.
The page is refreshed automatically via JQuery after 30 seconds.
Thanks for your help.
My ASP.NET site coded in C# is running fine on my local system but when I uploaded the files on the httpdocs folder through Plesk control panel. I have a shared accounts at http://hostforlife.eu/ and I got the following error:
Server Error in '/' Application.
________________________________________
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.Compiler Error Message: CS0246: The type or namespace name 'Xyz' could not be found (are you missing a using directive or an assembly reference?)Source Error:Line 1: <%@ Application Language="C#" %>
Line 2: <%@ Import Namespace="mydomain" %>
Line 3: <%@ Import Namespace="System.Web.Optimization" %>
Line 4: <%@ Import Namespace="System.Web.Routing" %>Source File: g:\PleskVhosts\mydomain.com\httpdocs\Xyz\Global.asax Line: 2Show Detailed Compiler Output:C:\Windows\SysWOW64\inetsrv> "C:\Windows\Microsoft.NET\Framework\v4.0.30319\csc.exe" /t:library /utf8output /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.WebPages.Deployment\v4.0_2.0.0.0__31bf3856ad364e35\System.Web.WebPages.Deployment.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.CSharp\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.CSharp.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Services\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Extensions\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.Extensions.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.WorkflowServices\v4.0_4.0.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Web\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.DynamicData\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.DynamicData.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.Activities.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.ApplicationServices\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.ApplicationServices.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.IdentityModel\v4.0_4.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Activation\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activation.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.DataAnnotations\v4.0_4.0.0.0__31bf3856ad364e35\System.ComponentModel.DataAnnotations.dll" /R:"C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activities.dll" /out:"C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\ba70df64\8ad7fdd9\App_global.asax.8gpjfmvi.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701;612;618 /warnaserror- "C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\ba70df64\8ad7fdd9\App_global.asax.8gpjfmvi.0.cs" "C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\ba70df64\8ad7fdd9\App_global.asax.8gpjfmvi.1.cs"Microsoft (R) Visual C# Compiler version 4.0.30319.17929for Microsoft (R) .NET Framework 4.5
Copyright (C) Microsoft Corporation. All rights reserved.g:\PleskVhosts\mydomain.com\httpdocs\Xyz\Global.asax(2,11): error CS0246: The type or namespace name 'Xyz' could not be found (are you missing a using directive or an assembly reference?)
g:\PleskVhosts\mydomain.com\httpdocs\Xyz\Global.asax(3,22): error CS0234: The type or namespace name 'Optimization' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)
g:\PleskVhosts\mydomain.com\httpdocs\Xyz\Web.config(24,21): error CS0234: The type or namespace name 'AspNet' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)________________________________________
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18056
I'm updating an application from the Classic controls to the newest version. Some of the scripts are working correctly. I need to set the border and background of a RadCombobox to Red to signify its a required field. I used to do the following:
RadAjaxPanelContacts.ResponseScripts.Add("LoadCombobox(" & rcbContactTxt.ClientID & ");")
function LoadCombobox(combobox)
{
combobox.InputDomElement.style.border = "solid 1px #a80532";
combobox.InputDomElement.style.color = "#a80532";
combobox.InputDomElement.style.background = "white";
}
This now triggers a javascript error type error element undefined. I tried replacing with:
function LoadCombobox(combobox)
{
combobox.element.style.border = "solid 1px #ff0000";
combobox.element.style.color = "#ff0000";
combobox.element.style.background = "white";
}
Doesn't work either. How do I do what the old code does with the newer version of the controls?
Which is prefered and recommended way to create custom skins?
I know that i can create skin with Visual Style Builder and compile it with acTelerikStylesAssembly to DLL library, which i can attache to SkinManager etc.
I know that i can copy files from C:\Program Files (x86)\Telerik\UI for ASP.NET AJAX Q1 2015\Skins, rename it with acTelerikStylesRenaming or manual and place them in App_Themes folder etc.
But...
In C:\Program Files (x86)\Telerik\UI for ASP.NET AJAX Q1 2015\Skins subfolders i have more folders and files than in skin *.zip file downloaded from VisualStyleBuilder. Why? If i create two skins by two different ways, my application will be working in the same way and looks great with both skins?
I must create four skins for my application (light and dark for normal users and two high contrast for users with some dysfunction), and this will be hard work for me, that i must know how to make it with minimal effort.
P.S. Sorry for my bad English.
I am trying to save multiple files to my database, and for whatever reason, it is not doing so. Any help will be greatly appreciated.
ASP:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CAF_Detail.aspx.cs" Inherits="DetailViews_CAF_Detail" MasterPageFile="~/EUEMain.master" %><%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %><asp:Content ID="Content1" ContentPlaceHolderID="cphLeftNav" runat="Server"> <asp:HyperLink ID="HomeLink" runat="server" NavigateUrl="..\Default.aspx" Text="Home" /></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="cphContent" runat="Server"> <h1>CAF Tracking System</h1> <telerik:RadScriptManager runat="server" ID="RadScriptManager1" /> <h7>Please make sure to leave your initials at the end of any comments you make.</h7> <h5> </h5> <telerik:RadCodeBlock ID="RadCodeBlock2" runat="server"> <script type="text/javascript"> var manager; Sys.Application.add_load(function () { manager = $find('<%= RadAjaxManager.GetCurrent(Page).ClientID %>'); }); </script> </telerik:RadCodeBlock> <script type="text/javascript" src="../DetailViews/Scripts.js"></script> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid2"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid2" LoadingPanelID="RadAjaxLoadingPanel1"></telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"> </telerik:RadAjaxLoadingPanel> <div> <telerik:RadGrid ID="RadGrid2" DataSourceID="SqlDataSource1" AllowPaging="False" Width="100%" runat="server" AutoGenerateColumns="False" AllowSorting="True" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" OnItemDataBound="RadGrid2_ItemDataBound" OnItemCommand="RadGrid2_ItemCommand" OnUpdateCommand="RadGrid2_OnUpdateCommand" > <MasterTableView DataKeyNames="Unique, ChangeLog" AutoGenerateColumns="False" CommandItemDisplay="Top" DataSourceID="SqlDataSource1" EditMode="EditForms"> <NestedViewTemplate> <asp:Panel runat="server" ID="InnerContainer" Visible="False"></asp:Panel> <telerik:RadMultiPage runat="server" ID="Multipage1" SelectedIndex="0" RenderSelectedPageOnly="False"> <telerik:RadPageView runat="server" ID="Details"> <asp:Label ID="Label1" Font-Bold="true" Font-Italic="true" Text='<%# Bind("Unique") %>' Visible="False" runat="server"></asp:Label> <telerik:RadGrid runat="server" ID="SubNotesGrid" DataSourceID="SqlDataSource3" ShowFooter="true" AllowSorting="true" EnableLinqExpressions="false"> <MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true" DataKeyNames="Unique, Changelog" PageSize="25" HierarchyLoadMode="Client"> <Columns> <telerik:GridBoundColumn UniqueName="CAF_Number" DataField="CAF_Number" HeaderText="CAF Number" AllowFiltering="false" /> <telerik:GridBoundColumn UniqueName="CAF_Rev" DataField="CAF_Rev" HeaderText="Revision" /> <telerik:GridBoundColumn UniqueName="CAF_Approved" DataField="CAF_Approved" HeaderText="Approved" /> <telerik:GridBoundColumn UniqueName="CAF_System" DataField="CAF_System" HeaderText="CAF System" /> <telerik:GridBoundColumn UniqueName="CAF_Build" DataField="CAF_Build" HeaderText="Build" /> <telerik:GridBoundColumn UniqueName="CAF_BNSF" DataField="CAF_BNSF" HeaderText="Affecting BNSF" /> <telerik:GridBoundColumn UniqueName="CAF_Desc" DataField="CAF_Desc" HeaderText="CAF Description" AllowFiltering="False" /> <telerik:GridBoundColumn UniqueName="CAF_Post_Date" DataField="CAF_Post_Date" HeaderText="Post Date" DataFormatString="{0:MM/dd/yyyy}" /> <telerik:GridBoundColumn UniqueName="CAF_Due_Date" DataField="CAF_Due_Date" HeaderText="Due Date" DataFormatString="{0:MM/dd/yyyy}" /> <telerik:GridBoundColumn UniqueName="Target_Date" DataField="Target_Date" HeaderText="Target Review Date" DataFormatString="{0:MM/dd/yyyy}" /> <telerik:GridBoundColumn UniqueName="Comments" DataField="Comments" HeaderText="Comments" /> <telerik:GridBoundColumn UniqueName="ChangeLog" DataField="ChangeLog" HeaderText="ChangeLog" /> </Columns> </MasterTableView> </telerik:RadGrid> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings: PtcDbModelEntities %>" SelectCommand="SELECT * FROM [PtcDbTracker].[dbo].[CAFTable] as t0 Inner join [PtcDbTracker].[dbo].[CafFileTable] as t1 on t0.[Unique] = t1.[Unique1] where t0.[Unique] = @Unique"> <SelectParameters> <asp:ControlParameter ControlID="Label1" Name="Unique" /> </SelectParameters> </asp:SqlDataSource> </telerik:RadPageView> </telerik:RadMultiPage> </NestedViewTemplate> <Columns> <telerik:GridEditCommandColumn /> <telerik:GridBoundColumn UniqueName="CAF_Number" DataField="CAF_Number" HeaderText="CAF Number" AllowFiltering="false" /> <telerik:GridTemplateColumn UniqueName="CAF_Desc" DataField="CAF_Desc" HeaderText="Description" AllowFiltering="False"> <ItemTemplate> <asp:Label runat="server" ID="caf_desc" Text='<%# Bind("CAF_Desc") %>' Width="350px"></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" ID="CAF_Desc_TextBox" Width="300px" Height="75px" Text='<%# Bind("CAF_Desc") %>' Wrap="True" TextMode="MultiLine"></asp:TextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="CAF_System" Visible="False" HeaderText="System"> <EditItemTemplate> <asp:DropDownList ID="Label6" runat="server" SelectedValue='<%# Bind("CAF_System") %>' DataSource='<%# (new[] { "OB", "BOS", "EM"}) %>' AppendDataBoundItems="True" CausesValidation="False"> <asp:ListItem Selected="True" Text="Select" Value=""> </asp:ListItem> </asp:DropDownList> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn UniqueName="CAF_Rev" DataField="CAF_Rev" HeaderText="Revision" Visible="True" /> <telerik:GridTemplateColumn UniqueName="Comments" DataField="Comments" HeaderText="Comments" AllowFiltering="False" Visible="False"> <EditItemTemplate> <asp:TextBox runat="server" ID="Comments_TextBox" Width="400px" Height="150px" Text='<%# Bind("Comments") %>' Wrap="True" TextMode="MultiLine"></asp:TextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridDateTimeColumn UniqueName="CAF_Post_Date" DataField="CAF_Post_Date" PickerType="DatePicker" HeaderText="Post Date" Visible="False" /> <telerik:GridDateTimeColumn UniqueName="CAF_Due_Date" DataField="CAF_Due_Date" PickerType="DatePicker" Visible="False" HeaderText="Due Date" /> <telerik:GridDateTimeColumn UniqueName="Target_Date" DataField="Target_Date" PickerType="DatePicker" Visible="True" HeaderText="Target Review Date" /> <telerik:GridBoundColumn UniqueName="CAF_Build" DataField="CAF_Build" Visible="False" HeaderText="Build" /> <telerik:GridTemplateColumn UniqueName="CAF_BNSF" Visible="True" HeaderText="Affecting BNSF"> <EditItemTemplate> <asp:DropDownList ID="Label5" runat="server" SelectedValue='<%# Bind("CAF_BNSF") %>' DataSource='<%# (new[] { "None", "Low", "Medium", "High"}) %>' AppendDataBoundItems="True" CausesValidation="False"> <asp:ListItem Selected="True" Text="Select" Value=""> </asp:ListItem> </asp:DropDownList> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="CAF_Approved" DataField="CAF_Approved" Visible="True" HeaderText="Approved"> <ItemTemplate> <asp:Label runat="server" ID="caf_approved" Text='<%#Bind("CAF_Approved") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="Label12" runat="server" SelectedValue='<%# Bind("CAF_Approved") %>' DataSource='<%# (new[] { "Approved", "Not Approved"}) %>' AppendDataBoundItems="True" CausesValidation="False"> <asp:ListItem Selected="True" Text="Select" Value=""> </asp:ListItem> </asp:DropDownList> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridAttachmentColumn SortExpression="FileName" UploadControlType="RadAsyncUpload" DataSourceID="SqlDataSource5" EditFormHeaderTextFormat="Upload File:" HeaderText="Attachment Column" AttachmentDataField="BinaryData" AttachmentKeyFields="Unique" FileNameTextField="FileName" DataTextField="FileName" UniqueName="AttachmentColumn" /> <telerik:GridBoundColumn UniqueName="ChangeLog" DataField="ChangeLog" HeaderText="ChangeLog" ReadOnly="True" Visible="True" /> <%-- <telerik:GridAttachmentColumn SortExpression="FileName2" UploadControlType="RadAsyncUpload" DataSourceID="SqlDataSource6" EditFormHeaderTextFormat="Upload File:" HeaderText="Additional Attachment" AttachmentDataField="BinaryData2" AttachmentKeyFields="Unique" FileNameTextField="FileName2" DataTextField="FileName2" UniqueName="AttachmentColumn2" />--%> </Columns> </MasterTableView> <ClientSettings> <ClientEvents OnCommand="gridCommand"></ClientEvents> </ClientSettings> </telerik:RadGrid> <br /> </div> <%--OnInserted="SqlDataSource2_Inserted" OnUpdated="SqlDataSource2_Updated"--%> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings: PtcDbModelEntities %>" InsertCommand="INSERT INTO [PtcDbTracker].[dbo].[CAFTable] ([CAF_Number], [CAF_System], [CAF_Rev], [CAF_Build], [CAF_BNSF], [CAF_Desc], [Comments] , [CAF_Post_Date], [CAF_Due_Date], [Target_Date], [CAF_Approved]) VALUES (@CAF_Number, @CAF_System, @CAF_Rev, @CAF_Build, @CAF_BNSF, @CAF_Desc, @Comments, @CAF_Post_Date, @CAF_Due_Date, @Target_Date, @CAF_Approved) SET @InsertedID = SCOPE_IDENTITY()" SelectCommand="SELECT * FROM [PtcDbTracker].[dbo].[CAFTable] as t0 Inner join [PtcDbTracker].[dbo].[CafFileTable] as t1 on t0.[Unique] = t1.Unique1 Order By [CAF_Number] DESC, [CAF_Rev] DESC" UpdateCommand="UPDATE [PtcDbTracker].[dbo].[CAFTable] SET [CAF_Number] = @CAF_Number , [CAF_System] = @CAF_System , [CAF_Rev] = @CAF_Rev , [CAF_Build] = @CAF_Build , [CAF_BNSF] = @CAF_BNSF , [CAF_Desc] = @CAF_Desc , [Comments] = @Comments , [CAF_Due_Date] = @CAF_Due_Date , [CAF_Post_Date] = @CAF_Post_Date , [CAF_Approved] = @CAF_Approved WHERE [Unique] = @Unique"> <DeleteParameters> <asp:Parameter Name="Unique" Type="Int32"></asp:Parameter> </DeleteParameters> <InsertParameters> <asp:Parameter Name="CAF_Number" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_System" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_Rev" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_Build" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_BNSF" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_DESC" Type="String"></asp:Parameter> <asp:Parameter Name="Comments" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_Post_Date" DbType="Date"></asp:Parameter> <asp:Parameter Name="CAF_Due_Date" DbType="Date"></asp:Parameter> <asp:Parameter Name="Target_Date" DbType="Date"></asp:Parameter> <asp:Parameter Name="CAF_Approved" Type="String" /> <asp:Parameter Name="ChangeLog" Type="String" /> <asp:Parameter Name="InsertedID" Type="Int32" Direction="Output"></asp:Parameter> </InsertParameters> <UpdateParameters> <asp:Parameter Name="CAF_Number" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_System" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_Rev" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_Build" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_BNSF" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_DESC" Type="String"></asp:Parameter> <asp:Parameter Name="Comments" Type="String"></asp:Parameter> <asp:Parameter Name="CAF_Post_Date" DbType="Date"></asp:Parameter> <asp:Parameter Name="CAF_Due_Date" DbType="Date"></asp:Parameter> <asp:Parameter Name="Target_Date" DbType="Date"></asp:Parameter> <asp:Parameter Name="CAF_Approved" Type="String" /> <asp:Parameter Name="ChangeLog" Type="String" /> </UpdateParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:PtcDbModelEntities %>" SelectCommand="SELECT t1.[Unique1], t1.[BinaryData] FROM [PtcDbTracker].[dbo].[CAFTable] as t0 Inner join [PtcDbTracker].[dbo].[CafFileTable] as t1 on t0.[Unique] = t1.Unique1 WHERE t1.[Unique1] = @Unique"> <SelectParameters> <asp:Parameter Name="Unique" Type="Int32"></asp:Parameter> </SelectParameters> </asp:SqlDataSource> </asp:Content>
And C#:
using System.Collections;using System.Runtime.InteropServices;using System.Text;using Telerik.Web.UI;using System;using xi = Telerik.Web.UI.ExportInfrastructure;using System.Web.UI.WebControls;using System.Configuration;using System.Data.SqlClient;using System.IO;using MultipleFileSelection = Telerik.Web.UI.AsyncUpload.MultipleFileSelection;public partial class DetailViews_CAF_Detail : BNSF.EUECommonApplication.EUEBasePage{ int fileId; byte[] fileData; string fileName; string mystring1; private string oldChangeLogValue; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { } } protected void RadGrid2_ItemDataBound(object sender, GridItemEventArgs e) { var editItem = e.Item as GridEditFormItem; if (editItem != null && editItem.IsInEditMode) { var datePicker = editItem["CAF_Post_Date"].Controls[0] as RadDatePicker; datePicker.Width = Unit.Pixel(100); var datePicker2 = editItem["CAF_Due_Date"].Controls[0] as RadDatePicker; datePicker2.Width = Unit.Pixel(100); var datePicker3 = editItem["Target_Date"].Controls[0] as RadDatePicker; datePicker3.Width = Unit.Pixel(100); var attachment = editItem["AttachmentColumn"].Controls[0] as RadAsyncUpload; attachment.MultipleFileSelection = MultipleFileSelection.Automatic; } } protected void RadAsyncUpload1_FileUploaded1(object sender, FileUploadedEventArgs e) { string path = Server.MapPath("~/Uploads/"); e.File.SaveAs(path + e.File.GetName()); } protected void SqlDataSource2_Inserted(object sender, SqlDataSourceStatusEventArgs e) { var mystring = new StringBuilder(); mystring.Append(EUEUser.DisplayName + ' ' + DateTime.Now); fileId = (int)e.Command.Parameters["@InsertedID"].Value; UpdateFileData("UPDATE [PtcDbTracker].[dbo].[CAFTable] SET [ChangeLog] = @Changelog WHERE [Unique] = @Unique", fileId, mystring.ToString()); } protected void SqlDataSource2_Updated(object sender, SqlDataSourceStatusEventArgs e) { var mystring = new StringBuilder(oldChangeLogValue + "<br />"); mystring.AppendLine(EUEUser.DisplayName + ' ' + DateTime.Now); UpdateFileData("UPDATE [PtcDbTracker].[dbo].[CAFTable] SET [ChangeLog] = @ChangeLog WHERE [Unique] = @Unique", fileId, mystring.ToString()); } private void UpdateFileData(string command, int fileId, string mystring) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PtcDbModelEntities"].ConnectionString)) { using (SqlCommand comm = new SqlCommand(command, conn)) { if (fileData != null && fileData.Length > 0) { //comm.Parameters.Add(new SqlParameter("Unique", fileId)); //comm.Parameters.Add(new SqlParameter("BinaryData", fileData)); //comm.Parameters.Add(new SqlParameter("FileName", fileName)); comm.Parameters.Add(new SqlParameter("ChangeLog", mystring)); conn.Open(); comm.ExecuteNonQuery(); } } } } protected void RadGrid2_ItemCommand(object source, GridCommandEventArgs e) { var mystring = new StringBuilder(oldChangeLogValue + "<br />"); mystring.AppendLine(EUEUser.DisplayName + ' ' + DateTime.Now); if (e.CommandName == RadGrid.UpdateCommandName || e.CommandName == RadGrid.PerformInsertCommandName) { var item = e.Item as GridEditableItem; if (!(item is GridEditFormInsertItem)) { fileId = (int)item.GetDataKeyValue("Unique"); } var asyncUpload = item["AttachmentColumn"].Controls[0] as RadAsyncUpload; if (asyncUpload != null && asyncUpload.UploadedFiles.Count > 0) { var uploadedFile = asyncUpload.UploadedFiles[0]; fileData = new byte[uploadedFile.ContentLength]; fileName = uploadedFile.FileName; using (Stream str = uploadedFile.InputStream) { str.Read(fileData, 0, (int)uploadedFile.ContentLength); } foreach (UploadedFile file in asyncUpload.UploadedFiles) { byte[] bytes = new byte[file.ContentLength]; using ( SqlConnection conn1 = new SqlConnection( ConfigurationManager.ConnectionStrings["PtcDbModelEntities"].ConnectionString)) { using ( SqlCommand comm1 = new SqlCommand( "Insert into [PtcDbTracker].[dbo].[CAFFileTable] ([Unique1], [BinaryData], [FileName]) Values (?,?,?)", conn1)) { comm1.Parameters.AddWithValue("@Unique1", fileId); comm1.Parameters.AddWithValue("@BinaryData", bytes); comm1.Parameters.AddWithValue("@FileName", fileName); } } } } } } protected void RadGrid2_OnUpdateCommand(object sender, GridCommandEventArgs e) { oldChangeLogValue = (e.Item as GridEditableItem).GetDataKeyValue("ChangeLog").ToString(); }}