Ben's Random Mumbles - All Comments

Movenext and ASP.net | keyongtech

Movenext and ASP.net | keyongtech — Wed, 17 Jun 2009 16:07:40 GMT

Pingback from Movenext and ASP.net | keyongtech

re: Forms authentication on multiple subfolders in asp.net

Vetri — Fri, 27 Jun 2008 11:14:32 GMT

I need vb script for subfolders form authentication

Feed Search Engine - All Fresh Articles And News Are Here

Feed Search Engine - All Fresh Articles And News Are Here — Sun, 25 Nov 2007 19:20:33 GMT

Pingback from Feed Search Engine - All Fresh Articles And News Are Here

re: System.Drawing.Color.What?

Marco Trova — Fri, 05 Mar 2004 11:58:00 GMT

Are you having any problems with TallPDF.NET?

re: Passing SqlDataReader to Repeater OK?

Gauthier — Mon, 07 Jul 2003 21:19:00 GMT

Hello, I myself use the technique used in ASP.NET forum, because I only work with custom entities rather than DataSet and I prefer to at least have an abstraction layer between my presentational code (custom controls) and my Data Access code.

About the code snippet just on top of this comment, you would add a test to check if the datareader is not null:
IDataReader dr = null;
try
{
dr = SqlHelper.ExecuteReader(.......);
}
finally
{
if(dr != null) dr.Close();
}

I myself use the same approach in every of my DAL methods that use datareader, needless to say that I love DataAccess Application Block

re: Passing SqlDataReader to Repeater OK?

Ben Richardson — Tue, 01 Apr 2003 05:25:00 GMT

Thanks James, I don't know why I didn't think of that.

re: Passing SqlDataReader to Repeater OK?

James Avery — Tue, 01 Apr 2003 05:17:00 GMT

I always try and explicitly close the reader, what if the repeater errors in the middle of binding?? The connection would be left open. Here is what I think you should do. Be sure and create the reader with the CommandBehavior.CloseConnection option.

SqlDataReader oReader;
try
{
oReader = MyDAL.GetReader();
MyRepeater.DataSource = oReader;
MyRepeater.DataBind();
}
catch
{
\\exception work here
}
finally
{
oReader.Close();
}

Or something like that.

ADO.NET tips : ISerializable

TrackBack — Tue, 25 Feb 2003 05:08:00 GMT

ADO.NET tips : ISerializable