Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Output Parameter
Previous Previous
 
Next Next
New Post 6/14/2006 7:07 AM
User is offline Tammy Adkins
19 posts
www.dnnextras.com
10th Ranked


Re: Output Parameter 

Thanks so much Stefan for your input.  But doesn't executeNonQuery return no resultset?  I need to return a result set along with my output parameters.  I've come across this statement and not sure how to implement - anyone suggest?

"You need to replace this procedure: SqlHelper.ExecuteReader with one that will pass the variable by reference.  SqlHelper don't have one that I know of, so you need to write one of your own"

Suggestions?
 
New Post 6/14/2006 10:38 AM
User is offline Tammy Adkins
19 posts
www.dnnextras.com
10th Ranked


Re: Output Parameter 

Hey . . . . Is there any project in the core that mimics what I'm trying to do here?
 
New Post 6/14/2006 2:36 PM
User is offline Stefan Cullmann
1431 posts
6th Ranked








Re: Output Parameter 
Sorry and I really don't want to peeve you though the main focus will be the new DNN release for the next days. Your problem is not really DNN related, it is more about using ADO.NET. Perhaps you will realize this as chance to do it on your own. Just my two cents and not speaking for anybody else. 

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com

forms & Lists (UDT5.0) will be the next major release of the User Defined Table project.
A first Preview is available, though it requires DotnetNuke 5 (Beta 5).
 
New Post 6/14/2006 6:25 PM
User is offline Tammy Adkins
19 posts
www.dnnextras.com
10th Ranked


Re: Output Parameter 

Wow . . . didn't realize the entire forum was working on the new release.  Isn't this a forum for all developers or just core developers?  I have done this before in a standard aspx with ADO.NET - just couldn't work it into the DNN framework.  I have been working on this for 3 days now, guess I change direction.  I just can't stand not figuring something out - bugs me.  I have read through every post both on this forum and ASP.NET and not one good explanation on how to do this.

Just trying to participate in the community and hopefully someone will learn through my documented learning experience.  So sorry to have bugged you Stefan.

 
 
New Post 6/14/2006 11:44 PM
User is offline Stefan Cullmann
1431 posts
6th Ranked








Re: Output Parameter 

If you have no problem in a standard aspx, why don't you use the same routine as before. Nobody forces you to use the Microsoft.ApplicationBlocks.Data namespace.

It might help to google for Microsoft.ApplicationBlocks.Data and output parameter. It is not really DNN related. Have a look at http://weblogs.asp.net/tgraham/archive/2003/05/14/7031.aspx, this might help.

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com

forms & Lists (UDT5.0) will be the next major release of the User Defined Table project.
A first Preview is available, though it requires DotnetNuke 5 (Beta 5).
 
 Page 2 of 4Previous1234Next 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Output Parameter
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DNNSpired.com
Inspired to extend DotNetNuke®, everyday.
www.DNNSpired.com 		TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com 		DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP