
DataImageUrlFields="Status"
DataImageUrlFormatString="~/Content/Images/Status/{0}.gif"
How can i change the image when the database value for Status is DBNULLif cell.text = DBNULL thenDataImageUrlFormatString="~/Content/Images/Status/waiting.gif"
end if
Thanks
<telerik:GridClientDeleteColumn UniqueName="TestDeleteColumn" HeaderText="Delete" HeaderStyle-Width="45" Text="Delete Invitation" ButtonType="ImageButton" ImageUrl="../Images/Delete.gif" ConfirmTitle="Delete?" ConfirmDialogType="RadWindow" ConfirmTextFields="PersonDisplay" ConfirmTextFormatString="Delete invited speaker {0}?" /> <telerik:GridButtonColumn UniqueName="DeleteColumn" ButtonType="ImageButton" CommandName="Delete" Text="Delete Speaker" ImageUrl="~/Images/Delete.gif" HeaderText="Delete" HeaderStyle-Width="45" ConfirmTitle="Delete?" ConfirmDialogType="RadWindow" ConfirmTextFields="PersonDisplay" ConfirmTextFormatString="Delete invited speaker {0}?" > <ItemStyle HorizontalAlign="Center" CssClass="CursorHand" /></telerik:GridButtonColumn>
<telerik:RadCodeBlock runat="server" ID="RadCodeBlock1"> <script type="text/javascript"> var uploadId; var AuthorImagesListId; //on insert and update buttons click temporarily disables ajax to perform upload actions function conditionalPostback(sender, e) { var theRegexp = new RegExp("\.UpdateButton$|\.PerformInsertButton$", "ig"); if (e.EventTarget.match(theRegexp)) { var upload = $find(uploadId); //AJAX is disabled only if file is selected for upload if (upload.getFileInputs()[0].value != "") { e.set_enableAjax(false); } } } </script> </telerik:RadCodeBlock> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" /> <telerik:AjaxUpdatedControl ControlID="RadWindowManager1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" /> <telerik:radprogressmanager id="RadProgressManager1" runat="server" /> <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" GridLines="None" ShowStatusBar="True" Skin="Hay" AllowSorting="True"> <PagerStyle Mode="NextPrevAndNumeric" /> <GroupingSettings CaseSensitive="False"></GroupingSettings> <%--DOUBLE CLICKING ON GRIDVIEW ROW ACTIVATES THE EDIT ROW MODE--%> <ClientSettings> <ClientEvents OnRowDblClick="RowDblClick" /> </ClientSettings> <GroupingSettings CaseSensitive="False" /> <ClientSettings AllowRowsDragDrop="True"><ClientEvents OnRowDblClick="RowDblClick"></ClientEvents> </ClientSettings><MasterTableView Width="100%" CommandItemDisplay="TopAndBottom" DataKeyNames="nauhaID" DataSourceID="SqlDataSource1" HorizontalAlign="NotSet" AutoGenerateColumns="false" > <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Edit " UniqueName="EditCommandColumn1"> <ItemStyle CssClass="MyImageButton" /> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn DataField="title" HeaderText="Nauha Title" SortExpression="title" ColumnEditorID="GridTxtboxTemp" UniqueName="title"> </telerik:GridBoundColumn> <telerik:GridDropDownColumn DataField="areaID" DataSourceID="SqlDataSource2" HeaderText="Area Name" ListTextField="areaName" ListValueField="areaID" UniqueName="column1" ColumnEditorID="GridDropDownColumnEditor1"> </telerik:GridDropDownColumn> <telerik:GridBoundColumn DataField="author" HeaderText="author" ColumnEditorID="GridTxtboxTemp" Visible="false" SortExpression="author" UniqueName="author"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="lyrics" HeaderText="lyrics" Visible="false" SortExpression="lyrics" UniqueName="lyrics"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="reciter" HeaderText="reciter" ColumnEditorID="GridTxtboxTemp" Visible="false" SortExpression="reciter" UniqueName="reciter"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="year" DataType="System.Int16" HeaderText="year" SortExpression="year" UniqueName="year"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="format" HeaderText="format" SortExpression="format" UniqueName="format"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="duration" DataType="System.TimeSpan" HeaderText="duration" SortExpression="duration" UniqueName="duration"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="size" HeaderText="size" SortExpression="size" UniqueName="size"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="tags" HeaderText="tags" SortExpression="tags" Visible="false" UniqueName="tags"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="counter" DataType="System.Int32" HeaderText="counter" SortExpression="counter" UniqueName="counter"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="uploader" HeaderText="uploader" SortExpression="uploader" UniqueName="uploader"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="date" HeaderText="date" DataFormatString="{0:d}" SortExpression="date" UniqueName="date" DataType="System.DateTime"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="Discontinued" DataType="System.Boolean" HeaderText="Discontinued" SortExpression="Discontinued" UniqueName="Discontinued" EditFormColumnIndex="1"> </telerik:GridCheckBoxColumn> <%--TEMPLATE COLUMN FOR UPLOADING--%> <telerik:GridTemplateColumn DataField="url" HeaderText="URL New" SortExpression="url" UniqueName="urlUpload"> <EditItemTemplate> <telerik:RadUpload ID="RadUpload1" Runat="server" InitialFileInputsCount="1" MaxFileInputsCount="1" maxfilesize="1000000" ControlObjectsVisibility="None" > </telerik:RadUpload> </EditItemTemplate> <ItemTemplate> <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("url") %>' Text='<%# Eval("title") %>'></asp:HyperLink> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn ConfirmText=" Are you sure you want to Delete this Nauha?" ConfirmDialogType="RadWindow" ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn" HeaderText="Delete"> </telerik:GridButtonColumn> </Columns> <%--RECORD EDIT/INSERT OPTIONS--%><EditFormSettings> <EditColumn UniqueName="EditCommandColumn1"></EditColumn> <EditColumn ButtonType="ImageButton" InsertText="Insert Order" UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit"> </EditColumn></EditFormSettings></MasterTableView> <%--DOUBLE CLICKING ON GRIDVIEW ROW ACTIVATES THE EDIT ROW MODE--%> <ClientSettings> <ClientEvents OnRowDblClick="RowDblClick" /> </ClientSettings></telerik:RadGrid><telerik:GridTextBoxColumnEditor ID="GridTxtboxTemp" runat="server" TextBoxStyle-Width="300px" /><telerik:GridDropDownListColumnEditor ID="GridDropDownColumnEditor1" runat="server" DropDownStyle-Width="200px" /><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:muharramConnectionString %>" SelectCommand="SELECT * FROM [AreaName]"></asp:SqlDataSource><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:muharramConnectionString %>" DeleteCommand="DELETE FROM [Nauha] WHERE [nauhaID] = @original_nauhaID AND [title] = @original_title AND (([author] = @original_author) OR ([author] IS NULL AND @original_author IS NULL)) AND (([lyrics] = @original_lyrics) OR ([lyrics] IS NULL AND @original_lyrics IS NULL)) AND (([reciter] = @original_reciter) OR ([reciter] IS NULL AND @original_reciter IS NULL)) AND (([year] = @original_year) OR ([year] IS NULL AND @original_year IS NULL)) AND (([format] = @original_format) OR ([format] IS NULL AND @original_format IS NULL)) AND (([duration] = @original_duration) OR ([duration] IS NULL AND @original_duration IS NULL)) AND (([size] = @original_size) OR ([size] IS NULL AND @original_size IS NULL)) AND (([url] = @original_url) OR ([url] IS NULL AND @original_url IS NULL)) AND (([tags] = @original_tags) OR ([tags] IS NULL AND @original_tags IS NULL)) AND (([counter] = @original_counter) OR ([counter] IS NULL AND @original_counter IS NULL)) AND (([uploader] = @original_uploader) OR ([uploader] IS NULL AND @original_uploader IS NULL)) AND (([date] = @original_date) OR ([date] IS NULL AND @original_date IS NULL)) AND (([areaID] = @original_areaID) OR ([areaID] IS NULL AND @original_areaID IS NULL)) AND (([Discontinued] = @original_Discontinued) OR ([Discontinued] IS NULL AND @original_Discontinued IS NULL))" InsertCommand="INSERT INTO [Nauha] ([title], [author], [lyrics], [reciter], [year], [format], [duration], [size], [url], [tags], [counter], [uploader], [date], [areaID], [Discontinued]) VALUES (@title, @author, @lyrics, @reciter, @year, @format, @duration, @size, @url, @tags, @counter, @uploader, @date, @areaID, @Discontinued)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Nauha] ORDER BY [areaID]" UpdateCommand="UPDATE [Nauha] SET [title] = @title, [author] = @author, [lyrics] = @lyrics, [reciter] = @reciter, [year] = @year, [format] = @format, [duration] = @duration, [size] = @size, [url] = @url, [tags] = @tags, [counter] = @counter, [uploader] = @uploader, [date] = @date, [areaID] = @areaID, [Discontinued] = @Discontinued WHERE [nauhaID] = @original_nauhaID AND [title] = @original_title AND (([author] = @original_author) OR ([author] IS NULL AND @original_author IS NULL)) AND (([lyrics] = @original_lyrics) OR ([lyrics] IS NULL AND @original_lyrics IS NULL)) AND (([reciter] = @original_reciter) OR ([reciter] IS NULL AND @original_reciter IS NULL)) AND (([year] = @original_year) OR ([year] IS NULL AND @original_year IS NULL)) AND (([format] = @original_format) OR ([format] IS NULL AND @original_format IS NULL)) AND (([duration] = @original_duration) OR ([duration] IS NULL AND @original_duration IS NULL)) AND (([size] = @original_size) OR ([size] IS NULL AND @original_size IS NULL)) AND (([url] = @original_url) OR ([url] IS NULL AND @original_url IS NULL)) AND (([tags] = @original_tags) OR ([tags] IS NULL AND @original_tags IS NULL)) AND (([counter] = @original_counter) OR ([counter] IS NULL AND @original_counter IS NULL)) AND (([uploader] = @original_uploader) OR ([uploader] IS NULL AND @original_uploader IS NULL)) AND (([date] = @original_date) OR ([date] IS NULL AND @original_date IS NULL)) AND (([areaID] = @original_areaID) OR ([areaID] IS NULL AND @original_areaID IS NULL)) AND (([Discontinued] = @original_Discontinued) OR ([Discontinued] IS NULL AND @original_Discontinued IS NULL))"> <DeleteParameters> <asp:Parameter Name="original_nauhaID" Type="Int32" /> <asp:Parameter Name="original_title" Type="String" /> <asp:Parameter Name="original_author" Type="String" /> <asp:Parameter Name="original_lyrics" Type="String" /> <asp:Parameter Name="original_reciter" Type="String" /> <asp:Parameter Name="original_year" Type="Int16" /> <asp:Parameter Name="original_format" Type="String" /> <asp:Parameter DbType="Time" Name="original_duration" /> <asp:Parameter Name="original_size" Type="String" /> <asp:Parameter Name="original_url" Type="String" /> <asp:Parameter Name="original_tags" Type="String" /> <asp:Parameter Name="original_counter" Type="Int32" /> <asp:Parameter Name="original_uploader" Type="String" /> <asp:Parameter Name="original_date" Type="DateTime" /> <asp:Parameter Name="original_areaID" Type="Int32" /> <asp:Parameter Name="original_Discontinued" Type="Boolean" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="title" Type="String" /> <asp:Parameter Name="author" Type="String" /> <asp:Parameter Name="lyrics" Type="String" /> <asp:Parameter Name="reciter" Type="String" /> <asp:Parameter Name="year" Type="Int16" /> <asp:Parameter Name="format" Type="String" /> <asp:Parameter DbType="Time" Name="duration" /> <asp:Parameter Name="size" Type="String" /> <asp:Parameter Name="url" Type="String" /> <asp:Parameter Name="tags" Type="String" /> <asp:Parameter Name="counter" Type="Int32" /> <asp:Parameter Name="uploader" Type="String" /> <asp:Parameter Name="date" Type="DateTime" /> <asp:Parameter Name="areaID" Type="Int32" /> <asp:Parameter Name="Discontinued" Type="Boolean" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="title" Type="String" /> <asp:Parameter Name="author" Type="String" /> <asp:Parameter Name="lyrics" Type="String" /> <asp:Parameter Name="reciter" Type="String" /> <asp:Parameter Name="year" Type="Int16" /> <asp:Parameter Name="format" Type="String" /> <asp:Parameter DbType="Time" Name="duration" /> <asp:Parameter Name="size" Type="String" /> <asp:Parameter Name="url" Type="String" /> <asp:Parameter Name="tags" Type="String" /> <asp:Parameter Name="counter" Type="Int32" /> <asp:Parameter Name="uploader" Type="String" /> <asp:Parameter Name="date" Type="DateTime" /> <asp:Parameter Name="areaID" Type="Int32" /> <asp:Parameter Name="Discontinued" Type="Boolean" /> <asp:Parameter Name="original_nauhaID" Type="Int32" /> <asp:Parameter Name="original_title" Type="String" /> <asp:Parameter Name="original_author" Type="String" /> <asp:Parameter Name="original_lyrics" Type="String" /> <asp:Parameter Name="original_reciter" Type="String" /> <asp:Parameter Name="original_year" Type="Int16" /> <asp:Parameter Name="original_format" Type="String" /> <asp:Parameter DbType="Time" Name="original_duration" /> <asp:Parameter Name="original_size" Type="String" /> <asp:Parameter Name="original_url" Type="String" /> <asp:Parameter Name="original_tags" Type="String" /> <asp:Parameter Name="original_counter" Type="Int32" /> <asp:Parameter Name="original_uploader" Type="String" /> <asp:Parameter Name="original_date" Type="DateTime" /> <asp:Parameter Name="original_areaID" Type="Int32" /> <asp:Parameter Name="original_Discontinued" Type="Boolean" /> </UpdateParameters></asp:SqlDataSource>Protected Sub RadGrid1_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound If TypeOf e.Item Is GridEditableItem And e.Item.IsInEditMode Then Dim upload As RadUpload = e.Item.FindControl("RadUpload1") Dim script As String = String.Format("uploadId = '{0}';", upload.ClientID) ScriptManager.RegisterStartupScript(Page, Page.[GetType](), "initialize", script, True) End IfEnd Sub Protected Sub RadGrid1_ItemInserted(source As Object, e As Telerik.Web.UI.GridInsertedEventArgs) Handles RadGrid1.ItemInserted Dim item As GridEditFormInsertItem = DirectCast(e.Item, GridEditFormInsertItem) Dim uploader As RadUpload = TryCast(e.Item.FindControl("RadUpload1"), RadUpload) Dim myUploadedFile As UploadedFile = uploader.UploadedFiles(0) Dim fileName As String = myUploadedFile.FileName 'Gets the uploaded file extension Dim fileExt As String fileExt = System.IO.Path.GetExtension(myUploadedFile.FileName).ToLower myUploadedFile.SaveAs("~/Uploads/" & fileName) End Sub
Might anyone be able to suggest why I am geting this error when I host my web application in IIS?
If I use the Visual Studio Dev server, the page loads with a scheduler.
All I do is create a virtual directory for my app in IIS and I get the following error...
Any hep would be greatly appreciated. Thanks.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.WebException: The remote server returned an error: (401) Unauthorized.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
|
| <telerik:RadScheduler ID="RadScheduler1" |
| runat="server" |
| Height="" |
| HoursPanelTimeFormat="htt" |
| ValidationGroup="RadScheduler1" |
| StartEditingInAdvancedForm="false" |
| Skin="Office2007"> |
| <WebServiceSettings Path="SchedulerWebService.asmx" ResourcePopulationMode="ServerSide" /> |
| </telerik:RadScheduler> |

Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
SqlDataSource1.SelectCommand = "exec CreateForecastEntry 'F2012v1', 'USA-ILMO-T1' "
grdForecast.DataBind()
End Sub
tc.HeaderText = "qty_" & e.Item.UniqueID
tc.UniqueName = "qty1_" & e.Item.UniqueID
tc.ItemTemplate = New MyTemplate(tc.UniqueName)
grdForecast.MasterTableView.Columns.Add(tc)
End Sub
Private Class MyTemplate
Implements ITemplate
Protected textBox As TextBox
Private colname As String
Public Sub New(ByVal cName As String)
MyBase.New()
colname = cName
End Sub
Public Sub InstantiateIn(ByVal container As System.Web.UI.Control) Implements ITemplate.InstantiateIn
textBox = New TextBox
textBox.ID = "abc"
container.Controls.Add(textBox)
End Sub
End Class
<telerik:RadListView ID="rlv_telephone" runat="server" AllowPaging="true" ItemPlaceholderID="pnl_telephone" DataKeyNames="telephone_id"><telerik:RadDataPager ID="rdp_account_telephone" runat="server" PagedControlID="rlv_telephone" PageSize="2" Font-Size="10px"> Private Sub rlv_telephone_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadListViewItemEventArgs) Handles rlv_telephone.ItemDataBound If TypeOf (e.Item) Is RadListViewDataItem Then Dim item = TryCast(e.Item, RadListViewDataItem) Dim datakey As DataKey = Me.rlv_telephone.DataKeyValues(item.DataItemIndex) TryCast(item.FindControl("btn_edittelephone"), RadButton).Attributes.Add("onclick", "openTelephone('" & datakey("telephone_id") & "')") End If End Sub Private Sub rlv_telephone_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadListViewNeedDataSourceEventArgs) Handles rlv_telephone.NeedDataSource GetTelephones() End Sub Protected Sub GetTelephones(Optional ByVal bind As Boolean = False) Me.rlv_telephone.DataSource = fe_telephone.functions.get_fe_telephone_list_by_account_id(this_account_id) If bind Then Me.rlv_telephone.DataBind() End If End Sub<telerik:RadPanelBar ID="RadPanelBar" runat="server" Width="100%" OnClientItemExpand="onItemExpand"> <Items> <telerik:RadPanelItem Text="Zoeken" Value="Search"> <ContentTemplate> <asp:Panel ID="ExamSearchPanel" runat="server" DefaultButton="SearchButton"> <table> <tr> <td> <asp:Table runat="server"> <asp:TableRow ID="TrainingCompanyRow" runat="server"> <asp:TableCell>Opleider:</asp:TableCell> <asp:TableCell><telerik:RadTextBox ID="TrainingCompanyTextBox" runat="server" /></asp:TableCell> </asp:TableRow>