or
| Private Sub RadGridWorksheet_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGridWorksheet.ItemCreated |
| If e.Item.ItemType = GridItemType.CommandItem Then |
| Dim commandItem As GridCommandItem = CType(e.Item, GridCommandItem) |
| Dim showFilterLinkButton As LinkButton = commandItem.FindControl("ShowFilterBoxesLinkButton") |
| Dim hideFilterLinkButton As LinkButton = commandItem.FindControl("HideFilterBoxesLinkButton") |
| 'Adding the event handler |
| AddHandler showFilterLinkButton.Click, AddressOf chkFilter_CheckedChanged |
| AddHandler hideFilterLinkButton.Click, AddressOf chkFilter_CheckedChanged |
| End If |
| End Sub |
| Protected Sub chkFilter_CheckedChanged(ByVal Sender As Object, ByVal e As System.EventArgs) |
| ' Toggle the filter boxes |
| RadGridWorksheet.AllowFilteringByColumn = Not RadGridWorksheet.AllowFilteringByColumn |
| RadGridWorksheet.Rebind() |
| End Sub |
Hi,
I want to resize my grid on widow resizing. I got the sample code from telerik site, its working fine. But while I am minimizing the window the horizontal scroll bar is not come in the grid. Here i have around 14 columns in a grid so i want to scroll and view the records. Please help me on this. Here s my code.
| RadUpload Ajax callback error. Source url returned invalid content: |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US"> |
| <head id="Head"> |
| <!--**********************************************************************************--> |
| <!-- DotNetNuke� - http://www.dotnetnuke.com --> |
| <!-- Copyright (c) 2002-2008 --> |
| <!-- by DotNetNuke Corporation --> |
| <!--**********************************************************************************--> |
| <meta id="MetaKeywords" name="KEYWORDS" content=",DotNetNuke,DNN" /><meta id="MetaCopyright" name="COPYRIGHT" content="Copyright 2009 by DotNetNuke Corporation" /><meta id="MetaGenerator" name="GENERATOR" content="DotNetNuke " /><meta id="MetaAuthor" name="AUTHOR" content="Cuoc Thi Anh" /><meta name="RESOURCE-TYPE" content="DOCUMENT" /><meta name="DISTRIBUTION" content="GLOBAL" /><meta name="ROBOTS" content="INDEX, FOLLOW" /><meta name="REVISIT-AFTER" content="1 DAYS" /><meta name="RATING" content="GENERAL" /><meta http-equiv="PAGE-ENTER" content="RevealTrans(Duration=0,Transition=1)" /><style id="StylePlaceholder" type="text/css"></style><link id="_CuocThiAnh_Portals__default_" rel="stylesheet" type="text/css" href="/CuocThiAnh/Portals/_default/default.css" /><link id="_CuocThiAnh_Portals__default_Skins_MinimalExtropy_" rel="stylesheet" type="text/css" href="/CuocThiAnh/Portals/_default/Skins/MinimalExtropy/skin.css" /><link id="_CuocThiAnh_Portals__default_Containers_MinimalExtropy_" rel="stylesheet" type="text/css" href="/CuocThiAnh/Portals/_default/Containers/MinimalExtropy/container.css" /><link id="_CuocThiAnh_Portals__default_Containers_MinimalExtropy_title_grey_css" rel="stylesheet" type="text/css" href="/CuocThiAnh/Portals/_default/Containers/MinimalExtropy/title_grey.css" /><link id="_CuocThiAnh_Portals_0_" rel="stylesheet" type="text/css" href="/CuocThiAnh/Portals/0/portal.css" /><!--[if LT IE 7]><link id="IE6Minus" rel="stylesheet" type="text/css" href="/CuocThiAnh/Portals/_default/Skins/MinimalExtropy/css/ie6skin.css" /><![endif]--><link href="/CuocThiAnh/WebResource.axd?d=ZhppardGa4F-kTgS97vnn8daA2kg6FzWLiK_FZ8Ojl8ndqEdQgvaeb1BlE_NI4In0&t=633613964300000000" type="text/css" rel="stylesheet" class="Telerik_stylesheet" /><link href="/CuocThiAnh/WebResource.axd?d=ZhppardGa4F-kTgS97vnn8daA2kg6FzWLiK_FZ8Ojl9Yi5bgs6mf8TI3RepTyQwbnHviZBJExUxI2_t1fjeDUA2&t=633613964300000000" type="text/css" rel="stylesheet" class="Telerik_stylesheet" /><title> |
| Cuoc Thi Anh > a |
| </title></head> |
| <body id="Body"> |
| <noscript></noscript> |
| <form name="Form" method="post" action="/cuocthianh/a/tabid/56/Telerik.RadUploadProgressHandler.ashx?RadUrid=85790ca6-6655-4b15-af4a-f11c07e9ae7e&RadUploadTimeStamp=1237434384872&" id="Form" enctype="multipart/form-data" style="height: 100%;" autocomplete="off"> |
| <div> |
| <input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" /> |
| <input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" /> |
| <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUJMjgzMDU3ODk3D2QWBmYPFgIeBFRleHQFeTwhRE9DVFlQRSBodG1sIFBVQkxJQyAiLS8vVzNDLy9EVEQgWEhUTUwgMS4wIFRyYW5zaXRpb25hbC8vRU4iICJodHRwOi8vd3d3LnczLm9yZy9UUi94aHRtbDEvRFREL3hodG1sMS10cmFuc2l0aW9uYWwuZHRkIj5kAgEPZBYMAgEPFgIeB1Zpc2libGVoZAICDxYEHgdjb250ZW50ZB8BaGQCAw8WAh8CBQ8sRG90TmV0TnVrZSxETk5kAgQPFgIfAgUoQ29weXJpZ2h0IDIwMDkgYnkgRG90TmV0TnVrZSBDb3Jwb3JhdGlvbmQCBQ8WAh8CBQtEb3ROZXROdWtlIGQCBg8WAh8CBQxDdW9jIFRoaSBBbmhkAgIPZBYCAgEPZBYCAgQPZBYCZg9kFhICAw9kFghmDxYCHwFoZAIBDxAPFgIfAWhkZBYAZAICDxYCHwFoZAIDDxYCHwFoZAIFD2QWAmYPDxYEHgdUb29sVGlwBQxDdW9jIFRoaSBBbmgeC05hdmlnYXRlVXJsBShodHRwOi8vbG9jYWxob3N0L2N1b2N0aGlhbmgvRGVmYXVsdC5hc3B4ZGQCBw9kFgRmDxYCHwFoFgYCAQ8QDxYKHghDc3NDbGFzcwUQU2VydmVyU2tpbldpZGdldB8ABQNXZWIfAwURR29vZ2xlIFdlYiBTZWFyY2geB0NoZWNrZWRnHgRfIVNCAgJkZGRkAgMPEA8WCh8FBRBTZXJ2ZXJTa2luV2lkZ2V0HwAFBFNpdGUfAwULU2l0ZSBTZWFyY2gfBmcfBwICZGRkZAIHDw8WBh8FBRBTZXJ2ZXJTa2luV2lkZ2V0HwAFaTxpbWcgc3JjPSIvQ3VvY1RoaUFuaC9Qb3J0YWxzL19kZWZhdWx0L1NraW5zL01pbmltYWxFeHRyb3B5L2ltYWdlcy9zZWFyY2guZ2lmIiBib3JkZXI9IjAiIGFsdD0iU2VhcmNoIiAvPh8HAgJkZAICDxYCHwFnFgRmDw8WAh4NQWx0ZXJuYXRlVGV4dAUWU2VsZWN0IHRoZSBzZWFyY2ggdHlwZWRkAgIPDxYGHwUFEFNlcnZlclNraW5XaWRnZXQfAAVpPGltZyBzcmM9Ii9DdW9jVGhpQW5oL1BvcnRhbHMvX2RlZmF1bHQvU2tpbnMvTWluaW1hbEV4dHJvcHkvaW1hZ2VzL3NlYXJjaC5naWYiIGJvcmRlcj0iMCIgYWx0PSJTZWFyY2giIC8+HwcCAmRkAg8PZBYCZg8PFgYfBQUEdXNlch8ABQhSZWdpc3Rlch8HAgJkZAIRD2QWAmYPDxYGHwUFBHVzZXIfAAUFTG9naW4fBwICZGQCFQ8WAh4FY2xhc3MFFUxlZnRQYW5lIEROTkVtcHR5UGFuZWQCFw9kFgICAQ9kFhACAQ8PFgIfAWhkZAICDw8WAh8BaGRkAgQPZBYCAgIPFgIfAWhkAgYPZBYCZg8PFgIfAwUITWluaW1pemUWBh4Hb25jbGljawVSaWYgKF9fZG5uX0NvbnRhaW5lck1heE1pbl9PbkNsaWNrKHRoaXMsICdkbm5fY3RyMzY4X01vZHVsZUNvbnRlbnQnKSkgcmV0dXJuIGZhbHNlOx4LY29udGFpbmVyaWQFAzM2OB4IY29va2llaWQFEl9Nb2R1bGUzNjhfVmlzaWJsZRYCZg8PFgYeCEltYWdlVXJsBUsvQ3VvY1RoaUFuaC9Qb3J0YWxzL19kZWZhdWx0L0NvbnRhaW5lcnMvTWluaW1hbEV4dHJvcHkvaW1hZ2VzL0ROTi1taW51cy5naWYfCAUITWluaW1pemUfAwUITWluaW1pemVkZAIID2QWAgICD2QWAgIBD2QWBAICDw8WAh4XRW5hYmxlQWpheFNraW5SZW5kZXJpbmdoZGQCBA8PFgIfDmhkZAIKDw8WAh8BaGRkAgwPDxYCHwFoZGQCEA8PFgIfAWhkZAIZDxYCHwkFFlJpZ2h0UGFuZSBETk5FbXB0eVBhbmVkAhsPFgIfCQUXQm90dG9tUGFuZSBETk5FbXB0eVBhbmVkGAEFHl9fQ29udHJvbHNSZXF1aXJlUG9zdEJhY2tLZXlfXxYDBRRkbm4kZG5uTkFWJGN0bGRubk5BVgUmZG5uJGN0cjM2OCRQb3N0UGljJFJhZFByb2dyZXNzTWFuYWdlcjEFI2RubiRjdHIzNjgkUG9zdFBpYyRSYWRQcm9ncmVzc0FyZWExMkXzgfAsBAZUKN14aCMRrm6cIwk=" /> |
| </div> |
| <script type="text/javascript"> |
| //<![CDATA[ |
| var theForm = document.forms['Form']; |
| if (!theForm) { |
| theForm = document.Form; |
| } |
| function __doPostBack(eventTarget, eventArgument) { |
| if (!theForm.onsubmit || (theForm.onsubmit() != false)) { |
| theForm.__EVENTTARGET.value = eventTarget; |
| theForm.__EVENTARGUMENT.value = eventArgument; |
| theForm.submit(); |
| } |
| } |
| //]]> |
| </script> |
| <script src="/CuocThiAnh/WebResource.axd?d=BBG9v5jgz6cMqHNW2rSzDw2&t=633725758209375000" type="text/javascript"></script> |
| ............... |
| <httpModules> |
| <!-- add name="Authentication" type="DotNetNuke.HttpModules.AuthenticationModule, DotNetNuke.HttpModules.Authentication" / --> |
| <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> |
| <add name="Compression" type="DotNetNuke.HttpModules.Compression.CompressionModule, DotNetNuke.HttpModules" /> |
| <add name="RequestFilter" type="DotNetNuke.HttpModules.RequestFilter.RequestFilterModule, DotNetNuke.HttpModules" /> |
| <add name="UrlRewrite" type="DotNetNuke.HttpModules.UrlRewriteModule, DotNetNuke.HttpModules" /> |
| <add name="Exception" type="DotNetNuke.HttpModules.Exceptions.ExceptionModule, DotNetNuke.HttpModules" /> |
| <add name="UsersOnline" type="DotNetNuke.HttpModules.UsersOnline.UsersOnlineModule, DotNetNuke.HttpModules" /> |
| <add name="DNNMembership" type="DotNetNuke.HttpModules.Membership.MembershipModule, DotNetNuke.HttpModules" /> |
| <add name="Personalization" type="DotNetNuke.HttpModules.Personalization.PersonalizationModule, DotNetNuke.HttpModules" /> |
| <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule, Telerik.Web.UI"/> |
| ................. |
| <httpHandlers> |
| <!-- This is for CAPTCHA support --> |
| <add verb="*" path="*.captcha.aspx" type="DotNetNuke.UI.WebControls.CaptchaHandler, DotNetNuke" /> |
| <!-- This is for Serving files, secure, insecure, from database --> |
| <add verb="*" path="LinkClick.aspx" type="DotNetNuke.Services.FileSystem.FileServerHandler, DotNetNuke" /> |
| <!-- This adds syndication support --> |
| <add verb="*" path="RSS.aspx" type="DotNetNuke.Services.Syndication.RssHandler, DotNetNuke" /> |
| <!-- This adds legacy support for the Logoff page --> |
| <add verb="*" path="Logoff.aspx" type="DotNetNuke.Services.Authentication.LogOffHandler, DotNetNuke" /> |
| <!-- ASP.NET AJAX support --> |
| <remove verb="*" path="*.asmx" /> |
| <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> |
| <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> |
| <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" /> |
| <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI"/> |
| </httpHandlers> |
| ....................... |
| <handlers> |
| <add name="AJAX_ScriptResourceHandler" path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="AJAX_AppServiceHandler" path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="AJAX_WebServiceHandler" path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="LogoffHandler*" path="Logoff.aspx" verb="*" type="DotNetNuke.Services.Authentication.LogOffHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="RSSJandler" path="RSS.aspx" verb="*" type="DotNetNuke.Services.Syndication.RssHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="LinkClickHandler" path="LinkClick.aspx" verb="*" type="DotNetNuke.Services.FileSystem.FileServerHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="CaptchaHandler" path="*.captcha.aspx" verb="*" type="DotNetNuke.UI.WebControls.CaptchaHandler, DotNetNuke" preCondition="integratedMode,runtimeVersionv2.0" /> |
| <add name="Telerik.RadUploadProgressHandler.ashx_*" path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI" preCondition="integratedMode,runtimeVersionv2.0"/> |
| </handlers> |
| <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="PostPic.ascx.cs" Inherits="hqdai.Modules.EO_Pictures.PostPic" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /> |
| <telerik:RadProgressManager ID="RadProgressManager1" runat="server" /> |
| <br /> |
| <telerik:RadProgressArea |
| ID="RadProgressArea1" |
| runat="server" |
| DisplayCancelButton="True" |
| ProgressIndicators="FilesCountBar, |
| FilesCount, |
| FilesCountPercent, |
| SelectedFilesCount, |
| CurrentFileName, |
| TimeElapsed, |
| TimeEstimated"> |
| </telerik:RadProgressArea> |
| using System; |
| using System.Collections; |
| using System.ComponentModel; |
| using System.Data; |
| using System.Drawing; |
| using System.Web; |
| using System.Web.SessionState; |
| using System.Web.UI; |
| using System.Web.UI.WebControls; |
| using System.Web.UI.HtmlControls; |
| using DotNetNuke.Common.Utilities; |
| using DotNetNuke.Entities.Modules; |
| using DotNetNuke.Entities.Modules.Actions; |
| using DotNetNuke.Services.Exceptions; |
| using DotNetNuke.Services.Localization; |
| using Telerik.Web.UI; |
| using Telerik.Web.UI.Upload; |
| using hqdai.EO_Pictures.Components; |
| namespace hqdai.Modules.EO_Pictures |
| { |
| public partial class PostPic : PortalModuleBase, IActionable |
| { |
| protected void Page_Load(object sender, EventArgs e) |
| { |
| if (!IsPostBack) |
| { |
| RadProgressArea1.Localization.UploadedFiles = "Completed Steps: "; |
| RadProgressArea1.Localization.CurrentFileName = "Step: "; |
| RadProgressArea1.Localization.TotalFiles = "Total Steps:"; |
| } |
| } |
| #region IActionable Members |
| public DotNetNuke.Entities.Modules.Actions.ModuleActionCollection ModuleActions |
| { |
| get |
| { |
| //create a new action to add an item, this will be added to the controls |
| //dropdown menu |
| ModuleActionCollection actions = new ModuleActionCollection(); |
| actions.Add(GetNextActionID(), Localization.GetString(ModuleActionType.AddContent, this.LocalResourceFile), |
| ModuleActionType.AddContent, "", "", EditUrl(), false, DotNetNuke.Security.SecurityAccessLevel.Edit, |
| true, false); |
| return actions; |
| } |
| } |
| #endregion |
| protected void Button1_Click(object sender, EventArgs e) |
| { |
| RadProgressContext context = RadProgressContext.Current; |
| context.SecondaryTotal = "100"; |
| for (int i = 1; i < 100; i++) |
| { |
| context.SecondaryValue = i.ToString(); |
| context.SecondaryPercent = i.ToString(); |
| context.CurrentOperationText = "Doing step " + i.ToString(); |
| if (!Response.IsClientConnected) |
| { |
| //Cancel button was clicked or the browser was closed, so stop processing |
| break; |
| } |
| // simulate a long time performing the current step |
| System.Threading.Thread.Sleep(100); |
| } |
| } |
| } |
| } |
| <telerik:RadGrid ID="documentsGrid" DataSourceID="vegasDataSource" runat="server" | |
| Skin="Office2007" AutoGenerateColumns="False" GridLines="Vertical" AllowSorting="True"> | |
| <HeaderContextMenu> | |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> | |
| </HeaderContextMenu> | |
| <MasterTableView CommandItemDisplay="Top" DataKeyNames="dokid,levid" DataSourceID="vegasDataSource" | |
| EditMode="PopUp" AllowAutomaticInserts="True" AllowAutomaticDeletes="True" AllowAutomaticUpdates="True"> | |
| <RowIndicatorColumn> | |
| <HeaderStyle Width="20px"></HeaderStyle> | |
| </RowIndicatorColumn> | |
| <ExpandCollapseColumn> | |
| <HeaderStyle Width="20px"></HeaderStyle> | |
| </ExpandCollapseColumn> | |
| <Columns> | |
| <telerik:GridEditCommandColumn /> | |
| <telerik:GridTemplateColumn DataField="levid" UniqueName="customer_id" Visible="false" | |
| ReadOnly="true"> | |
| </telerik:GridTemplateColumn> | |
| <telerik:GridBoundColumn HeaderText="Number" UniqueName="document_id" DataField="dokid" | |
| ReadOnly="true"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn HeaderText="Name" UniqueName="document_name" DataField="doknavn"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn HeaderText="Path" UniqueName="document_path" DataField="Path" | |
| Visible="false"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn HeaderText="Url" UniqueName="document_url" DataField="url" | |
| Visible="false"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridDropDownColumn HeaderText="Type" UniqueName="documen_type" ListTextField="type_description" | |
| ListValueField="type_name" DataField="doktype" DataSourceID="vegasDocumentTypeDataSource"> | |
| </telerik:GridDropDownColumn> | |
| <telerik:GridDateTimeColumn HeaderText="Revision Date" UniqueName="column4" DataField="revisjonsdato"> | |
| </telerik:GridDateTimeColumn> | |
| <telerik:GridDateTimeColumn HeaderText="Edited" UniqueName="column3" DataField="document_edited" | |
| ReadOnly="true"> | |
| </telerik:GridDateTimeColumn> | |
| <telerik:GridDateTimeColumn HeaderText="Added" UniqueName="column5" DataField="document_added" | |
| ReadOnly="true"> | |
| </telerik:GridDateTimeColumn> | |
| <telerik:GridCheckBoxColumn HeaderText="Expired" DataField="utgaatt" UniqueName="document_expired" | |
| Display="false" DataType="System.Boolean"> | |
| </telerik:GridCheckBoxColumn> | |
| <telerik:GridButtonColumn CommandName="Delete" Text="Delete"> | |
| </telerik:GridButtonColumn> | |
| </Columns> | |
| <EditFormSettings> | |
| <EditColumn UniqueName="EditCommandColumn1"> | |
| </EditColumn> | |
| </EditFormSettings> | |
| </MasterTableView> | |
| <ClientSettings> | |
| <ClientEvents OnRowDblClick="RowDblClick" /> | |
| </ClientSettings> | |
| <FilterMenu> | |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> | |
| </FilterMenu> | |
| </telerik:RadGrid> | |
| </div> | |
| </form> | |
| </body> | |
| </html> | |
| <asp:sqldatasource runat="server" id="vegasDataSource" connectionstring="<%$ ConnectionStrings:vegas %>" | |
| deletecommand="vegas.usp_DocumentationsDelete" deletecommandtype="StoredProcedure" | |
| insertcommand="vegas.usp_DocumentationsInsert" insertcommandtype="StoredProcedure" | |
| selectcommand="vegas.usp_DocumentationSelectReportByCustomerId" selectcommandtype="StoredProcedure" | |
| updatecommand="vegas.usp_DocumentationsUpdate" updatecommandtype="StoredProcedure"> | |
| <SelectParameters> | |
| <asp:QueryStringParameter DefaultValue="100630" Name="customer_id" | |
| QueryStringField="customerId" Type="Int32" /> | |
| </SelectParameters> | |
| <DeleteParameters> | |
| <asp:Parameter Name="document_id" Type="String" /> | |
| </DeleteParameters> | |
| <UpdateParameters> | |
| <asp:QueryStringParameter DefaultValue="100630" Name="customer_id" QueryStringField="customerId" Type="Int32" /> | |
| <asp:Parameter Name="document_id" Type="Int32" /> | |
| <asp:Parameter Name="document_name" Type="String" /> | |
| <asp:Parameter Name="document_path" Type="String" /> | |
| <asp:Parameter Name="documen_type" Type="String" /> | |
| <asp:Parameter Name="document_url" Type="String" /> | |
| <asp:Parameter Name="document_expired" Type="Boolean" /> | |
| <asp:Parameter Name="document_date" Type="DateTime" /> | |
| <asp:Parameter Name="document_hms" Type="String" DefaultValue="" /> | |
| <asp:Parameter Name="document_msds" Type="Object" DefaultValue="" /> | |
| </UpdateParameters> | |
| <InsertParameters> | |
| <asp:QueryStringParameter DefaultValue="100630" Name="customer_id" QueryStringField="customerId" Type="Int32" /> | |
| <asp:Parameter Name="document_number" Type="String" /> | |
| <asp:Parameter Name="document_name" Type="String" /> | |
| <asp:Parameter Name="document_path" Type="String" /> | |
| <asp:Parameter Name="documen_type" Type="String" /> | |
| <asp:Parameter Name="document_url" Type="String" /> | |
| <asp:Parameter Name="document_edited" Type="DateTime" /> | |
| <asp:Parameter Name="document_expired" Type="Boolean" /> | |
| <asp:Parameter Name="document_hms" Type="String" /> | |
| <asp:Parameter Name="document_msds" Type="Object" /> | |
| <asp:Parameter Direction="InputOutput" Name="document_id" Type="Int32" /> | |
| </InsertParameters> | |
| </asp:sqldatasource> |
| exec vegas.usp_DocumentationsUpdate | |
| @customer_id=100630, | |
| @document_id=NULL, | |
| @document_name=NULL, | |
| @document_path=NULL, | |
| @documen_type=NULL, | |
| @document_url=NULL, | |
| @document_expired=NULL, | |
| @document_date=NULL, | |
| @document_hms=NULL, | |
| @document_msds=NULL, | |
| @doktype=N'Ã…', | |
| @doknavn=N'Peva-45', | |
| @url=N'http://lasso.norbye.no/weblicate/lasso/alsvag.no/resources/Brosjyre_Peva-45.pdf', | |
| @Path=N'alsvaag/Brosjyre_Peva-45.pdf', | |
| @revisjonsdato=N'06.03.2006 00:00:00', | |
| @utgaatt=1, | |
| @dokid=N'100630_002', | |
| @levid=100630 |