Won't this result in the database being called twice? Isn't the DataBind of the drop down list going to cause the reader to close? If not, then just close the reader...

MyReader = MyBusinessLayer.GetUsefulData();
MyDropDownList.DataSource = MyReader;
MyDropDownList.DataBind();
MyReader.Close()


Peter
------------------------------------------------------
Work smarter, not harder.

Yeah, I wondered too if this calls the database twice.

Somehow, you'd think that you just call the Close method on the returned reader. But I guess that to get that Reader, the code in GetUsefulData is called again.

Either way, closing just the Reader should work fine, and IMHO, it looks more natural than closing the result of the method....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.