CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!
Free 3 Months



Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.classifieds_starter_kit Tags:
Item Type: NewsGroup Date Entered: 6/27/2007 12:33:52 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 2 Views: 26 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
3 Items, 1 Pages 1 |< << Go >> >|
hughgallagher
Asp.Net User
dataadapter UpdateAd method not updating new fields added to xsd6/27/2007 12:33:52 PM

0/0

Hi,

 I am using the classified kit for a new projects at work and have run into a problem that is really eating into my time now.

 I have added new fields and gone ethrough the process of updating the Ads.xsd with the new parameters in the adapter methods etc.

The regenerated data adapter code regenerates the UpdateAd method with all the new parameters but when called is not updating the values back to the database! However I added some fields to the Ads.xsd previously and it is working for these fields!?! I did notice that these previous fields have been added to the data adapter "Update" (not UpdateAd) method whereas my new fields have not. I presume that is why the update is not working for my new fields. Anyone any ideas why the "Update method" is not including my new fields? (Help ... my nuts are on the line here!!!)

darkknight187
Asp.Net User
Re: dataadapter UpdateAd method not updating new fields added to xsd6/27/2007 10:21:45 PM

0/0

Did you update the parameters at the bottom of the editad page?

such as:

<UpdateParameters>

<asp:Parameter Name="original_Id" Type="Int32" />

<asp:ProfileParameter Type="Int32" Name="memberId" PropertyName="MemberId" />

<asp:Parameter Type="String" Name="title"></asp:Parameter>

<asp:Parameter Type="String" Name="description"></asp:Parameter>

<asp:Parameter Type="Decimal" Name="price"></asp:Parameter>

<asp:Parameter Type="String" Name="location"></asp:Parameter>

When I went through mine I forgot that part at first.

If that's not it I just want to clarify on the Ads.xsd file, you changed the code in it, right not just adding the columns.

code like:

 <UpdateCommand>

<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">

<CommandText>UpdateAd</CommandText>

<Parameters>

<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">

</Parameter>

<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">

</Parameter>

<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">

</Parameter>

<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">

</Parameter>

If you did those two major things already and the code for the .xsd file is in the same order for your new columns

as it is for each section, ie insert, update, relist . . .

Then list in detail what files you changed, and I'll tell you what you left out.

 


Be sure to visit www.detelli.com

And please remember to click ?Mark as Answer? on the post that helps you.
This can be beneficial to other community members reading the thread.
darkknight187
Asp.Net User
Re: dataadapter UpdateAd method not updating new fields added to xsd6/27/2007 10:23:54 PM

0/0

Also if you didn't notice the Ads.xsd file has two sections for udate ad.


Be sure to visit www.detelli.com

And please remember to click ?Mark as Answer? on the post that helps you.
This can be beneficial to other community members reading the thread.
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:


Web:
dataadapter UpdateAd method not updating new fields added to xsd ... dataadapter UpdateAd method not updating new fields added to xsd. Last post 06- 27-2007 6:23 PM by darkknight187. 2 replies. Sort Posts: ...
Announcements Module Problem - ng.asp-net-forum.portal_starter_kit ... dataadapter updatead method not updating new fields added to xsd · looking for cheap and good programmers to help me customize csk ...
dataadapter UpdateAd method not updating new fields added to xsd ... dataadapter UpdateAd method not updating new fields added to xsd. Last post 06- 27-2007 6:23 PM by darkknight187. 2 replies. Sort Posts: ...
Announcements Module Problem - ng.asp-net-forum.portal_starter_kit ... dataadapter updatead method not updating new fields added to xsd · looking for cheap and good programmers to help me customize csk ...
dataadapter UpdateAd method not updating new fields added to xsd ... dataadapter UpdateAd method not updating new fields added to xsd. Last post 06- 27-2007 6:23 PM by darkknight187. 2 replies. Sort Posts: ...
Announcements Module Problem - ng.asp-net-forum.portal_starter_kit ... dataadapter updatead method not updating new fields added to xsd · looking for cheap and good programmers to help me customize csk ...
dataadapter UpdateAd method not updating new fields added to xsd ... dataadapter UpdateAd method not updating new fields added to xsd. Last post 06- 27-2007 6:23 PM by darkknight187. 2 replies. Sort Posts: ...
Announcements Module Problem - ng.asp-net-forum.portal_starter_kit ... dataadapter updatead method not updating new fields added to xsd · looking for cheap and good programmers to help me customize csk ...
dataadapter UpdateAd method not updating new fields added to xsd ... dataadapter UpdateAd method not updating new fields added to xsd. Last post 06- 27-2007 6:23 PM by darkknight187. 2 replies. Sort Posts: ...
Announcements Module Problem - ng.asp-net-forum.portal_starter_kit ... dataadapter updatead method not updating new fields added to xsd · looking for cheap and good programmers to help me customize csk ...




Search This Site:










dal layer(1)

repeater control for categories

i have successfuly extended the starterkit, including more fields in ad, createuserwizard, etc, read more !

problem with the site: server glitch – or did i miss something?

an icon for each category

password recovery changes the password?

problem sorting myads

activating multiple inactive records

how to make the site bilingual?

type "profilecommon" is not defined

ad expiry notification system

does anyone know how to use icons or images along with category headings ?

a working site using csk

adding information to profile and ad

i dont want the page full reload when user choose another picture.

change main menu buttons to images

newbie in need of help with classified starter kit...permissions issue?

cannot add rows to sysdepends for the current object

pricing field

admin panel - textbox alignment

adding icon to category

love2trade.com sneakpeak...

problems with multiple namespaces

searching an advt with id or advt number

uploading or installing to run on godaddy

navigation button to search result…

formatting of user entered text

top level menus vs sub menus

extended classified starterkit beta -1

i am new to classifieds starter kit

  Privacy | Contact Us
All Times Are GMT