This is a migrated thread and some comments may be shown as answers.

DB2 SQL Parameter Values on Update-RadGrid

3 Answers 182 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Todd
Top achievements
Rank 1
Todd asked on 02 Mar 2011, 02:14 PM
I am using the design time interface to create a hierarchical grid 3 tiered. auto update insert delete as well. I am using DB2 SQL to perform these actions, which I have written the same as with the Norhwind database examples except I must use ( instead of [ around the field and variable '?' that appear in the examples. I have defined the parameters to be selected, updated and deleted based on what type of field it is in the AS400. Our numerics are packed with 0 decimals for instance and strings of course. I can perform each action with the character only rows like the first level of my grid. It works perfectly, but when the data to be inserted or updated has a mixture of data in the fields to be updated or inserted I end up getting error messages, and I have Dbtyped these fields every way I can think of to get this message to stop. "Record cannot be updated. Reason: Command parameter[8] '' data value could not be converted for reasons other than sign mismatch or data overflow". I've tried other values like "Decimal" for instance in the update parameter for an AS400 packed field with zero decimals. Any help would be greatly appreciated. Todd

my SQL for update is as follows in the aspx

UpdateCommand

 

="UPDATE XX.WSP060 SET WAPPAC = ?, WAMAXD = ?, WAMAXT = ?, WARSTS = ?, WAATMS = ? WHERE (WABCTP = ?) AND (WABCAT = ?) AND (WADESC = ?) AND (WACMPY = ?) AND (WAIDENT = ?) AND (WACLASS = ?) AND (WASTYLE = ?) AND (WACOLOR = ?) AND (WASIZE = ?)"

my parameters for the update are

 

 

<

 

UpdateParameters>

 

 

 

 

<asp:FormParameter Name="WABCTP" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WABCAT" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WADESC" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WACMPY" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WAIDENT" DbType="Int32" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WACLASS" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WASTYLE" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WACOLOR" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WASIZE" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WAPPAC" DbType="Int32" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WAMAXD" DbType="Int32" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WAMAXT" DbType="Int32" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WARSTS" DbType="String" />

 

 

 

 

 

 

 

 

 

<asp:FormParameter Name="WAATMS" DbType="String" />

 

 

 

 

</UpdateParameters>

 

3 Answers, 1 is accepted

Sort by
0
Iana Tsolova
Telerik team
answered on 07 Mar 2011, 01:32 PM
Hi Todd,

In the UpdateParameters collection I observed that you have defined a few parameters of type FormParameters. If the values for the parameters should come from the grid, try using ASP:Parameter.
Other than this, can you specify which is the problematic data field, what is its data type in the data table, and what is the value you are entering in the grid edit form for it?

Regards,
Iana
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
0
Todd
Top achievements
Rank 1
answered on 05 Apr 2011, 02:49 PM
OK,
    I've now tried everyway that I now to get these files to update automatically. All files and keys seem to
match the SQL seems correct for updating my DB2 files. I am still getting parameter problems, though looking
at them one at the time at update, I see what I want to see. I would like to see the entire sql string before
it writes so that I can determine why it keeps saying that I have a problem with parameters 3,10,13..??? If
there is any way you could kick me back onto the right track I would greatly appreciate it. Thanks, Todd


<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" Theme="AB_Grid"%>
  
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<%--<%@ Register TagPrefix="sds" Namespace="Telerik.Web.SessionDS" %>--%>
  
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head id="Head1" runat="server">
    <title></title>
           <link href="..App_Themes/Default/AB_Main.css" rel="stylesheet" type="text/css" />
</head>
  
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <br />
       <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1"
            GridLines="None" AutoGenerateInsertColumn="True" AutoGenerateDeleteColumn="True" 
            AutoGenerateEditColumn="True" AllowAutomaticDeletes="True" 
            AllowAutomaticInserts="True" AllowAutomaticUpdates="True" 
            Skin="Outlook" Width="95%" AutoGenerateColumns="False" OnUpdateCommand="RadGrid1_UpdateCommand">>
           
<HeaderContextMenu></HeaderContextMenu>
  
<MasterTableView datakeynames="WSBRAB" 
                datasourceid="SqlDataSource1" InsertItemDisplay="TOP" 
                CommandItemDisplay="Top" TableLayout="Fixed">
    <DetailTables>
        <telerik:GridTableView runat="server"  DataKeyNames = "WABCTP,WABCAT,WADESC,WACMPY,WAIDENT,WACLASS,WASTYLE,WACOLOR,WASIZE"
        datasourceid="SqlDataSource2" InsertItemDisplay="TOP" CommandItemDisplay="Top" Name = "Detail1">
              
            <DetailTables>
                <telerik:GridTableView runat="server"  DataKeyNames = "WCBCTP,WCBCAT,WCDESC,WCCMPY,WCIDENT"
                    DataSourceID="SqlDataSource3" InsertItemDisplay="TOP" 
                    CommandItemDisplay="Top" Name = "Detail2">
                    <ParentTableRelation>
                       <telerik:GridRelationFields DetailKeyField="WCBCTP" MasterKeyField="WABCTP"/>
                    </ParentTableRelation>
                    <NestedViewSettings>
                        <ParentTableRelation>
                            <telerik:GridRelationFields DetailKeyField="WCBCTP,WCBCAT,WCDESC,WCCMPY,WCIDENT" MasterKeyField="WABCTP,WABCAT,WADESC,WACMPY,WAIDENT" />
                        </ParentTableRelation>
                    </NestedViewSettings>
                    <CommandItemSettings ExportToPdfText="Export to Pdf" AddNewRecordText="Add "/>
                    <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                        <HeaderStyle Width="5px" />
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                        <HeaderStyle Width="5px" />
                    </ExpandCollapseColumn>
                    <Columns>    
                        <telerik:GridBoundColumn DataField="WCBCTP" 
                            FilterControlAltText="Filter WCBCTP column" HeaderText="Type" 
                            SortExpression="WCBCTP" UniqueName="WCBCTP" MaxLength="2" DataFormatString="{0:G17}" >
                        </telerik:GridBoundColumn>                    
                        <telerik:GridBoundColumn DataField="WCBCAT" 
                            FilterControlAltText="Filter WCBCAT column" HeaderText="Name" 
                            SortExpression="WCBCAT" UniqueName="WCBCAT" MaxLength="50">
                        </telerik:GridBoundColumn>                   
                        <telerik:GridBoundColumn DataField="WCDESC" 
                            FilterControlAltText="Filter WCDESC column" HeaderText="Description" 
                            SortExpression="WCDESC" UniqueName="WCDESC" MaxLength="50">
                        </telerik:GridBoundColumn>                    
                        <telerik:GridBoundColumn DataField="WCCMPY" 
                            FilterControlAltText="Filter WCCMPY column" HeaderText="Company" 
                            SortExpression="WCCMPY" UniqueName="WCCMPY" MaxLength="1">
                        </telerik:GridBoundColumn>                    
                        <telerik:GridBoundColumn DataField="WCIDENT" 
                            FilterControlAltText="Filter WCIDENT column" HeaderText="Ident" 
                            SortExpression="WCIDENT" UniqueName="WCIDENT" MaxLength="6" DataFormatString="{0:N0}">
                        </telerik:GridBoundColumn>                                             
                        <telerik:GridBoundColumn DataField="WCCLASS" 
                            FilterControlAltText="Filter WCCLASS column" HeaderText="Class" 
                            SortExpression="WCCLASS" UniqueName="WCCLASS" MaxLength="2">
                        </telerik:GridBoundColumn>                    
                        <telerik:GridBoundColumn DataField="WCSTYLE" 
                            FilterControlAltText="Filter WCSTYLE column" HeaderText="Style" 
                            SortExpression="WCSTYLE" UniqueName="WCSTYLE" MaxLength="5">
                        </telerik:GridBoundColumn>                        
                        <telerik:GridBoundColumn DataField="WCCOLOR" 
                            FilterControlAltText="Filter WCCOLOR column" HeaderText="Color" 
                            SortExpression="WCCOLOR" UniqueName="WCCOLOR" MaxLength="5">
                        </telerik:GridBoundColumn>                  
                        <telerik:GridBoundColumn DataField="WCSIZE" 
                            FilterControlAltText="Filter WCSIZE column" HeaderText="Size" 
                            SortExpression="WCSIZE" UniqueName="WCSIZE" MaxLength="8">
                        </telerik:GridBoundColumn>                  
                        <telerik:GridBoundColumn DataField="WCDSML" 
                            FilterControlAltText="Filter WCDSML column" HeaderText="Thumbnail" 
                            SortExpression="WCDSML" UniqueName="WCDSML" MaxLength="50">
                        </telerik:GridBoundColumn>                  
                        <telerik:GridBoundColumn DataField="WCDLRG" 
                            FilterControlAltText="Filter WCDLRG column" HeaderText="Large Pic" 
                            SortExpression="WCDLRG" UniqueName="WCDLRG" MaxLength="50">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="WCDORD" 
                            FilterControlAltText="Filter WCDORD column" HeaderText="Order In Display" 
                            SortExpression="WCDORD" UniqueName="WCDORD" MaxLength="2" DataFormatString="{0:N0}">
                        </telerik:GridBoundColumn>
                        <Telerik:GridTemplateColumn UniqueName="TempCol">  
                        <ItemTemplate>  
                            <asp:Image ID="imgMarketing" runat="server"/>      
                        </ItemTemplate>  
                        </Telerik:GridTemplateColumn>  
  
  
                    </Columns>
                     
                    <EditFormSettings>
                        <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                        </EditColumn>
                    </EditFormSettings>
                      
                </telerik:GridTableView>
            </DetailTables>
            <ParentTableRelation>
                <telerik:GridRelationFields DetailKeyField="WABCTP" MasterKeyField="WSBRAB" />
            </ParentTableRelation>
            <NestedViewSettings DataSourceID="SqlDataSource2">
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="WABCTP" MasterKeyField="WSBRAB" />
                </ParentTableRelation>
            </NestedViewSettings>
            <CommandItemSettings ExportToPdfText="Export to Pdf" AddNewRecordText="Add " />
            <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                <HeaderStyle Width="5px" />
            </RowIndicatorColumn>
            <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" 
                Visible="True">
                <HeaderStyle Width="5px" />
            </ExpandCollapseColumn>
            <Columns>
             
                <telerik:GridBoundColumn DataField="WABCTP" 
                    FilterControlAltText="Filter WABCTP column" HeaderText="Code" 
                    SortExpression="WABCTP" UniqueName="WABCTP" MaxLength="2">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WABCAT" 
                    FilterControlAltText="Filter WABCAT column" HeaderText="Name" 
                    SortExpression="WABCAT" UniqueName="WABCAT" MaxLength="50">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WADESC" 
                    FilterControlAltText="Filter WADESC column" HeaderText="Description" 
                    SortExpression="WADESC" UniqueName="WADESC" MaxLength="50">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WACMPY" 
                    FilterControlAltText="Filter WACMPY column" HeaderText="Company" 
                    SortExpression="WACMPY" UniqueName="WACMPY" MaxLength="1">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WAIDENT" 
                    FilterControlAltText="Filter WAIDENT column" HeaderText="Ident"  DataType="System.Int32"
                    SortExpression="WAIDENT" UniqueName="WAIDENT" MaxLength="6" DataFormatString="{0:N0}">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WACLASS" 
                    FilterControlAltText="Filter WACLASS column" HeaderText="Class" 
                    SortExpression="WACLASS" UniqueName="WACLASS" MaxLength="2">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WASTYLE" 
                    FilterControlAltText="Filter WASTYLE column" HeaderText="Style" 
                    SortExpression="WASTYLE" UniqueName="WASTYLE" MaxLength="5">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WACOLOR" 
                    FilterControlAltText="Filter WACOLOR column" HeaderText="Color" 
                    SortExpression="WACOLOR" UniqueName="WACOLOR" MaxLength="5">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WASIZE" 
                    FilterControlAltText="Filter WASIZE column" HeaderText="Size" 
                    SortExpression="WASIZE" UniqueName="WASIZE" MaxLength="8">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WAPPAC" 
                    FilterControlAltText="Filter WAPPAC column" HeaderText="Code"   DataType="System.Int32"
                    SortExpression="WAPPAC" UniqueName="WAPPAC" MaxLength="4" DataFormatString="{0:N0}">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WAMAXD" 
                    FilterControlAltText="Filter WAMAXD column" HeaderText="Max Dealer"   DataType="System.Int32"
                    SortExpression="WAMAXD" UniqueName="WAMAXD" MaxLength="4" DataFormatString="{0:N0}">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WAMAXT" 
                    FilterControlAltText="Filter WAMAXT column" HeaderText="Max TM"   DataType="System.Int32"
                    SortExpression="WAMAXT" UniqueName="WAMAXT" MaxLength="4" DataFormatString="{0:N0}">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WARSTS" 
                    FilterControlAltText="Filter WARSTS column" HeaderText="Status" 
                    SortExpression="WARSTS" UniqueName="WARSTS" MaxLength="1">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="WAATMS" 
                    FilterControlAltText="Filter WAATMS column" HeaderText="Allow Tm Order" 
                    SortExpression="WAATMS" UniqueName="WAATMS" MaxLength="1">
                </telerik:GridBoundColumn>
                  
            </Columns>
            <EditFormSettings>
                <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                </EditColumn>
            </EditFormSettings>
        </telerik:GridTableView>
    </DetailTables>
    <CommandItemSettings ExportToPdfText="Export to Pdf" AddNewRecordText="Add "></CommandItemSettings>
  
    <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="5px"></HeaderStyle>
</RowIndicatorColumn>
  
    <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" 
        visible="True">
<HeaderStyle Width="5px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridBoundColumn DataField="WSBRAB" DataType="System.String"
            FilterControlAltText="Filter WSBRAB column" HeaderText="Category Code"
            SortExpression="WSBRAB" UniqueName="WSBRAB" MaxLength="2">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="WSBRDC"  DataType="System.String"
            FilterControlAltText="Filter WSBRDC column" HeaderText="Category Description" 
            SortExpression="WSBRDC" UniqueName="WSBRDC" MaxLength="50">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="WSACT"  DataType="System.String"
            FilterControlAltText="Filter WSACT column" HeaderText="Activity Code" 
            SortExpression="WSACT" UniqueName="WSACT" MaxLength="1">
        </telerik:GridBoundColumn>
    </Columns>
    <EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>
<FilterMenu EnableImageSprites="False"></FilterMenu>
        </telerik:RadGrid>
        <br />
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT WSBRAB, WSBRDC, WSACT FROM xxxx.WSP050"  
            InsertCommand ="INSERT INTO xxxx.WSP050(WSBRAB, WSBRDC, WSACT) VALUES (?,?,?)" 
            DeleteCommand="DELETE FROM xxxx.WSP050 WHERE (WSBRAB = ?)" 
            UpdateCommand="UPDATE xxxx.WSP050 SET WSBRDC = ? , WSACT = ? WHERE (WSBRAB = ?)">
            <InsertParameters>
                <asp:Parameter Name="WSBRAB"/>
                <asp:Parameter Name="WSBRDC"/>
                <asp:Parameter Name="WSACT"/>
            </InsertParameters>
            <DeleteParameters>
                <asp:Parameter Name="WSBRAB"/>
                <asp:Parameter Name="WSBRDC"/>
                <asp:Parameter Name="WSACT"/>
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="WSBRAB"/>
                <asp:Parameter Name="WSBRDC"/>
                <asp:Parameter Name="WSACT"/>
           </UpdateParameters>
        </asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT WABCTP, WABCAT, WADESC, WACMPY, WAIDENT, WACLASS, WASTYLE, WACOLOR, WASIZE, WAPPAC, WAMAXD, WAMAXT, WARSTS, WAATMS FROM xxxx.WSP060 WHERE (WABCTP = ?)"
            InsertCommand ="INSERT INTO xxxx.WSP060(WABCTP, WABCAT, WADESC, WACMPY, WAIDENT, WACLASS, WASTYLE, WACOLOR, WASIZE, WAPPAC, WAMAXD, WAMAXT, WARSTS, WAATMS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)"            
            DeleteCommand ="DELETE FROM xxxx.WSP060 WHERE (WABCTP = ?) AND (WABCAT = ?) AND (WADESC = ?) AND (WACMPY = ?) AND (WAIDENT = ?) AND (WACLASS = ?) AND (WASTYLE = ?) AND (WACOLOR = ?) AND (WASIZE = ?) AND (WAPPAC = ?) AND (WAMAXD = ?) AND (WAMAXT = ?) AND (WARSTS = ?) AND (WAATMS = ?)"
            UpdateCommand ="UPDATE xxxx.WSP060 SET WAPPAC = ?, WAMAXD = ?, WAMAXT = ?, WARSTS = ?, WAATMS = ? WHERE (WABCTP = ?)AND (WABCAT = ?) AND (WADESC = ?) AND (WACMPY = ?) AND (WAIDENT = ?) AND (WACLASS = ?) AND (WASTYLE = ?) AND (WACOLOR = ?) AND (WASIZE = ?)">
              
            <SelectParameters>
            <asp:Parameter Name="WABCTP" Type="String"/>
                 
            </SelectParameters>
            <InsertParameters>
                 
                <asp:Parameter Name="WABCTP"/>
                <asp:Parameter Name="WABCAT"/>
                <asp:Parameter Name="WADESC"/>
                <asp:Parameter Name="WACMPY"/>
                <asp:Parameter Name="WAIDENT" Type= "Int32"/>
                <asp:Parameter Name="WACLASS"/>
                <asp:Parameter Name="WASTYLE"/>
                <asp:Parameter Name="WACOLOR"/>
                <asp:Parameter Name="WASIZE"/>
                <asp:Parameter Name="WAPPAC" Type= "Int32"/>
                <asp:Parameter Name="WAMAXD" Type= "Int32"/>
                <asp:Parameter Name="WAMAXT" Type= "Int32"/>
                <asp:Parameter Name="WARSTS"/>
                <asp:Parameter Name="WAATMS"/>               
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="WABCTP"/>
                <asp:Parameter Name="WABCAT"/>
                <asp:Parameter Name="WADESC"/>
                <asp:Parameter Name="WACMPY"/>
                <asp:Parameter Name="WAIDENT" Type= "Int32"/>
                <asp:Parameter Name="WACLASS"/>
                <asp:Parameter Name="WASTYLE"/>
                <asp:Parameter Name="WACOLOR"/>
                <asp:Parameter Name="WASIZE"/>
                <asp:Parameter Name="WAPPAC" Type= "Int32"/>
                <asp:Parameter Name="WAMAXD" Type= "Int32"/>
                <asp:Parameter Name="WAMAXT" Type= "Int32"/>
                <asp:Parameter Name="WARSTS"/>
                <asp:Parameter Name="WAATMS"/>               
            </UpdateParameters>
            <DeleteParameters>
                <asp:Parameter Name="WABCTP"/>
                <asp:Parameter Name="WABCAT"/>
                <asp:Parameter Name="WADESC"/>
                <asp:Parameter Name="WACMPY"/>
                <asp:Parameter Name="WAIDENT" Type= "Int32"/>
                <asp:Parameter Name="WACLASS"/>
                <asp:Parameter Name="WASTYLE"/>
                <asp:Parameter Name="WACOLOR"/>
                <asp:Parameter Name="WASIZE"/>
                <asp:Parameter Name="WAPPAC" Type= "Int32"/>
                <asp:Parameter Name="WAMAXD" Type= "Int32"/>
                <asp:Parameter Name="WAMAXT" Type= "Int32"/>
                <asp:Parameter Name="WARSTS"/>
                <asp:Parameter Name="WAATMS"/>                       
            </DeleteParameters>
        </asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT WCBCTP, WCBCAT, WCDESC, WCCMPY, WCIDENT, WCCLASS, WCSTYLE, WCCOLOR, WCSIZE, WCDSML, WCDLRG, WCDORD FROM xxxx.WSP070 WHERE (WCBCTP = ?)AND (WCBCAT = ?) AND (WCDESC = ?) AND (WCCMPY = ?) AND (WCIDENT = ?)"
            InsertCommand ="INSERT INTO xxxx.WSP070(WCBCTP, WCBCAT, WCDESC, WCCMPY, WCIDENT, WCCLASS, WCSTYLE, WCCOLOR, WCSIZE,WCDSML,WCDLRG,WCDORD ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)"
            UpdateCommand ="UPDATE xxxx.WSP070 SET WCDSML = ?, WCDLRG = ?, WCDORD = ? WHERE (WCBCTP = ?) AND (WCBCAT = ?) AND (WCDESC = ?) AND (WCCMPY = ?) AND (WCIDENT = ?) AND (WCCLASS = ?) AND (WCSTYLE = ?) AND (WCCOLOR = ?) AND (WCSIZE = ?)"
              
            DeleteCommand ="DELETE FROM xxxx.WSP070 WHERE (WCBCTP = ?) AND (WCBCAT = ?) AND (WCDESC = ?) AND (WCCMPY = ?) AND (WCIDENT = ?) AND (WCCLASS = ?) AND (WCSTYLE = ?) AND (WCCOLOR = ?) AND (WCSIZE = ?) AND (WCDSML = ?) AND (WCDLRG = ?) AND (WCDORD = ?)">
            <%--SelectCommand="SELECT WCBCTP, WCBCAT, WCDESC, WCCMPY, WCIDENT, WCCLASS, WCSTYLE, WCCOLOR, WCSIZE, WCDSML,WCDLRG,WCDORD FROM xxxx.WSP070 WHERE (WCBCTP = ? AND WCBCAT = ? AND WCDESC = ? AND WCCMPY = ? AND WCIDENT= ? AND WCCLASS = ? AND WCSTYLE = ? AND WCCOLOR = ? AND WCSIZE = ?) "--%>
            <SelectParameters>
             
             <asp:Parameter Name="WCBCTP" Type="String"/>
            <asp:Parameter Name="WCBCAT"/>
            <asp:Parameter Name="WCDESC"/>
            <asp:Parameter Name="WCCMPY"/>
            <asp:Parameter Name="WCIDENT" Type= "Int32"/>                 
            </SelectParameters>
            <InsertParameters>
                <asp:Parameter Name="WCBCTP" />
                <asp:Parameter Name="WCBCAT"/>
                <asp:Parameter Name="WCDESC"/>
                 <asp:Parameter Name="WCCMPY"/>
                <asp:Parameter Name="WCIDENT" Type= "Int32"/>
                <asp:Parameter Name="WCCLASS"/>
                 <asp:Parameter Name="WCSTYLE"/>
                <asp:Parameter Name="WCCOLOR"/>
                <asp:Parameter Name="WCSIZE"/>
                 <asp:Parameter Name="WCDSML"/>
                <asp:Parameter Name="WCDLRG"/>
                <asp:Parameter Name="WCDORD" Type= "Int32"/>                                   
            </InsertParameters>
            <UPDATEParameters>
                <asp:Parameter Name="WCBCTP"/>
                <asp:Parameter Name="WCBCAT"/>
                <asp:Parameter Name="WCDESC"/>
                 <asp:Parameter Name="WCCMPY"/>
                <asp:Parameter Name="WCIDENT" Type= "Int32"/>
                <asp:Parameter Name="WCCLASS"/>
                 <asp:Parameter Name="WCSTYLE"/>
                <asp:Parameter Name="WCCOLOR"/>
                <asp:Parameter Name="WCSIZE"/>
                 <asp:Parameter Name="WCDSML"/>
                <asp:Parameter Name="WCDLRG"/>
                <asp:Parameter Name="WCDORD" Type= "Int32"/>                                   
            </UPDATEParameters>
            <DELETEParameters>
                <asp:Parameter Name="WCBCTP"/>
                <asp:Parameter Name="WCBCAT"/>
                <asp:Parameter Name="WCDESC"/>
                 <asp:Parameter Name="WCCMPY"/>
                <asp:Parameter Name="WCIDENT" Type= "Int32"/>
                <asp:Parameter Name="WCCLASS"/>
                 <asp:Parameter Name="WCSTYLE"/>
                <asp:Parameter Name="WCCOLOR"/>
                <asp:Parameter Name="WCSIZE"/>
                 <asp:Parameter Name="WCDSML"/>
                <asp:Parameter Name="WCDLRG"/>
                <asp:Parameter Name="WCDORD" Type= "Int32"/>                                   
            </DELETEParameters>
        </asp:SqlDataSource>
        <br />
     </div>
    </form>
</body>
</html>
0
Iana Tsolova
Telerik team
answered on 08 Apr 2011, 01:12 PM
Hi Todd,

I reviewed your code and here are my findings:
    - You need to remove the NestedTableViewSettings. With DetailTables you only need the ParenttableRelations you defined above.
    - In the commands of the SqlDataSource controls, instead of the'?' signs try specifying the name of the corresponding parameter, for instance @WSBRAB.

Check it out and let me know if it makes any difference.

Greetings,
Iana
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Todd
Top achievements
Rank 1
Answers by
Iana Tsolova
Telerik team
Todd
Top achievements
Rank 1
Share this question
or