the SqlDatasource. I am using C# and Asp.net 2.0.
Getting the following error:
You have specified that your delete command compares all values on
SqlDataSource 'sdsAddEdit', but the dictionary passed in for values is empty.
Pass in a valid dictionary for delete or change your mode to
OverwriteChange s.
Here is my markup. Any suggestions. This is a framework error that seems
to occur before a call to the database is made.
<asp:SqlDataSou rce ID="sdsAddEdit " runat="server"
ConflictDetecti on="CompareAllV alues" ConnectionStrin g="<%$
ConnectionStrin gs:centiv_nexiv 2 %>"
OnUpdating="sds AddEdit_Updatin g"
DeleteCommand=" UPDATE [wws_logolocker] SET [active] = 0
WHERE [pk] = @pk "
InsertCommand=" exec dbo.SP_WW_NEWID 'wws_logolocker ', @pk
output; INSERT INTO [wws_logolocker] ([pk], [corpid], [active], [descript],
[image], [sSVGImage]) VALUES (@pk, @corpid, @active, @descript, @image,
@sSVGImage); Select @pk = Scope_Identity( )"
SelectCommand=" SELECT [pk], [corpid], [custpk], [active],
[descript], [image], ISNULL([sSVGImage],'') AS sSVGImage, [bAllDistUsers],
[LanguageID], CASE WHEN Charindex('.ai' ,[image]) > 0 THEN Left([image],
CharIndex('.ai' , [image]) - 1) WHEN Charindex('.cdr ',[image]) > 0 THEN
Left([image], CharIndex('.cdr ', [image]) - 1) WHEN Charindex('.jpg ',[image])
0 THEN Left([image], CharIndex('.jpg ', [image]) - 1) ELSE [image] END as FileNoExt FROM [wws_logolocker] WHERE ([corpid] = @corpid AND [pk] = @pk)"
UpdateCommand=" UPDATE [wws_logolocker] SET [active] =
@active, [descript] = @descript, [image] = @image, [sSVGImage] = @sSVGImage,
[bAllDistUsers] = @bAllDistUsers WHERE [pk] = @original_pk AND [active] =
@original_activ e AND [descript] = @original_descr ipt AND [image] =
@original_image AND [sSVGImage] = @original_sSVGI mage AND [bAllDistUsers] =
@original_bAllD istUsers"
OldValuesParame terFormatString ="original_{ 0}"
<DeleteParamete rs>
<asp:Paramete r Name="original_ pk" Type="Int32" />
<asp:Paramete r Name="original_ corpid" Type="Int32" />
<asp:Paramete r Name="original_ descript"
Type="String" />
<asp:Paramete r Name="original_ active" Type="Boolean"
/>
<asp:Paramete r Name="original_ custpk" Type="Int32" />
<asp:Paramete r Name="original_ image" Type="String" />
<asp:Paramete r Name="original_ sSVGImage"
Type="String" />
<asp:Paramete r Name="original_ bAllDistUsers"
Type="Boolean" />
<asp:Paramete r Name="original_ LanguageID"
Type="Int32" />
</DeleteParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="corpid" Type="Int32" />
<asp:Paramete r Name="descript" Type="String" />
<asp:Paramete r Name="active" Type="Boolean" />
<asp:Paramete r Name="custpk" Type="Int32" />
<asp:Paramete r Name="image" Type="String" />
<asp:Paramete r Name="sSVGImage " Type="String"
ConvertEmptyStr ingToNull="fals e" />
<asp:Paramete r Name="bAllDistU sers" Type="Boolean" />
<asp:Paramete r Name="LanguageI D" Type="Int32" />
<asp:Paramete r Name="original_ pk" Type="Int32" />
<asp:Paramete r Name="original_ corpid" Type="Int32" />
<asp:Paramete r Name="original_ descript"
Type="String" ConvertEmptyStr ingToNull="fals e"/>
<asp:Paramete r Name="original_ active" Type="Boolean"
/>
<asp:Paramete r Name="original_ custpk" Type="Int32" />
<asp:Paramete r Name="original_ image" Type="String"
ConvertEmptyStr ingToNull="fals e" />
<asp:Paramete r Name="original_ sSVGImage"
Type="String" DefaultValue="" ConvertEmptyStr ingToNull="fals e" />
<asp:Paramete r Name="original_ bAllDistUsers"
Type="Boolean" />
<asp:Paramete r Name="original_ LanguageID"
Type="Int32" />
</UpdateParameter s>
<InsertParamete rs>
<asp:Paramete r Name="pk" Type="Int32" />
<asp:Paramete r Name="corpid" Type="Int32" />
<asp:Paramete r Name="descript" Type="String" />
<asp:Paramete r Name="active" Type="Boolean" />
<asp:Paramete r Name="custpk" Type="Int32" />
<asp:Paramete r Name="image" Type="String" />
<asp:Paramete r Name="sSVGImage " Type="String" />
<asp:Paramete r Name="bAllDistU sers" Type="Boolean" />
<asp:Paramete r Name="LanguageI D" Type="Int32" />
</InsertParameter s>
<SelectParamete rs>
<asp:QueryStrin gParameter Name="corpid"
QueryStringFiel d="CorpID" Type="Int32" />
<asp:ControlPar ameter ControlID="gvLo gos"
PropertyName="S electedValue" Name="pk" Type="int32" />
</SelectParameter s>
</asp:SqlDataSour ce>