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
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

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">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
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
>
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