I use VS 2005 so I don't think there's a Reference folder in the solution explorer. Is this right?
Also the thing is I do see other properties and methods of SqlDataAdapter object. This makes me confused.

Yes - you might be right about the solution explorer. Unfortunately, the machine I am on right now doesn't have 2005. However, there still has to be a place where your references in your project can be viewed, is there not? Wherever that is it would be helpful to determine if you are specifically referencing a the System.Data.SqlClient.dll. Unless I am way off on this, your project should NOT be referencing this dll. This could be causing an ambiguity or other problem that manifests itself in the behavior you are experiencing.

Woody Z
http://www.learntoprogramnow.com

I don't know how to access the reference folder (if any?) in VS 2005. I think my project references set up is automatically done by VS 2005.

Well, if that is the case, then I'll try to find out how to deal with that. You should be able to see the references that a project (or ASP.NET environment) is using - they have to be stored somewhere.

Woody Z
http://www.learntoprogramnow.com