Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...New fields not populated with Data from SPNew fields not populated with Data from SP
Previous
 
Next
New Post
10/5/2010 8:28 PM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
this is strange indeed. are you sure, the sp is called and data is not derived from cache?
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/6/2010 9:43 AM
 
Paul Scarlett


www.tressleworks.ca
Joined: 4/16/2004
Posts: 493
Dan,

How are you populating your data object.  If you have followed the IHydratable interface you will need to explicitly populate the additional fields.  Alternatively, you may want to use this interface method (see http://www.charlesnurse.com/?tag=/cbo ) 

Paul.
 
New Post
10/6/2010 9:56 AM
 
Sergiy Velychko


Sergiy Velychko's Avatar

forDNN.com
Joined: 7/10/2005
Posts: 376
Dan

Can you just copy/paste names of the fields? We had one time the similar problem when names look the same, but they was not the same. It was fail when one char has been typed in different language, but it looks the same like English.

Sergey

forDNN Team is DotNetNuke Partner 

 
New Post
10/6/2010 10:04 AM
 
Dan Rowe

www.DTRTechnology.com
Joined: 12/10/2005
Posts: 93
Well I wish I could come up with some sort of valid excuse to why this was not working other then programmer stupidity but I can not. The name of the fields in the SP were not the same as those in the DAL.

Now that I have confessed to being human and dragging you into it. Could you clear up a new question you just raised in my mind.
that article indicates that the IDataReader is left open to the DB? How do I close this? Am I not using the correct method in my DAL to access data?
 
New Post
10/6/2010 11:57 AM
 
Paul Scarlett


www.tressleworks.ca
Joined: 4/16/2004
Posts: 493
Dan,

If you have explicit access to the DataReader, you can just close it (Datareader.close) .  You can check the open connections is SQL Management Studio and see if the open connections (spids) grows after every execution of your code. If you do leave a data reader connection open, you will get an issue pool connections.

Paul.
 
 Page 2 of 3
Previous123Next 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...New fields not populated with Data from SPNew fields not populated with Data from SP


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out