I tried to use some of the properties of SqlDataAdapter e.g. SelectCommand, Fill, etc. I don't see these properties listed in VS 2005 intellisense.

show your code.

Woody Z
http://www.learntoprogramnow.com

Here's the code:

SqlConnection MyConnection;
            SqlCommand MyCommand;
            SqlDataAdapter MyAdapter;
            DataTable MyTable = new DataTable();

            MyConnection = new SqlConnection();
            // MyConnection.ConnectionString = "server= E901872; Trusted_Connection= yes; database= AdventureWorks"; //This works too.
            MyConnection.ConnectionString = "Data Source= E901872; Initial Catalog= AdventureWorks; Integrated Security=True";
            // ConfigurationManager.ConnectionStrings["DSN_Northwind"].ConnectionString;

            MyCommand = new SqlCommand();
            MyCommand.CommandText = " SELECT TOP 5 * FROM Person.Contact ";
            MyCommand.CommandType = CommandType.Text;
            MyCommand.Connection = MyConnection;

// MyCommand.Connection.Open(); // Don't have to call this, copied this from Default.aspx.cs
            MyAdapter = new SqlDataAdapter();
            MyAdapter.SelectCommand = MyCommand;
            MyAdapter.Fill(MyTable);

            GridView1.DataSource = MyTable.DefaultView;
            GridView1.DataBind();

            MyAdapter.Dispose();
            MyCommand.Dispose();
            MyConnection.Dispose();

Everything looks fine regarding the SqlDataAdapter.

I assume you are getting intellisense on the other SqlClient objects such as the SqlCommand?

Does your code run?



Woody Z
http://www.learntoprogramnow.com

I see other properties and methods of the SqlDataAdapter class as well as all that of the SqlCommand in intellisense.

The code does not compile. It has the following errors:

Error 1 'SqlDataAdapter' does not contain a definition for 'SelectCommand'
Error 2 'SqlDataAdapter' does not contain a definition for 'Fill'

What other properties and methods are available on the MyAdapter object?

This is not a typical problem. If the other expected methods of the SqlDataAdapter are available, then something odd is going on. What Using statements have you used in the code - could you please show those?

Woody Z
http://www.learntoprogramnow.com

Yes, I think there's something odd going on. This seems to be not a typical problem. In intellisense, I was able to see all of the properties and methods of the MyAdapter object except for the properties like SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand. When I select to add the references, I see the System.Data.SqlClient.dll having a different version and a different path from the rest of other System namespaces on my pc.

Here's the Using statements I used in the code:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.Common;
using System.Data.SqlClient;

Thank you for your responds.

Your using statements all appear to be correct.
Another question:
Are you referencing the System.Data.SqlClient.dll directly? I don't see how you could be doing this without being aware of it.
However, if you are doing this, it is possible that is causing the problem.






Woody Z
http://www.learntoprogramnow.com

I don't know what you mean by referencing the System.Data.SqlClient.dll directly.
I just tried to fix the problem by looking at the add references list.

Thanks.

In the solution explorer each project has a References folder - this folder has a list of all the references set for the project. Do you have a listing for System.Data.SqlClient, or just System.Data. You should not have one for System.Data.SqlClient - and this is what I want to check.

Woody Z
http://www.learntoprogramnow.com