Even session timeout is set to 20 in web.config, the session is not in stable. now and then it is clared, I

had written the sessionstage in config as follows:

<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424"  

sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"      cookieless="false"   

timeout="1200"     />

and as another one

 <sessionState mode="InProc"  timeout="120" regenerateExpiredSessionId="false">
    
      <providers>
        <clear/>
      </providers>
    </sessionState>

Can you give us the solution for it. Or is there any controversy against your telerik.web.ui trial version,

which is used in our web for demo.

Expecting your needy and primary solution with eager,

With Regards
S Suriya Narayanan
  

My RadMenu does not have cursor defined, so it always shows the regular cursor when hovered over a menu item. I want to change it to pointer (hand) on hover. I cannot do it from the css because not all items have url tied to them, especially the ones that have child nodes tied to them. Here's my xml example.


As you can see, Products, Usage, and Region don't have urls tied to them. So when user hovers on them, I want the cursor to be the default one, but when they hover on others, eg. Product1-3, Asia, or Eurpoe, I want the cursor to turn to pointer (hand).

What is the best way I can achieve this?

This is what I currently have. It is on server-side. However, I think client-side approach will be better.


Thanks.

Hi,

I have a problem with modal window, that is opened form inside of   RadAjaxPanel.

I have this RadAjaxPanel tag with Timer.

<telerik:RadAjaxPanel ID="ExistReportsGrid_Panel" runat="server" Visible="false">
                            <asp:Timer ID="ExistReportsGrid_Timer" runat="server" Interval="4000" OnTick="ExistReportsGrid_Timer_Tick"
                                Enabled="false">
Timer is enabled serverside.

On timer tick I enable one button also inside ExistReportsGrid_Panel, that opens modal windows. I open modal window this way:

<Buttons:xxx ID="BtnShowModal" Text="Show graph" runat="server"  OnClick="showModal"
                    meta:resourcekey="BtnShowModal" Visible="true" />

RadWindowManager is also insde RadAjaxPanel
<telerik:RadWindowManager ID="RadWndwManager" runat="server" Behavior="Default"
                            InitialBehavior="None" Left="" style="display: none;" Top="">
</telerik:RadWindowManager>

This is function I use for opening modal wnd
        RadWindow WinPreview = new RadWindow();
        WinPreview.Width = Unit.Pixel(840);
        WinPreview.Height = Unit.Pixel(700);
        WinPreview.NavigateUrl = "~/pages/xxxx/xxxxxx.aspx?lid=" + SelectedReport.ToString();
        WinPreview.Behaviors = WindowBehaviors.Move | WindowBehaviors.Resize | WindowBehaviors.Close | WindowBehaviors.Reload | WindowBehaviors.Maximize;
        WinPreview.VisibleOnPageLoad = true;
        WinPreview.Modal = true;
        WinPreview.Title = "";
        WinPreview.VisibleStatusbar = false;
        WinPreview.KeepInScreenBounds = true;
        WinPreview.EnableEmbeddedBaseStylesheet = true; //Wenn in Codebehind dann auf true sonst kein Style
        RadWndwManager.Windows.Add(WinPreview);


When modal window shows, I get really weird Window with something like tabs, and width is near infinity.

This code works well, and gives nice window if RadWindowManager and button are outside RadAjaxPanel

see attached screenshots of modal window

hi.
I'm having a problem with telerik: RadUpload which discussed below.
First, my website is programmed with the framework 3.5 using the Q2 2009 SP1 version of ASP.NET AJAX.
Second, the problem I am experiencing is when I upload a file to the internet, that is, on my website when you upload a file is usually a photo or image, which is renamed to avoid problems when you want upload a file with the same name. This control (RadUpload) is in a form in which besides also upload the image stored in the database text fields entered by users and the name of the image, when the customer clicks the accept button .
Now I handle this event in the codebehind where I try to save the image to the destination folder and retrieve the name to insert in the database.
This is the code I use:

Private Function guardarArchivo (ByVal strSql As String, ByVal strSqlValues As String) As String
        Dim string As String = ""
        Dim FileName As String = ""
        If Foto.UploadedFiles.Count> 0 Then
            For Each uploadedFile As UploadedFile In Foto.UploadedFiles
                TargetFolder Dim As String = Server.MapPath ( "~ / Images / Pictures" Notes ")
                FileName = DateTime.Now.Ticks.ToString () & archivoSubido.GetExtension ()
                archivoSubido.SaveAs (Path.Combine (TargetFolder, FileName), False)
            Next
            strSql = strSql & ", [Picture]
            strSqlValues = strSqlValues & " '" & FileName & "'"
            str = "ok"
        Else
            str = "error1"
        End If
        Return string
    End Function

which is called from the event
Protected Sub Save (ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ButtonSend.Click

but when checks Foto.UploadedFiles.Count> 0 always tells me not
I need your help
I wonder if the IIS7 or I am missing something in the web.config

<?xml version="1.0" encoding="UTF-8"?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    \Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
    <configSections>
        <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
            <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
                <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
                <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
                    <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" />
                    <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
                    <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
                    <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
                </sectionGroup>
            </sectionGroup>
        </sectionGroup>
    </configSections>
    <appSettings>
        <add key="StartPage" value="~/Portada.aspx" />
        <add key="Telerik.Skin" value="Hay" />
    </appSettings>
    <connectionStrings>
        <!--<add name="CulturaConnectionString" connectionString="Data Source=quierocultura.db.5690715.hostedresource.com; Initial Catalog=quierocultura; User ID=quierocultura; Password=Cultura05/03;" providerName="System.Data.SqlClient"/>-->
        <add name="CulturaConnectionString" connectionString="Data Source=GONZALO-PC;Initial Catalog=CulturaEnLinea;Integrated Security=True; user id=Gonzalo; password=;;packet size=4096" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
        <customErrors mode="Off" />
        <httpRuntime maxRequestLength="3072" executionTimeout="110" />
        <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
        -->
        <compilation batchTimeout="180" debug="true" explicit="true" strict="false">
            <assemblies>
                <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
                <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
                <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
                <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /></assemblies>
        </compilation>
        <pages>
            <namespaces>
                <clear />
                <add namespace="System" />
                <add namespace="System.Collections" />
                <add namespace="System.Collections.Generic" />
                <add namespace="System.Collections.Specialized" />
                <add namespace="System.Configuration" />
                <add namespace="System.Text" />
                <add namespace="System.Text.RegularExpressions" />
                <add namespace="System.Linq" />
                <add namespace="System.Xml.Linq" />
                <add namespace="System.Web" />
                <add namespace="System.Web.Caching" />
                <add namespace="System.Web.SessionState" />
                <add namespace="System.Web.Security" />
                <add namespace="System.Web.Profile" />
                <add namespace="System.Web.UI" />
                <add namespace="System.Web.UI.WebControls" />
                <add namespace="System.Web.UI.WebControls.WebParts" />
                <add namespace="System.Web.UI.HtmlControls" />
            </namespaces>
            <controls>
                <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
                <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
                <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI" />
            </controls>
        </pages>
        <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
        <authentication mode="Windows" />
        <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
        <httpHandlers>
            <remove verb="*" path="*.asmx" />
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
            <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false" />
            <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false" />
            <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false" />
            <add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false" />
            <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" />
        </httpHandlers>
        <httpModules>
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" />
            <add name="RadCompression" type="Telerik.Web.UI.RadCompression" />
        </httpModules>
    </system.web>
    <system.codedom>
        <compilers>
            <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
                <providerOption name="CompilerVersion" value="v3.5" />
                <providerOption name="WarnAsError" value="false" />
            </compiler>
            <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
                <providerOption name="CompilerVersion" value="v3.5" />
                <providerOption name="OptionInfer" value="true" />
                <providerOption name="WarnAsError" value="false" />
            </compiler>
        </compilers>
    </system.codedom>
    <!--
        The system.webServer section is required for running ASP.NET AJAX under Internet
        Information Services 7.0.  It is not necessary for previous version of IIS.
    -->
    <system.webServer>
        <httpErrors errorMode="Detailed" />
        <asp scriptErrorSentToBrowser="true" />
        <validation validateIntegratedModeConfiguration="false" />
        <modules>
            <remove name="ScriptModule" />
            <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" preCondition="integratedMode" />
            <add name="RadCompression" type="Telerik.Web.UI.RadCompression" />
        </modules>
        <handlers>
            <remove name="WebServiceHandlerFactory-Integrated" />
            <remove name="ScriptHandlerFactory" />
            <remove name="ScriptHandlerFactoryAppServices" />
            <remove name="ScriptResource" />
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
            <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0" />
            <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0" />
            <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0" />
            <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0" />
            <add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode,runtimeVersionv2.0" />
        </handlers>

    </system.webServer>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
                <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35" />
                <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
            </dependentAssembly>
            <dependentAssembly>
                <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35" />
                <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
            </dependentAssembly>
        </assemblyBinding>
    </runtime>
</configuration>

ah I forget to mention that my page is hosted on godaddy servers and have permits mid-level of confidence and when I try to upload the files with a form of testing gives me error.

 Security Exception
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request failed.

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.

Stack Trace:

[SecurityException: Request failed.]
   System.Security.CodeAccessSecurityEngine.ThrowSecurityException (Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed) +150
   System.Security.CodeAccessSecurityEngine.ThrowSecurityException (Object assemblyOrString, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed) +100
   System.Security.CodeAccessSecurityEngine.CheckSetHelper (PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Object assemblyOrString, SecurityAction action, Boolean ThrowException) +284
   System.Security.PermissionSetTriple.CheckSetDemand (demandSet PermissionSet, PermissionSet & alteredDemandset, RuntimeMethodHandle rmh) +69
   System.Security.PermissionListSet.CheckSetDemand (PermissionSet pset, RuntimeMethodHandle rmh) +150
   System.Security.PermissionListSet.DemandFlagsOrGrantSet (Int32 flags, PermissionSet grantSet) +30
   System.Threading.CompressedStack.DemandFlagsOrGrantSet (Int32 flags, PermissionSet grantSet) +40
   System.Security.CodeAccessSecurityEngine.ReflectionTargetDemandHelper (Int32 permission, PermissionSet targetGrant, CompressedStack SecurityContext) +123
   System.Security.CodeAccessSecurityEngine.ReflectionTargetDemandHelper (Int32 permission, PermissionSet targetGrant) +54

Grettings

As I am iterating through the days, I am changing the back color of those days with scheduled events on them. I would like to change the default tool tip to also show a subject from the event. Here is what I have so far. It shows the default tool tip of the date as I mouse over. Is there a way to change that?

Dear All,

I was using version 2009.2.826.35 (sp1) with one of my old projects, I decided to install the latest version 2009.3.1103
Everything seems to be okay, until I navigate to a page using Tab-strip and I found the scroll buttons have stopped working.
This Tab-strip contains tabs that created dynamically at run-time according to the example from the demo

I create another empty page with the following script that defines the tabs statically:

But the same behavior exists "No scrolling".

The buttons are there but when I hover the mouse over or click I get no response.
any ideas...

--- Edited at 9:46 AM ---------
I express the same behavior with the grid navigation buttons as well
-----------------------------------
Best regards
Waleed

I have a Project implemented with contains very TelerikComponents v.2009, and now I make the Download from a version posteded in the site, and My project not run more, What i have a doing? Help me Plesae. Very Thanks - James Lamb

I have an issue where RadComboBox item list and LoadingPanel both appear at the very top left of the browser window instead of their correct poisition (under dropdown in case of RadComboBox or over grid in case of LoadingPanel).

It works totally fine in IE8, but does not work in FireFox, Chrome or Safari.

Has anyone run into this before?

I am using 2009.3.1314.20 build of Telerik.Web.UI

My web site works fine when targeted to ASP.NET 3.5 but when targeted for ASP.NET 4.0, then none of the RadMenus display properly.

Again they display properly when the site is targeted for ASP.NET 3.5 and I have made no changes to the code other than retargeting against ASP.NET 4.0.

Are there any configuration changes that must be made in order to upgrade the RadMenu from 3.5 to 4.0?

Hi

I have a Grid VIew with 2 Web User Controls for updating and inserting  the records, everything is working fine except when update or insert all what i got is just Null Values in the Database.

any idea?

Thanks

Items.aspx
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Items.aspx.vb" Inherits="Items" %>

<%@ Register Assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral,
    Namespace="System.Web.UI.WebControls" TagPrefix="asp" %>

<!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">
<head runat="server">
    <title>Untitled Page</title>
    <script type="text/javascript">
    
      function pageLoad() {
      }
    
    </script>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <table class="style1">
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True"
                        AllowPaging="True" AllowSorting="True" AutoGenerateDeleteColumn="True"
                        AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1"
                        GridLines="None" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
                        AllowAutomaticUpdates="True">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="ItemID" DataSourceID="SqlDataSource1"
                            CommandItemDisplay="Top" EditMode="PopUp">
    <Columns>
        <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32"
            DefaultInsertValue="" HeaderText="ID" ReadOnly="True" SortExpression="ItemID"
            UniqueName="ItemID">
        </telerik:GridBoundColumn>
        
        <telerik:GridBoundColumn  UniqueName="DivisionName" DataField="DivisionName" HeaderText="Division"
                        HeaderStyle-Width="130px">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxDivision" Width="130" DataSourceID="SqlDataSource2" DataTextField="DivisionName"
                                DataValueField="DivisionName" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("DivisionName").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="DivisionIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">

                                <script type="text/javascript">
                                    function DivisionIndexChanged(sender, args) {
                                        var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                        tableView.filter("DivisionName", args.get_item().get_value(), "EqualTo");

                                    }
                                </script>

                            </telerik:RadScriptBlock>
                        </FilterTemplate>

<HeaderStyle Width="130px"></HeaderStyle>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="CategoryName" DataField="CategoryName" HeaderText="Category" HeaderStyle-Width="250px">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxCategory" Width="250" DataSourceID="SqlDataSource3" DataTextField="CategoryName"
                                DataValueField="CategoryName" Height="400px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("CategoryName").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="CategoryIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">

                                <script type="text/javascript">
                                    function CategoryIndexChanged(sender, args) {
                                        var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                        tableView.filter("CategoryName", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>

                            </telerik:RadScriptBlock>
                        </FilterTemplate>

<HeaderStyle Width="250px"></HeaderStyle>
                    </telerik:GridBoundColumn>
                             
        
        <telerik:GridBoundColumn UniqueName="TypeNAme" DataField="TypeNAme" HeaderText="TypeNAme" HeaderStyle-Width="250px">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxType" Width="250" DataSourceID="SqlDataSource4" DataTextField="TypeNAme"
                                DataValueField="TypeNAme" Height="400px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("TypeNAme").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="TypeIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">

                                <script type="text/javascript">
                                    function TypeIndexChanged(sender, args) {
                                        var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                        tableView.filter("TypeNAme", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>

                            </telerik:RadScriptBlock>
                        </FilterTemplate>

<HeaderStyle Width="250px"></HeaderStyle>
                    </telerik:GridBoundColumn>
                             
        
        <telerik:GridBoundColumn DataField="CodeName" DefaultInsertValue=""
            HeaderText="Code" SortExpression="CodeName" UniqueName="CodeName">
            <HeaderStyle Width="50px" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                HorizontalAlign="Left" Wrap="True" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="FullCode" DefaultInsertValue=""
            HeaderText="Full Code" SortExpression="FullCode" UniqueName="FullCode">
            <HeaderStyle Width="250px" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="SectionName" DefaultInsertValue=""
            HeaderText="Section" SortExpression="SectionName" UniqueName="SectionName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="VersionName" DefaultInsertValue=""
            HeaderText="Version" SortExpression="VersionName" UniqueName="VersionName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="PagesNumber" DataType="System.Int32"
            DefaultInsertValue="" HeaderText="# of Pages" SortExpression="PagesNumber"
            UniqueName="PagesNumber" Visible="False">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="UnitCost" DataType="System.Decimal"
            DefaultInsertValue="" HeaderText="Unit Cost" SortExpression="UnitCost"
            UniqueName="UnitCost" Visible="False">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ItemCost" DataType="System.Decimal"
            DefaultInsertValue="" HeaderText="Item Cost" ReadOnly="True"
            SortExpression="ItemCost" UniqueName="ItemCost" DataFormatString="{0:c2}">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ReleaseDate" DataType="System.DateTime"
            DefaultInsertValue="" HeaderText="Release Date" SortExpression="ReleaseDate"
            UniqueName="ReleaseDate" DataFormatString="{0:d}">
        </telerik:GridBoundColumn>
        <telerik:GridCheckBoxColumn DataField="Discontinued" DataType="System.Boolean"
            DefaultInsertValue="False" HeaderText="Discontinued" SortExpression="Discontinued"
            UniqueName="Discontinued">
        </telerik:GridCheckBoxColumn>
        
    </Columns>
    <EditFormSettings EditFormType="WebUserControl"
        UserControlName="ItemsEdit.ascx">
        <PopUpSettings Width="800px" />
    </EditFormSettings>
</MasterTableView>
                        <ClientSettings>
                            <Selecting AllowRowSelect="True" />
                        </ClientSettings>
                    </telerik:RadGrid>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        DeleteCommand="DELETE FROM [Item] WHERE [ItemID] = @ItemID"
        InsertCommand="INSERT INTO [Item] ([DivisionID], [CategoryID], [TypeID], [CodeID], [FullCode], [SectionID], [VersionID], [PagesNumber], [UnitCost], [ReleaseDate], [Discontinued], [ItemDescription]) VALUES (@DivisionID, @CategoryID, @TypeID, @CodeID, @FullCode, @SectionID, @VersionID, @PagesNumber, @UnitCost, @ReleaseDate, @Discontinued, @ItemDescription)"
        SelectCommand="SELECT Item.ItemID, Division.DivisionName, Category.CategoryName, Type.TypeName, Code.CodeName, Item.FullCode, Section.SectionName, Version.VersionName, Item.PagesNumber, Item.UnitCost, Item.ItemCost, Item.ReleaseDate, Item.Discontinued, Item.ItemDescription, Item.DivisionID, Item.CategoryID, Item.TypeID, Item.CodeID, Item.SectionID, Item.VersionID FROM Item INNER JOIN Category ON Item.CategoryID = Category.CategoryID INNER JOIN Code ON Item.CodeID = Code.CodeID INNER JOIN Division ON Item.DivisionID = Division.DivisionID INNER JOIN Section ON Item.SectionID = Section.SectionID INNER JOIN Type ON Item.TypeID = Type.TypeID INNER JOIN Version ON Item.VersionID = Version.VersionID ORDER BY Category.CategoryName"
        UpdateCommand="UPDATE [Item] SET [DivisionID] = @DivisionID, [CategoryID] = @CategoryID, [TypeID] = @TypeID, [CodeID] = @CodeID, [FullCode] = @FullCode, [SectionID] = @SectionID, [VersionID] = @VersionID, [PagesNumber] = @PagesNumber, [UnitCost] = @UnitCost, [ReleaseDate] = @ReleaseDate, [Discontinued] = @Discontinued, [ItemDescription] = @ItemDescription WHERE [ItemID] = @ItemID">
        <DeleteParameters>
            <asp:Parameter Name="ItemID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="DivisionID" Type="Int32" />
            <asp:Parameter Name="CategoryID" Type="Int32" />
            <asp:Parameter Name="TypeID" Type="Int32" />
            <asp:Parameter Name="CodeID" Type="Int32" />
            <asp:Parameter Name="FullCode" Type="String" />
            <asp:Parameter Name="SectionID" Type="Int32" />
            <asp:Parameter Name="VersionID" Type="Int32" />
            <asp:Parameter Name="PagesNumber" Type="Int32" />
            <asp:Parameter Name="UnitCost" Type="Decimal" />
            <asp:Parameter DbType="Date" Name="ReleaseDate" />
            <asp:Parameter Name="Discontinued" Type="Boolean" />
            <asp:Parameter Name="ItemDescription" Type="String" />
            <asp:Parameter Name="ItemID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="DivisionID" Type="Int32" />
            <asp:Parameter Name="CategoryID" Type="Int32" />
            <asp:Parameter Name="TypeID" Type="Int32" />
            <asp:Parameter Name="CodeID" Type="Int32" />
            <asp:Parameter Name="FullCode" Type="String" />
            <asp:Parameter Name="SectionID" Type="Int32" />
            <asp:Parameter Name="VersionID" Type="Int32" />
            <asp:Parameter Name="PagesNumber" Type="Int32" />
            <asp:Parameter Name="UnitCost" Type="Decimal" />
            <asp:Parameter DbType="Date" Name="ReleaseDate" />
            <asp:Parameter Name="Discontinued" Type="Boolean" />
            <asp:Parameter Name="ItemDescription" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
 
    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        SelectCommand="SELECT [DivisionID], [DivisionName] FROM [Division] ORDER BY [DivisionName]">
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSource3" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        
        SelectCommand="SELECT DISTINCT [CategoryID], [CategoryName] FROM [Category] ORDER BY [CategoryName]">
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSource4" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        
        
        SelectCommand="SELECT [TypeID], [TypeName] FROM [Type] ORDER BY [TypeName]"
        DeleteCommand="DELETE FROM [Type] WHERE [TypeID] = @TypeID"
        InsertCommand="INSERT INTO [Type] ([TypeName]) VALUES (@TypeName)"
        UpdateCommand="UPDATE [Type] SET [TypeName] = @TypeName WHERE [TypeID] = @TypeID">
        <DeleteParameters>
            <asp:Parameter Name="TypeID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="TypeName" Type="String" />
            <asp:Parameter Name="TypeID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="TypeName" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    
    </form>
</body>
</html>
-------------------------------------------------------------------------------------------------
ItemsInsert.ascx
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ItemsInsert.ascx.vb" Inherits="ItemsUpdIns" %>
<style type="text/css">
    .style1
    {
        width: 100%;
    }
    .style2
    {
        font-weight: bold;
        text-align: right;
    }
    .style3
    {
        font-weight: bold;
        text-align: right;
        height: 24px;
    }
    .style4
    {
        height: 24px;
    }
    .style5
    {
        font-weight: bold;
    }
    .style6
    {
        text-align: right;
    }
    .style7
    {
        height: 24px;
        text-align: right;
    }
</style>
<table class="style1" width="750">
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Division</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox1" Runat="server"
                DataSourceID="SqlDataSource1"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.DivisionID" ) %>' DataTextField="DivisionName"
                DataValueField="DivisionID" Width="160px" Skin="Sunset">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Number of pages</td>
        <td width="150">
            <telerik:RadNumericTextBox ID="RadNumericTextBox1" Runat="server"
                Culture="English (United Kingdom)"
                Text='<%# DataBinder.Eval( Container, "DataItem.PagesNumber" ) %>' Value="0"
                Width="75px" ShowSpinButtons="True">
            </telerik:RadNumericTextBox>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Category</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox3" Runat="server"
                DataSourceID="SqlDataSource2"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.CategoryID" ) %>' DataTextField="CategoryName"
                DataValueField="CategoryID" Width="250px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Unit Cost</td>
        <td width="150">
            <telerik:RadNumericTextBox ID="RadNumericTextBox2" Runat="server"
                Culture="English (United Kingdom)" Text='<%# DataBinder.Eval( Container, "DataItem.UnitCost" ) %>' ShowSpinButtons="True" Type="Currency"
                Value="0" Width="75px">
            </telerik:RadNumericTextBox>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Item Type</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox4" Runat="server"
                DataSourceID="SqlDataSource3"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.TypeID" ) %>' DataTextField="TypeName"
                DataValueField="TypeID" Width="250px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Item Cost</td>
        <td width="150">
            £
            <asp:Label ID="Label1" runat="server" Text='<%# DataBinder.Eval( Container, "DataItem.ItemCost" ) %>'></asp:Label>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Section</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox5" Runat="server"
                DataSourceID="SqlDataSource4"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.SectionID" ) %>' DataTextField="SectionName"
                DataValueField="SectionID" Width="100px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Release Date</td>
        <td width="150">
            <telerik:RadDatePicker ID="RadDatePicker1" Text='<%# DataBinder.Eval( Container, "DataItem.ReleaseDate" ) %>' Runat="server"
                Culture="English (United Kingdom)" SelectedDate="2010-03-15" Width="150px">
<Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x"></Calendar>

<DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>

<DateInput DisplayDateFormat="dd/MM/yyyy" DateFormat="dd/MM/yyyy" SelectedDate="2010-03-15"></DateInput>
            </telerik:RadDatePicker>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Version</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox6" Runat="server"
                DataSourceID="SqlDataSource5"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.VersionID" ) %>' DataTextField="VersionName"
                DataValueField="VersionID" Width="150px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Discontinued</td>
        <td width="150">
            <asp:CheckBox ID="CheckBox1" Checked='<%# DataBinder.Eval( Container, "DataItem.Discontinued" ) %>' runat="server" />
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Code</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox7" Runat="server"
                DataSourceID="SqlDataSource6"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.CodeID" ) %>' DataTextField="CodeName"
                DataValueField="CodeID" Width="75px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Full Code</td>
        <td width="150">
            <asp:TextBox id="TextBox3" runat="server"
Text='<%# DataBinder.Eval( Container, "DataItem.FullCode" ) %>' Width="200px"></asp:textbox>
        </td>
    </tr>
    <tr>
        <td class="style3" width="150">
            </td>
        <td width="300" class="style4">
            &nbsp;</td>
        <td width="150" class="style7">
            </td>
        <td width="150" class="style4">
            </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Item Description</td>
        <td width="300">
            <asp:TextBox id="TextBox4" runat="server"
Text='<%# DataBinder.Eval( Container, "DataItem.ItemDescription" ) %>' Width="290px"
                Height="50px" TextMode="MultiLine"></asp:textbox>
        </td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style6">
            <asp:Button ID="btnUpdate" runat="server"
                            CommandName='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "PerformInsert", "Update") %>'
                            Text='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "Insert", "Update") %>'
                            Width="150px" />
        </td>
        <td width="150">
            <asp:Button ID="btnCancel" runat="server" Text="Cancel" Width="150px" CausesValidation="false"
                        CommandName="Cancel"></asp:Button>
        </td>
    </tr>
    </table>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Division] WHERE [DivisionID] = @DivisionID"
    InsertCommand="INSERT INTO [Division] ([DivisionName]) VALUES (@DivisionName)"
    SelectCommand="SELECT [DivisionID], [DivisionName] FROM [Division] ORDER BY [DivisionName]"
    UpdateCommand="UPDATE [Division] SET [DivisionName] = @DivisionName WHERE [DivisionID] = @DivisionID">
    <DeleteParameters>
        <asp:Parameter Name="DivisionID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="DivisionName" Type="String" />
        <asp:Parameter Name="DivisionID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="DivisionName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Category] WHERE [CategoryID] = @CategoryID"
    InsertCommand="INSERT INTO [Category] ([CategoryName]) VALUES (@CategoryName)"
    SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Category] ORDER BY [CategoryName]"
    UpdateCommand="UPDATE [Category] SET [CategoryName] = @CategoryName WHERE [CategoryID] = @CategoryID">
    <DeleteParameters>
        <asp:Parameter Name="CategoryID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="CategoryName" Type="String" />
        <asp:Parameter Name="CategoryID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="CategoryName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>


<asp:SqlDataSource ID="SqlDataSource3" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Type] WHERE [TypeID] = @TypeID"
    InsertCommand="INSERT INTO [Type] ([TypeName]) VALUES (@TypeName)"
    SelectCommand="SELECT [TypeID], [TypeName] FROM [Type] ORDER BY [TypeName]"
    UpdateCommand="UPDATE [Type] SET [TypeName] = @TypeName WHERE [TypeID] = @TypeID">
    <DeleteParameters>
        <asp:Parameter Name="TypeID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="TypeName" Type="String" />
        <asp:Parameter Name="TypeID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="TypeName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>



<asp:SqlDataSource ID="SqlDataSource4" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Section] WHERE [SectionID] = @SectionID"
    InsertCommand="INSERT INTO [Section] ([SectionName]) VALUES (@SectionName)"
    SelectCommand="SELECT [SectionID], [SectionName] FROM [Section] ORDER BY [SectionName]"
    UpdateCommand="UPDATE [Section] SET [SectionName] = @SectionName WHERE [SectionID] = @SectionID">
    <DeleteParameters>
        <asp:Parameter Name="SectionID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="SectionName" Type="String" />
        <asp:Parameter Name="SectionID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="SectionName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Version] WHERE [VersionID] = @VersionID"
    InsertCommand="INSERT INTO [Version] ([VersionName]) VALUES (@VersionName)"
    SelectCommand="SELECT [VersionID], [VersionName] FROM [Version] ORDER BY [VersionName]"
    UpdateCommand="UPDATE [Version] SET [VersionName] = @VersionName WHERE [VersionID] = @VersionID">
    <DeleteParameters>
        <asp:Parameter Name="VersionID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="VersionName" Type="String" />
        <asp:Parameter Name="VersionID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="VersionName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource6" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Code] WHERE [CodeID] = @CodeID"
    InsertCommand="INSERT INTO [Code] ([CodeName]) VALUES (@CodeName)"
    SelectCommand="SELECT [CodeID], [CodeName] FROM [Code] ORDER BY [CodeName]"
    UpdateCommand="UPDATE [Code] SET [CodeName] = @CodeName WHERE [CodeID] = @CodeID">
    <DeleteParameters>
        <asp:Parameter Name="CodeID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="CodeName" Type="String" />
        <asp:Parameter Name="CodeID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="CodeName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>