PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Is dispose necessary in this scenario with datasets and adapters?

Reply

Is dispose necessary in this scenario with datasets and adapters?

 
Thread Tools Rate Thread
Old 11-04-2006, 06:29 PM   #1
pkellnernews@comcast.net
Guest
 
Posts: n/a
Default Is dispose necessary in this scenario with datasets and adapters?


I typically make calls like this:

UsersTableAdapter usersTableAdapter = new UsersTableAdapter();
DataSetUsers.UsersDataTable usersDataTable
= usersTableAdapter.GetById(idUser);

Is it necessary (or recommended) to do this:

usersDataTable.DisplayExpression();
usersTableAdapter.Dispose();

Thanks,

Peter Kellner
http://peterkellner.net
Peter Kellner
http://peterkellner.net
  Reply With Quote
Old 12-04-2006, 09:27 AM   #2
Miha Markic [MVP C#]
Guest
 
Posts: n/a
Default Re: Is dispose necessary in this scenario with datasets and adapters?

IDisposable is a contract meaning you have to call Dispose to be on the safe
side.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

<pkellnernews@comcast.net> wrote in message
news:skpn321s0t39kpenooj9b2igljh6gkpcge@4ax.com...
>I typically make calls like this:
>
> UsersTableAdapter usersTableAdapter = new UsersTableAdapter();
> DataSetUsers.UsersDataTable usersDataTable
> = usersTableAdapter.GetById(idUser);
>
> Is it necessary (or recommended) to do this:
>
> usersDataTable.DisplayExpression();
> usersTableAdapter.Dispose();
>
> Thanks,
>
> Peter Kellner
> http://peterkellner.net
> Peter Kellner
> http://peterkellner.net



  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off