PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 1.00 average.

ASP.NET binding to DataReader

 
 
Andrew Robinson
Guest
Posts: n/a
 
      24th Aug 2007
I have a large collection of DAL code that returns lists of entities
(List<entity>) for general binding operations usually to a GridView via an
ObjectDataSource.

I think about binding directly to a SqlDataReader but how do I insure that
the Reader and its associated Connection both get closed? I would like to
continue using ObjectDataSources and am pretty sure I can pass a reader back
through this guy.

Thanks,

Andy

 
Reply With Quote
 
 
 
 
Steven Cheng[MSFT]
Guest
Posts: n/a
 
      27th Aug 2007
Hi Andrew,

Regarding on this issue, I've found your another thread in the following
group:

Subject: ASP.NET binding to DataReader
Newsgroups: microsoft.public.dotnet.framework.aspnet

some community member and I have replied you there. Please feel free to
have a look and continue followup there.

Thanks for your posting!

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
>From: "Andrew Robinson" <(E-Mail Removed)>
>Subject: ASP.NET binding to DataReader
>Date: Fri, 24 Aug 2007 08:52:27 -0700
>Lines: 13
>MIME-Version: 1.0
>Content-Type: text/plain;
> format=flowed;
> charset="iso-8859-1";
> reply-type=original
>Content-Transfer-Encoding: 7bit
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
>X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
>Message-ID: <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.framework.adonet
>NNTP-Posting-Host: ip2.dewaardandjones.com 66.114.43.138
>Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.dotnet.framework.adonet:6158
>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>
>I have a large collection of DAL code that returns lists of entities
>(List<entity>) for general binding operations usually to a GridView via an
>ObjectDataSource.
>
>I think about binding directly to a SqlDataReader but how do I insure that
>the Reader and its associated Connection both get closed? I would like to
>continue using ObjectDataSources and am pretty sure I can pass a reader

back
>through this guy.
>
>Thanks,
>
>Andy
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET binding to DataReader Andrew Robinson Microsoft ASP .NET 8 28th Aug 2007 05:08 AM
Datareader binding to datagrid not working tshad Microsoft VB .NET 3 26th Jan 2006 05:54 AM
Binding combobox with datareader??? Annie Microsoft C# .NET 4 3rd Oct 2005 04:33 AM
Binding a datareader to a grid John Dann Microsoft ADO .NET 12 25th Jul 2004 07:42 AM
Binding a Datareader to Dropdown Brian Conway Microsoft ASP .NET 4 11th May 2004 06:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:27 AM.